Debian Codegraph @

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

raw
1 #multi delete replication bugs
2 --source include/not_group_replication_plugin.inc
3 source include/master-slave.inc;
4
5 #BUG#11139 - improper wild-table and table rules
6 #checking for multi deletes with an alias
7
8 connection master;
9 set sql_log_bin=0;
10 create database mysqltest_from;
11 set sql_log_bin=1;
12
13 connection slave;
14 create database mysqltest_to;
15
16
17 connection master;
18 use mysqltest_from;
19 --disable_warnings
20 drop table if exists a;
21 --enable_warnings
22 CREATE TABLE a (i INT);
23 INSERT INTO a VALUES(1);
24 DELETE alias FROM a alias WHERE alias.i=1;
25 SELECT * FROM a;
26 insert into a values(2),(3);
27 delete alias FROM a alias where alias.i=2;
28 select * from a;
29 --source include/sync_slave_sql_with_master.inc
30
31 use mysqltest_to;
32 select * from a;
33
34 # BUG#3461
35 connection master;
36 create table t1 (a int primary key);
37 create table t2 (a int);
38
39 insert into t1 values (1);
40 insert into t2 values (1);
41
42 delete t1.* from t1, t2 where t1.a = t2.a;
43
44 save_master_pos;
45 select * from t1;
46 select * from t2;
47
48 connection slave;
49 # BUG#3461 would cause sync to fail
50 sync_with_master;
51 error 1146;
52 select * from t1;
53 error 1146;
54 select * from t2;
55
56 # cleanup
57 connection master;
58 set sql_log_bin=0;
59 drop database mysqltest_from;
60 set sql_log_bin=1;
61 connection slave;
62 drop database mysqltest_to;
63
64 # End of 4.1 tests
65
66 --source include/rpl_end.inc