Debian Codegraph @

mysql-test/suite/rpl/t/rpl_multi_delete_join.test

raw
1 source include/master-slave.inc;
2
3 --echo #
4 --echo # MDEV-38003 Intermittent Replication Failure on a multi-table DELETE
5 --echo #
6 connection master;
7 set sql_log_bin=1;
8 sync_slave_with_master;
9 set sql_log_bin=1;
10 reset master;
11 connection master;
12 create database mdev38003;
13 use mdev38003;
14 create table t1 (pk int, num int);
15 create table t2 (pk int, num int);
16 create table t3 (pk int, num int);
17 insert into t1 (pk, num) values (1,1900),(2,1901);
18 insert into t2 (pk, num) values (2,2001),(2,2002);
19 insert into t3 (pk, num) values (1,40),(2,42);
20 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
21 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
22
23 sync_slave_with_master;
24 use mdev38003;
25 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
26 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
27
28 connection master;
29 use mdev38003;
30 delete t1, t2, t3 from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
31 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
32 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
33
34 sync_slave_with_master;
35 use mdev38003;
36 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
37 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
38
39 connection master;
40 use mdev38003;
41 drop table t1, t2, t3;
42 drop database mdev38003;
43
44 --echo # End of 11.8 tests
45
46 --source include/rpl_end.inc