Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3
4 *** Preparing data ***
5 connection master;
6 CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(10)) ENGINE=MyISAM;
7 CREATE TABLE t2 LIKE t1;
8 CREATE TABLE t3 LIKE t1;
9 CREATE TRIGGER tr1 BEFORE UPDATE ON t1
10 FOR EACH ROW BEGIN
11 UPDATE t2 SET b='YY' WHERE a=NEW.a;
12 END|
13 CREATE TRIGGER tr2 AFTER UPDATE ON t1
14 FOR EACH ROW BEGIN
15 UPDATE t3 SET b='ZZ' WHERE a=NEW.a;
16 END|
17
18 *** Test non-transactional group w/o PK ***
19 connection master;
20 INSERT INTO t3 VALUES(1, 'AA');
21 INSERT INTO t2 VALUES(1, 'AA');
22 INSERT INTO t1 VALUES(1, 'AA');
23 connection slave;
24 RENAME TABLE t3 TO t3_bak;
25 connection master;
26 UPDATE t1 SET b = 'XX' WHERE a = 1;
27 SELECT * FROM t1 ORDER BY a;
28 a b
29 1 XX
30 SELECT * FROM t2 ORDER BY a;
31 a b
32 1 YY
33 SELECT * FROM t3 ORDER BY a;
34 a b
35 1 ZZ
36 connection slave;
37 call mtr.add_suppression("Slave SQL.*Table .test.t3. doesn.t exist.* error.* 1146");
38 call mtr.add_suppression("At line *");
39 include/wait_for_slave_sql_error.inc [errno=1146]
40 SHOW TABLES LIKE 't%';
41 Tables_in_test (t%)
42 t1
43 t2
44 t3_bak
45 SELECT * FROM t1 ORDER BY a;
46 a b
47 1 AA_for_row_or_XX_for_stmt_mixed
48 SELECT * FROM t2 ORDER BY a;
49 a b
50 1 AA_for_row_or_YY_for_stmt_mixed
51 include/stop_slave_io.inc
52 RENAME TABLE t3_bak TO t3;
53 include/start_slave.inc
54 connection master;
55 TRUNCATE t1;
56 TRUNCATE t2;
57 TRUNCATE t3;
58 connection slave;
59
60 *** Test non-transactional group w/ PK ***
61 connection master;
62 ALTER TABLE t1 ADD PRIMARY KEY (a);
63 ALTER TABLE t2 ADD PRIMARY KEY (a);
64 ALTER TABLE t3 ADD PRIMARY KEY (a);
65 connection slave;
66 RENAME TABLE t3 TO t3_bak;
67 connection master;
68 INSERT INTO t3 VALUES(2, 'B');
69 INSERT INTO t2 VALUES(2, 'B');
70 INSERT INTO t1 VALUES(2, 'B');
71 UPDATE t1 SET b = 'X' WHERE a = 2;
72 connection slave;
73 include/wait_for_slave_sql_error.inc [errno=1146]
74 connection master;
75 SELECT * FROM t1 ORDER BY a;
76 a b
77 2 X
78 SELECT * FROM t2 ORDER BY a;
79 a b
80 2 YY
81 SELECT * FROM t3 ORDER BY a;
82 a b
83 2 ZZ
84 connection slave;
85 SHOW TABLES LIKE 't%';
86 Tables_in_test (t%)
87 t1
88 t2
89 t3_bak
90 SELECT * FROM t1 ORDER BY a;
91 a b
92 SELECT * FROM t2 ORDER BY a;
93 a b
94 include/stop_slave_io.inc
95 RENAME TABLE t3_bak TO t3;
96 include/start_slave.inc
97 connection master;
98 TRUNCATE t1;
99 TRUNCATE t2;
100 TRUNCATE t3;
101 connection slave;
102
103 *** Test transactional group w/ PK ***
104 connection master;
105 ALTER TABLE t1 ENGINE=InnoDB;
106 ALTER TABLE t2 ENGINE=InnoDB;
107 ALTER TABLE t3 ENGINE=InnoDB;
108 connection slave;
109 RENAME TABLE t3 TO t3_bak;
110 connection master;
111 BEGIN;
112 INSERT INTO t1 VALUES (3, 'C'), (4, 'D');
113 INSERT INTO t2 VALUES (3, 'C'), (4, 'D');
114 INSERT INTO t3 VALUES (3, 'C'), (4, 'D');
115 COMMIT;
116 connection slave;
117 include/wait_for_slave_sql_error.inc [errno=1146]
118 connection master;
119 SELECT * FROM t1 ORDER BY a;
120 a b
121 3 C
122 4 D
123 SELECT * FROM t2 ORDER BY a;
124 a b
125 3 C
126 4 D
127 SELECT * FROM t3 ORDER BY a;
128 a b
129 3 C
130 4 D
131 connection slave;
132 SHOW TABLES LIKE 't%';
133 Tables_in_test (t%)
134 t1
135 t2
136 t3_bak
137 SELECT * FROM t1 ORDER BY a;
138 a b
139 SELECT * FROM t2 ORDER BY a;
140 a b
141 include/stop_slave_io.inc
142 RENAME TABLE t3_bak TO t3;
143 include/start_slave.inc
144 *** Clean up ***
145 connection master;
146 DROP TABLE t1,t2,t3;
147 connection slave;
148 include/rpl_end.inc