[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 13:01
Message generated for change (Settings changed) made by mbox
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: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Florian Zschocke (darope)
>Assigned to: Malcolm Box (mbox)
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 ..."

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

Comment By: Malcolm Box (mbox)
Date: 2009-03-23 13:30

Message:
This has now been fixed in CVS.

If you can install the new version and check that it solves your
problem, then it would be very useful.

Thanks for reporting this defect and helping to make LXR better.

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

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