EVOLUTION-MANAGER

Edit File: ignore_table_autoinc-9737.result

include/master-slave.inc [connection master] call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); create table t1(id int auto_increment primary key); create table t2(id int auto_increment primary key); connection slave; create table slave_only(id int auto_increment primary key); insert into slave_only values(NULL); create trigger t1i after insert on t1 for each row insert into slave_only values(NULL); stop slave; set global replicate_ignore_table="test.t2"; start slave; connection master; insert into t2 values(NULL); insert into t1 values(NULL); connection slave; drop table t1, t2, slave_only; stop slave; set global replicate_ignore_table=""; start slave; connection master; drop table t1, t2; include/rpl_end.inc