Debian Codegraph @

mysql-test/suite/rpl/include/rpl_multi_update2.test

raw
1 # Let's verify that multi-update is not always skipped by slave if
2 # some replicate-* rules exist.
3 # (BUG#7011)
4
5 --disable_warnings
6 drop table if exists t1,t2;
7 --enable_warnings
8
9 eval CREATE TABLE t1 (
10 a int unsigned not null auto_increment primary key,
11 b int unsigned
12 ) ENGINE=$engine_type;
13
14 eval CREATE TABLE t2 (
15 a int unsigned not null auto_increment primary key,
16 b int unsigned
17 ) ENGINE=$engine_type;
18
19 INSERT INTO t1 VALUES (NULL, 0);
20
21 --disable_warnings ONCE
22 INSERT INTO t1 SELECT NULL, 0 FROM t1;
23
24 INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
25
26 SELECT * FROM t1 ORDER BY a;
27 SELECT * FROM t2 ORDER BY a;
28
29 --disable_warnings ONCE
30 UPDATE t1, t2 SET t1.b = (t2.b+4) WHERE t1.a = t2.a;
31 SELECT * FROM t1 ORDER BY a;
32 SELECT * FROM t2 ORDER BY a;
33
34 save_master_pos;
35 connection slave;
36 sync_with_master;
37 SELECT * FROM t1 ORDER BY a;
38 SELECT * FROM t2 ORDER BY a;
39
40 connection master;
41 drop table t1,t2;
42 sync_slave_with_master;
43
44 #
45 # BUG#13236 multi-update with subquery & --replicate-ignore-table
46 #
47 reset master;
48
49 connection master;
50 CREATE TABLE t1 ( a INT );
51 INSERT INTO t1 VALUES (0);
52 UPDATE t1, (SELECT 3 as b) AS x SET t1.a = x.b;
53 select * from t1;
54 sync_slave_with_master;
55
56 connection slave;
57 select * from t1;
58
59 connection master;
60 drop table t1;
61 sync_slave_with_master;
62
63 # End of 4.1 tests