Debian Codegraph @

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

raw
1 CREATE TABLE bug47622(
2 `rule_key` int(11) NOT NULL DEFAULT '0',
3 `seq` smallint(6) NOT NULL DEFAULT '0',
4 `action` smallint(6) NOT NULL DEFAULT '0',
5 `arg_id` smallint(6) DEFAULT NULL,
6 `else_ind` TINYINT NOT NULL,
7 KEY IDX_A (`arg_id`)
8 ) ENGINE=InnoDB;
9 Warnings:
10 Warning 1681 Integer display width is deprecated and will be removed in a future release.
11 Warning 1681 Integer display width is deprecated and will be removed in a future release.
12 Warning 1681 Integer display width is deprecated and will be removed in a future release.
13 Warning 1681 Integer display width is deprecated and will be removed in a future release.
14 ALTER TABLE bug47622 ADD UNIQUE IDX_B (rule_key,else_ind,seq,action,arg_id);
15 drop index IDX_B on bug47622;
16 create index idx on bug47622(seq, arg_id);
17 ALTER TABLE bug47622 ADD UNIQUE IDX_X (rule_key,else_ind,seq,action);
18 drop table bug47622;
19 CREATE TABLE bug47622 (
20 `a` int(11) NOT NULL,
21 `b` int(11) DEFAULT NULL,
22 `c` char(10) DEFAULT NULL,
23 `d` varchar(20) DEFAULT NULL,
24 PRIMARY KEY (`a`),
25 KEY `b` (`b`)
26 ) ENGINE=InnoDB;
27 Warnings:
28 Warning 1681 Integer display width is deprecated and will be removed in a future release.
29 Warning 1681 Integer display width is deprecated and will be removed in a future release.
30 alter table bug47622 add unique index (c), add index (d);
31 drop table bug47622;