Debian Codegraph @

mysql-test/suite/rpl/r/rpl_multi_delete_join.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # MDEV-38003 Intermittent Replication Failure on a multi-table DELETE
5 #
6 connection master;
7 set sql_log_bin=1;
8 connection slave;
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 pk num pk num pk num
22 2 1901 2 2001 2 42
23 2 1901 2 2002 2 42
24 1 1900 NULL NULL NULL NULL
25 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
26 pk num pk num pk num
27 2 1901 2 2001 2 42
28 2 1901 2 2002 2 42
29 connection slave;
30 use mdev38003;
31 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
32 pk num pk num pk num
33 2 1901 2 2001 2 42
34 2 1901 2 2002 2 42
35 1 1900 NULL NULL NULL NULL
36 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
37 pk num pk num pk num
38 2 1901 2 2001 2 42
39 2 1901 2 2002 2 42
40 connection master;
41 use mdev38003;
42 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;
43 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
44 pk num pk num pk num
45 1 1900 NULL NULL NULL NULL
46 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
47 pk num pk num pk num
48 connection slave;
49 use mdev38003;
50 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk;
51 pk num pk num pk num
52 1 1900 NULL NULL NULL NULL
53 select * from t1 left join t2 on t1.pk = t2.pk left join t3 on t2.pk = t3.pk where t2.num <= 2002;
54 pk num pk num pk num
55 connection master;
56 use mdev38003;
57 drop table t1, t2, t3;
58 drop database mdev38003;
59 # End of 11.8 tests
60 include/rpl_end.inc