Ticket #7735 (closed defect: fixed)

Opened 3 years ago

Last modified 9 months ago

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

Reported by: markm Assigned to: rjollos
Priority: normal Component: WikiSearchMacro
Severity: normal Keywords:
Cc: mark.m.mcmahon@gmail.com Trac Release: 0.11

Description

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.

Attachments

UndoAsRows_fix_tabs.patch (0.5 kB) - added by markm on 09/26/10 16:53:08.
Patch to fix for SQLITE (but maybe not work for Mysql?) and remove tabs

Change History

09/26/10 16:53:08 changed by markm

  • attachment UndoAsRows_fix_tabs.patch added.

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

09/26/10 16:56:02 changed by 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

12/04/10 05:30:07 changed by rjollos

  • status changed from new to assigned.

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

12/07/10 02:39:39 changed by rjollos

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.

12/07/10 02:41:18 changed by rjollos

  • status changed from assigned to closed.
  • resolution set to fixed.

(In [9626])

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

09/11/12 07:34:45 changed by rjollos

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

Add/Change #7735 (Latest change for MySQL "as rows" breaks the macro fo SQLITE)




Change Properties
Action