Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 #
4 # Fix MySQL Bug#20755615: InnoDB compares column names case sensitively,
5 # while according to Storage Engine API column names should be compared
6 # case insensitively. This can cause FRM and InnoDB data dictionary to
7 # go out of sync:
8 #
9
10 CREATE TABLE t1 (D INT) ENGINE=innodb;
11 INSERT INTO t1 VALUES (10);
12 ALTER TABLE t1 MODIFY COLUMN d INT;
13 ALTER TABLE t1 ADD INDEX my_d (d);
14 SHOW CREATE TABLE t1;
15 INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9);
16 INSERT INTO t1 SELECT * FROM t1;
17 INSERT INTO t1 SELECT * FROM t1;
18 INSERT INTO t1 SELECT * FROM t1;
19 INSERT INTO t1 SELECT * FROM t1;
20 INSERT INTO t1 SELECT * FROM t1;
21 INSERT INTO t1 SELECT * FROM t1;
22 INSERT INTO t1 SELECT * FROM t1;
23 EXPLAIN SELECT d FROM t1 WHERE d = 5;
24 EXPLAIN SELECT D FROM t1 WHERE D = 5;
25 ALTER TABLE t1 DROP INDEX my_d;
26 ALTER TABLE t1 MODIFY COLUMN D INT;
27 ANALYZE TABLE t1;
28 ALTER TABLE t1 ADD INDEX my_d (D);
29 EXPLAIN SELECT d FROM t1 WHERE d = 5;
30 EXPLAIN SELECT D FROM t1 WHERE D = 5;
31 SHOW CREATE TABLE t1;
32 DROP TABLE t1;