Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_drop_index.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE TABLE t1 (a INT, b INT);
5 CREATE INDEX i1 ON t1 (a);
6 CREATE OR REPLACE INDEX i1 ON t1 (a, b);
7 connection slave;
8 SHOW CREATE TABLE t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `a` int(11) DEFAULT NULL,
12 `b` int(11) DEFAULT NULL,
13 KEY `i1` (`a`,`b`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 connection master;
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `a` int(11) DEFAULT NULL,
20 `b` int(11) DEFAULT NULL,
21 KEY `i1` (`a`,`b`)
22 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
23 DROP TABLE t1;
24 connection slave;
25 include/rpl_end.inc