Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug46000.result

raw
1 create table bug46000(`id` int,key `GEN_CLUST_INDEX`(`id`))engine=innodb;
2 ERROR 42000: Incorrect index name 'GEN_CLUST_INDEX'
3 create table bug46000(`id` int, key `GEN_clust_INDEX`(`id`))engine=innodb;
4 ERROR 42000: Incorrect index name 'GEN_CLUST_INDEX'
5 show warnings;
6 Level Code Message
7 Warning 1280 Cannot Create Index with name 'GEN_CLUST_INDEX'. The name is reserved for the system default primary index.
8 Error 1280 Incorrect index name 'GEN_CLUST_INDEX'
9 Error 1030 Got error 124 - 'Wrong index given to function' from storage engine
10 create table bug46000(id int) engine=innodb;
11 create index GEN_CLUST_INDEX on bug46000(id);
12 ERROR 42000: Incorrect index name 'GEN_CLUST_INDEX'
13 show warnings;
14 Level Code Message
15 Warning 1280 Cannot Create Index with name 'GEN_CLUST_INDEX'. The name is reserved for the system default primary index.
16 Error 1280 Incorrect index name 'GEN_CLUST_INDEX'
17 create index idx on bug46000(id);
18 drop table bug46000;