Debian Codegraph @

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

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