[Lxr-dev] [ lxr-Bugs-1645267 ] problem with MySQL syntax in delete statement

[SourceForge.net <no...@so...>]

Bugs item #1645267, was opened at 2007-01-26 14:01
Message generated for change (Settings changed) made by darope
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=390117&aid=1645267&group_id=27350

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database interface
Group: v0.9.4
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Florian Zschocke (darope)
Assigned to: Nobody/Anonymous (nobody)
>Summary: problem with MySQL syntax in delete statement

Initial Comment:
The genxref, when called with parameter --reindexall, generates MySQL errors when used with a MySQL 5.0 backend.

DBD::mysql::st execute failed: Unknown table 'lxr_indexes' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 334.
DBD::mysql::st execute failed: Unknown table 'lxr_useage' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 335.
DBD::mysql::st execute failed: Unknown table 'lxr_status' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 336.
DBD::mysql::st execute failed: Unknown table 'lxr_files' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 338.


The problem appeas to lie in the MySQL statements used for "delete_indexes", "delete_useage", "delete_status" and "delete_files" in Mysql.pm.

Between lines 114 and 131 the statements are defined as
"delete from ${prefix}indexes using ${prefix}indexes i, ${prefix}releases r where ...".
This is not working and according to the MySQL manual not correct syntax. Since aliases are used, the alias has to be used with DELETE, too. The correct sytnax (which works for me) would be:
"delete from i using ${prefix}indexes i, ${prefix}releases r where ..."

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=390117&aid=1645267&group_id=27350