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 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