Debian Codegraph @

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

raw
1 connect a,localhost,root,,;
2 connect b,localhost,root,,;
3 CREATE TABLE bug47622(
4 `rule_key` int(11) NOT NULL DEFAULT '0',
5 `seq` smallint(6) NOT NULL DEFAULT '0',
6 `action` smallint(6) NOT NULL DEFAULT '0',
7 `arg_id` smallint(6) DEFAULT NULL,
8 `else_ind` TINYINT NOT NULL,
9 KEY IDX_A (`arg_id`)
10 ) ENGINE=InnoDB;
11 connection a;
12 ALTER TABLE bug47622 ADD UNIQUE IDX_B (rule_key,else_ind,seq,action,arg_id);
13 drop index IDX_B on bug47622;
14 connection b;
15 create index idx on bug47622(seq, arg_id);
16 ALTER TABLE bug47622 ADD UNIQUE IDX_X (rule_key,else_ind,seq,action);
17 drop table bug47622;
18 CREATE TABLE bug47622 (
19 `a` int(11) NOT NULL,
20 `b` int(11) DEFAULT NULL,
21 `c` char(10) DEFAULT NULL,
22 `d` varchar(20) DEFAULT NULL,
23 PRIMARY KEY (`a`),
24 KEY `b` (`b`)
25 ) ENGINE=InnoDB;
26 alter table bug47622 add unique index (c), add index (d);
27 drop table bug47622;