Latest change for MySQL "as rows" breaks the macro fo SQLITE

[markm]

I was getting an error saying that the DB was locked.

When I remove the 'as rows' change that was implemented in the latest change committed it worked again.

Note - I also noticed a mix of tabs and spaces in the file.

[markm]

Patch to fix for SQLITE (but maybe not work for Mysql?) and remove tabs

[anonymous]

Ahh - there is a better fix!!

It would seem that rows is a restricted/reserved word for Sqlite - if you change that to as TempTable then it still works for Sqlite - and hopefully works for MySQL also :)

Thanks

Mark

[Ryan J Ollos]

Thanks for the patch. It will be tested and applied this evening.

[Ryan J Ollos]

It seems to be happy with either as rows or as temptable in my test setup. However, I'll make the change since it seems at most harmless.

[Ryan J Ollos]

(In [9626])

• Removed print statements.
• Replaced rows with temptable in query because rows is a reserved work in SQLite. Fixes #7735.

[Ryan J Ollos]

(In [11971]) Deleted .pydevproject file accidentally committed in [9626].