source include/master-slave.inc; create table t1 (a int); create table t2 (a int); insert into t1 values (1); insert into t2 values (1); delete t1.* from t1, t2 where t1.a = t2.a; save_master_pos; select * from t1; select * from t2; connection slave; sync_with_master; select * from t1; select * from t2; # End of 4.1 tests # Check if deleting 0 rows is binlogged (BUG#13348) connection master; delete from t1; delete from t2; sync_slave_with_master; # force a difference to see if master's multi-DELETE will correct it insert into t1 values(1); insert into t2 values(1); connection master; DELETE t1.*, t2.* from t1, t2; sync_slave_with_master; select * from t1; select * from t2; connection master; drop table t1,t2; sync_slave_with_master;