Update of /cvsroot/lxr/lxr/lib/LXR/Index
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv14065/lib/LXR/Index
Modified Files:
Mysql.pm
Log Message:
Fix bug [ 1645267 ] problem with MySQL syntax in delete statement
Change MySQL delete statements as per bug report
Index: Mysql.pm
===================================================================
RCS file: /cvsroot/lxr/lxr/lib/LXR/Index/Mysql.pm,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -d -r1.21 -r1.22
--- Mysql.pm 23 Mar 2009 12:27:18 -0000 1.21
+++ Mysql.pm 23 Mar 2009 13:29:15 -0000 1.22
@@ -112,24 +112,24 @@
"insert into ${prefix}declarations (declid, langid, declaration) values (NULL, ?, ?)");
$self->{delete_indexes} =
- $self->{dbh}->prepare("delete from ${prefix}indexes "
+ $self->{dbh}->prepare("delete from i "
. "using ${prefix}indexes i, ${prefix}releases r "
. "where i.fileid = r.fileid "
. "and r.rel = ?");
$self->{delete_useage} =
- $self->{dbh}->prepare("delete from ${prefix}useage "
+ $self->{dbh}->prepare("delete from u "
. "using ${prefix}useage u, ${prefix}releases r "
. "where u.fileid = r.fileid "
. "and r.rel = ?");
$self->{delete_status} =
- $self->{dbh}->prepare("delete from ${prefix}status "
+ $self->{dbh}->prepare("delete from s "
. "using ${prefix}status s, ${prefix}releases r "
. "where s.fileid = r.fileid "
. "and r.rel = ?");
$self->{delete_releases} =
$self->{dbh}->prepare("delete from ${prefix}releases " . "where rel = ?");
$self->{delete_files} =
- $self->{dbh}->prepare("delete from ${prefix}files "
+ $self->{dbh}->prepare("delete from f "
. "using ${prefix}files f, ${prefix}releases r "
. "where f.fileid = r.fileid "
. "and r.rel = ?");
|
