Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mdev38731.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_row.inc
3 --source include/master-slave.inc
4
5 CREATE TABLE t (a int, b int, c int, d int, KEY (d)) ENGINE=InnoDB;
6 INSERT INTO t (a,b,d) VALUES
7 (1,NULL,4),(2,NULL,1),(3,NULL,1),
8 (4,NULL,1),(5,NULL,1),(6,NULL,1),
9 (7,0,NULL),(8,NULL,NULL);
10 ALTER TABLE t ADD UNIQUE (b);
11 --sync_slave_with_master
12 ANALYZE TABLE t;
13 --connection master
14 UPDATE t SET c = 1;
15 ALTER TABLE t ADD UNIQUE (a);
16
17 --sync_slave_with_master
18
19 --connection master
20 DROP TABLE t;
21 --source include/rpl_end.inc