mysql-test/suite/rpl/t/rpl_multi_delete.test
raw| 1 | source include/master-slave.inc; |
| 2 | create table t1 (a int primary key); |
| 3 | create table t2 (a int); |
| 4 | |
| 5 | insert into t1 values (1); |
| 6 | insert into t2 values (1); |
| 7 | |
| 8 | |
| 9 | delete t1.* from t1, t2 where t1.a = t2.a; |
| 10 | |
| 11 | save_master_pos; |
| 12 | select * from t1; |
| 13 | select * from t2; |
| 14 | |
| 15 | connection slave; |
| 16 | sync_with_master; |
| 17 | select * from t1; |
| 18 | select * from t2; |
| 19 | |
| 20 | connection master; |
| 21 | drop table t1,t2; |
| 22 | sync_slave_with_master; |
| 23 | |
| 24 | # End of 4.1 tests |
| 25 | --source include/rpl_end.inc |