Debian Codegraph @

mysql-test/suite/rpl/t/ignore_table_autoinc-9737.test

raw
1 #
2 # MDEV-9737 Duplicate error in replication with slave triggers and auto increment
3 #
4 source include/master-slave.inc;
5 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
6
7
8 create table t1(id int auto_increment primary key);
9 create table t2(id int auto_increment primary key);
10
11 sync_slave_with_master;
12 create table slave_only(id int auto_increment primary key);
13 insert into slave_only values(NULL);
14 create trigger t1i after insert on t1 for each row insert into slave_only values(NULL);
15
16 stop slave;
17 set global replicate_ignore_table="test.t2";
18 start slave;
19
20 connection master;
21 insert into t2 values(NULL);
22 insert into t1 values(NULL);
23
24 sync_slave_with_master;
25
26 drop table t1, t2, slave_only;
27 stop slave;
28 set global replicate_ignore_table="";
29 start slave;
30
31 connection master;
32 drop table t1, t2;
33
34 source include/rpl_end.inc;
35