Debian Codegraph @

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