1#multi delete replication bugs 2 3 4source include/master-slave.inc; 5 6#BUG#11139 - improper wild-table and table rules 7#checking for multi deletes with an alias 8 9connection master; 10set sql_log_bin=0; 11create database mysqltest_from; 12set sql_log_bin=1; 13 14connection slave; 15create database mysqltest_to; 16 17 18connection master; 19use mysqltest_from; 20--disable_warnings 21drop table if exists a; 22--enable_warnings 23CREATE TABLE a (i INT); 24INSERT INTO a VALUES(1); 25DELETE alias FROM a alias WHERE alias.i=1; 26SELECT * FROM a; 27insert into a values(2),(3); 28delete alias FROM a alias where alias.i=2; 29select * from a; 30sync_slave_with_master; 31 32use mysqltest_to; 33select * from a; 34 35# BUG#3461 36connection master; 37create table t1 (a int primary key); 38create table t2 (a int); 39 40insert into t1 values (1); 41insert into t2 values (1); 42 43delete t1.* from t1, t2 where t1.a = t2.a; 44 45save_master_pos; 46select * from t1; 47select * from t2; 48 49connection slave; 50# BUG#3461 would cause sync to fail 51sync_with_master; 52error 1146; 53select * from t1; 54error 1146; 55select * from t2; 56 57# cleanup 58connection master; 59set sql_log_bin=0; 60drop database mysqltest_from; 61set sql_log_bin=1; 62connection slave; 63drop database mysqltest_to; 64 65# End of 4.1 tests 66 67--source include/rpl_end.inc 68