Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug44571.test

raw
1 --source include/have_innodb.inc
2 #
3 # Bug#44571 InnoDB Plugin crashes on ADD INDEX
4 # http://bugs.mysql.com/44571
5 # Please also refer to related fix in
6 # http://bugs.mysql.com/47621
7 #
8
9 CREATE TABLE bug44571 (foo INT) ENGINE=InnoDB;
10 ALTER TABLE bug44571 CHANGE foo bar INT;
11 # Create index with the old column name will fail,
12 # because the CHANGE foo bar is successful. And
13 # the column name change would communicate to
14 # InnoDB with the fix from bug #47621
15 -- error ER_KEY_COLUMN_DOES_NOT_EXIST
16 ALTER TABLE bug44571 ADD INDEX bug44571b (foo);
17 # The following create indexes should succeed,
18 # indirectly confirm the CHANGE foo bar is successful.
19 ALTER TABLE bug44571 ADD INDEX bug44571c (bar);
20 DROP INDEX bug44571c ON bug44571;
21 CREATE INDEX bug44571c ON bug44571 (bar);
22 DROP TABLE bug44571;