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