Opened 6 years ago

Closed 6 years ago

Last modified 4 years ago

#7735 closed defect (fixed)

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

Reported by: markm Owned by: rjollos
Priority: normal Component: WikiSearchMacro
Severity: normal Keywords:
Cc: mark.m.mcmahon@… Trac Release: 0.11


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 (1)

UndoAsRows_fix_tabs.patch (559 bytes) - added by markm 6 years ago.
Patch to fix for SQLITE (but maybe not work for Mysql?) and remove tabs

Download all attachments as: .zip

Change History (6)

Changed 6 years ago by markm

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

comment:1 Changed 6 years ago 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 :)



comment:2 Changed 6 years ago by rjollos

  • Status changed from new to assigned

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

comment:3 Changed 6 years ago 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.

comment:4 Changed 6 years ago by rjollos

  • Resolution set to fixed
  • Status changed from assigned to closed

(In [9626])

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

comment:5 Changed 4 years ago by rjollos

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

Add Comment

Modify Ticket

as closed The owner will remain rjollos.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.