Quota column name 'key' in downgrade script
006_mysql_downgrade didn't correctly quote 'key' column of 'image_properties' table when creating index, the index wasn't created as needed, and then operator could not run any upgrade script successfully since 006_mysql_upgrade script could not to handle this unexpected db status. Note, this issue doesn't impact one-way upgrade migration operation, since bug existed in downgrade script. But once operator do a reciprocating migration operation, this issue will rise up as a blocker. Closes-bug: 1351413 Change-Id: Ie1ed1b7f06b8a0aeede70c3d4dd061c857e448da Signed-off-by: Zhi Yan Liu <zhiyanl@cn.ibm.com>
This commit is contained in:
parent
ca4e2a1f26
commit
579e0c1875
|
@ -8,4 +8,4 @@ DROP INDEX ix_image_properties_image_id_name ON image_properties;
|
|||
ALTER TABLE image_properties
|
||||
CHANGE COLUMN name `key` VARCHAR(255) NOT NULL;
|
||||
|
||||
CREATE UNIQUE INDEX ix_image_properties_image_id_key ON image_properties (image_id, key);
|
||||
CREATE UNIQUE INDEX ix_image_properties_image_id_key ON image_properties (image_id, `key`);
|
||||
|
|
Loading…
Reference in New Issue