mysql-test/suite/engines/funcs/r/rpl_multi_delete.result
raw| 1 | include/master-slave.inc |
| 2 | [connection master] |
| 3 | create table t1 (a int primary key); |
| 4 | create table t2 (a int); |
| 5 | insert into t1 values (1); |
| 6 | insert into t2 values (1); |
| 7 | delete t1.* from t1, t2 where t1.a = t2.a; |
| 8 | select * from t1; |
| 9 | a |
| 10 | select * from t2; |
| 11 | a |
| 12 | 1 |
| 13 | connection slave; |
| 14 | select * from t1; |
| 15 | a |
| 16 | select * from t2; |
| 17 | a |
| 18 | 1 |
| 19 | connection master; |
| 20 | drop table t1,t2; |
| 21 | connection slave; |
| 22 | include/rpl_end.inc |