[patch] quote release column name to prevent error in newer mysql versions

quote-release-keyword.patch (text/plain), 1.15 KB, created by Torsten Kaiser on 2012-11-22 20:58:11 UTC

--- /usr/lib/perl5/vendor_perl/5.16.1/LXR/Index/Mysql.pm~	2012-11-21 19:43:56.000000000 +0100
+++ /usr/lib/perl5/vendor_perl/5.16.1/LXR/Index/Mysql.pm	2012-11-21 22:01:50.819208842 +0100
@@ -78,9 +78,9 @@
 	  );
 
 	$self->{releases_select} =
-	  $self->{dbh}->prepare("select * from ${prefix}releases where fileid = ? and  release = ?");
+	  $self->{dbh}->prepare("select * from ${prefix}releases where fileid = ? and  `release` = ?");
 	$self->{releases_insert} =
-	  $self->{dbh}->prepare("insert into ${prefix}releases (fileid, release) values (?, ?)");
+	  $self->{dbh}->prepare("insert into ${prefix}releases (fileid, `release`) values (?, ?)");
 
 	$self->{status_get} =
 	  $self->{dbh}->prepare("select status from ${prefix}status where fileid = ?");
@@ -127,7 +127,7 @@
 		  . "where s.fileid = r.fileid "
 		  . "and r.release = ?");
 	$self->{delete_releases} =
-	  $self->{dbh}->prepare("delete from ${prefix}releases " . "where release = ?");
+	  $self->{dbh}->prepare("delete from ${prefix}releases " . "where `release` = ?");
 	$self->{delete_files} =
 	  $self->{dbh}->prepare("delete from ${prefix}files "
 		  . "using ${prefix}files f, ${prefix}releases r "