Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE TABLE t (a int, b int, c int, d int, KEY (d)) ENGINE=InnoDB;
4 INSERT INTO t (a,b,d) VALUES
5 (1,NULL,4),(2,NULL,1),(3,NULL,1),
6 (4,NULL,1),(5,NULL,1),(6,NULL,1),
7 (7,0,NULL),(8,NULL,NULL);
8 ALTER TABLE t ADD UNIQUE (b);
9 connection slave;
10 ANALYZE TABLE t;
11 Table Op Msg_type Msg_text
12 test.t analyze status Engine-independent statistics collected
13 test.t analyze status OK
14 connection master;
15 UPDATE t SET c = 1;
16 ALTER TABLE t ADD UNIQUE (a);
17 connection slave;
18 connection master;
19 DROP TABLE t;
20 include/rpl_end.inc