Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 # This is the test for bug 46000. We shall
3 # block any index creation with the name of
4 # "GEN_CLUST_INDEX", which is the reserved
5 # name for innodb default primary index.
6
7
8 # This 'create table' operation should fail because of
9 # using the reserve name as its index name.
10 --error ER_WRONG_NAME_FOR_INDEX
11 create table bug46000(`id` int,key `GEN_CLUST_INDEX`(`id`))engine=innodb;
12
13 # Mixed upper/lower case of the reserved key words
14 --error ER_WRONG_NAME_FOR_INDEX
15 create table bug46000(`id` int, key `GEN_clust_INDEX`(`id`))engine=innodb;
16
17 show warnings;
18
19 create table bug46000(id int) engine=innodb;
20
21 # This 'create index' operation should fail.
22 --error ER_WRONG_NAME_FOR_INDEX
23 create index GEN_CLUST_INDEX on bug46000(id);
24
25 show warnings;
26
27 # This 'create index' operation should succeed, no
28 # temp table left from last failed create index
29 # operation.
30 create index idx on bug46000(id);
31
32 drop table bug46000;