[Lxr-commits] CVS: lxr/lib/LXR/Index Mysql.pm,1.21,1.22

[Malcolm B. <mb...@us...>]

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 = ?");