From b42412599210eb6082b503af144c62613645372a Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Mon, 1 Aug 2005 17:06:43 +0000
Subject: Bug 301901: Index rename failure when renaming an index called
 PRIMARY Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=justdave,
 a=justdave

---
 Bugzilla/DB/Schema/Mysql.pm | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'Bugzilla/DB')

diff --git a/Bugzilla/DB/Schema/Mysql.pm b/Bugzilla/DB/Schema/Mysql.pm
index 2c7d80b36..ba6ac7280 100644
--- a/Bugzilla/DB/Schema/Mysql.pm
+++ b/Bugzilla/DB/Schema/Mysql.pm
@@ -184,6 +184,9 @@ sub get_rename_indexes_ddl {
         my $type = $indexes{$old_name}->{TYPE};
         $type ||= 'INDEX';
         my $fields = join(',', @{$indexes{$old_name}->{FIELDS}});
+        # $old_name needs to be escaped, sometimes, because it was
+        # a reserved word.
+        $old_name = '`' . $old_name . '`';
         $sql .= " ADD $type $name ($fields), DROP INDEX $old_name,";
     }
     # Remove the last comma.
-- 
cgit v1.2.3-24-g4f1b