Debian Codegraph @

mysql-test/suite/rpl/r/ignore_table_autoinc-9737.result

raw
1 include/master-slave.inc
2 [connection master]
3 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
4 create table t1(id int auto_increment primary key);
5 create table t2(id int auto_increment primary key);
6 connection slave;
7 create table slave_only(id int auto_increment primary key);
8 insert into slave_only values(NULL);
9 create trigger t1i after insert on t1 for each row insert into slave_only values(NULL);
10 stop slave;
11 set global replicate_ignore_table="test.t2";
12 start slave;
13 connection master;
14 insert into t2 values(NULL);
15 insert into t1 values(NULL);
16 connection slave;
17 drop table t1, t2, slave_only;
18 stop slave;
19 set global replicate_ignore_table="";
20 start slave;
21 connection master;
22 drop table t1, t2;
23 include/rpl_end.inc