Debian Codegraph @

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

raw
1 --source include/not_group_replication_plugin.inc
2 --source include/have_binlog_format_row.inc
3 --source include/force_myisam_default.inc
4 --source include/have_myisam.inc
5
6 let $SERVER_VERSION=`select version()`;
7
8 #This test case is not written for NDB, the result files
9 #will not match when NDB is the default engine
10 -- source include/not_ndb_default.inc
11
12 --source include/master-slave.inc
13
14 --echo # Bug#15942 (RBR ignores --binlog_ignore_db and tries to map to table
15 --echo # on slave for writes)
16
17 CREATE DATABASE test_ignore; # --binlog_ignore_db=mysqltest_ignore
18
19 --echo **** On Master ****
20 SHOW DATABASES;
21 USE test;
22 CREATE TABLE t1 (a INT, b INT);
23 SHOW TABLES;
24 INSERT INTO t1 VALUES (1,1), (2,2);
25 USE test_ignore;
26 CREATE TABLE t2 (a INT, b INT);
27 SHOW TABLES;
28 INSERT INTO t2 VALUES (3,3), (4,4);
29 source include/show_binlog_events.inc;
30 --source include/sync_slave_sql_with_master.inc
31 --echo **** On Slave ****
32 SHOW DATABASES;
33 USE test;
34 SHOW TABLES;
35 --error 1049
36 USE test_ignore;
37
38 connection master;
39 DROP DATABASE test_ignore;
40 USE test;
41 DROP TABLE t1;
42 --source include/sync_slave_sql_with_master.inc
43 USE test;
44
45
46 --echo # Bug#19995: Extreneous table maps generated for statements that does
47 --echo # not generate rows
48 --source include/rpl_reset.inc
49
50 connection master;
51 CREATE TABLE t1 (a INT);
52 DELETE FROM t1;
53 INSERT INTO t1 VALUES (1),(2);
54 DELETE FROM t1 WHERE a = 0;
55 UPDATE t1 SET a=99 WHERE a = 0;
56 source include/show_binlog_events.inc;
57
58 DROP TABLE t1;
59
60 # BUG#17620: Replicate (Row Based) Fails when Query Cache enabled on
61 # slave
62 --echo ================ Test for BUG#17620 ================
63 --source include/rpl_reset.inc
64
65 --echo **** On Slave ****
66 connection slave;
67 call mtr.add_suppression("Replica SQL.*Could not execute Update_rows event on table test.t1.* Error_code: 1032");
68
69 --echo **** On Master ****
70 connection master;
71 CREATE TABLE t1 (a INT);
72 INSERT INTO t1 VALUES (1),(2),(3);
73
74 --echo **** On Slave ****
75 --source include/sync_slave_sql_with_master.inc
76
77 --echo **** On Master ****
78 connection master;
79 INSERT INTO t1 VALUES (4),(5),(6);
80
81 --echo **** On Slave ****
82 --source include/sync_slave_sql_with_master.inc
83 SELECT * FROM t1;
84
85 --echo **** On Master ****
86 connection master;
87 INSERT INTO t1 VALUES (7),(8),(9);
88
89 --echo **** On Slave ****
90 --source include/sync_slave_sql_with_master.inc
91 SELECT * FROM t1;
92
93 --connection master
94 DROP TABLE t1;
95
96
97 # Bug#22550: Replication of BIT columns failing
98 --echo ================ Test for BUG#22550 ================
99 --source include/rpl_reset.inc
100
101 connection master;
102 CREATE TABLE t1 (a BIT(1), b INT) ENGINE=MYISAM;
103 --source include/sync_slave_sql_with_master.inc
104
105 connection master;
106 INSERT INTO t1 VALUES(1,2);
107 SELECT HEX(a),b FROM t1;
108 --source include/sync_slave_sql_with_master.inc
109 SELECT HEX(a),b FROM t1;
110
111 connection master;
112 UPDATE t1 SET a=0 WHERE b=2;
113 SELECT HEX(a),b FROM t1;
114 --source include/sync_slave_sql_with_master.inc
115 SELECT HEX(a),b FROM t1;
116
117 connection master;
118 DROP TABLE IF EXISTS t1;
119 --source include/sync_slave_sql_with_master.inc
120
121 # BUG#22583: RBR between MyISAM and non-MyISAM tables containing a BIT
122 # field does not work
123
124 --echo ================ Test for BUG#22583 ================
125 --source include/rpl_reset.inc
126
127 # disabling warnings temporarily for ENGINE=INNODB to work without InnoDB
128 --disable_warnings
129 --echo **** On Master ****
130 connection master;
131 CREATE TABLE t1_myisam (k INT, a BIT(1), b BIT(9)) ENGINE=MYISAM;
132 CREATE TABLE t1_innodb (k INT, a BIT(1), b BIT(9)) ENGINE=INNODB;
133 CREATE TABLE t2_myisam (k INT, a BIT(1) NOT NULL, b BIT(4) NOT NULL) ENGINE=MYISAM;
134 CREATE TABLE t2_innodb (k INT, a BIT(1) NOT NULL, b BIT(4) NOT NULL) ENGINE=INNODB;
135 --echo **** On Slave ****
136 --source include/sync_slave_sql_with_master.inc
137 ALTER TABLE t1_myisam ENGINE=INNODB;
138 ALTER TABLE t1_innodb ENGINE=MYISAM;
139 ALTER TABLE t2_myisam ENGINE=INNODB;
140 ALTER TABLE t2_innodb ENGINE=MYISAM;
141 --enable_warnings
142
143 --echo **** On Master ****
144 connection master;
145 INSERT INTO t1_myisam VALUES(1, b'0', 257);
146 INSERT INTO t1_myisam VALUES(2, b'1', 256);
147 INSERT INTO t1_innodb VALUES(1, b'0', 257);
148 INSERT INTO t1_innodb VALUES(2, b'1', 256);
149 SELECT k, HEX(a),HEX(b) FROM t1_myisam;
150 SELECT k, HEX(a),HEX(b) FROM t1_innodb;
151 INSERT INTO t2_myisam VALUES(1, b'0', 9);
152 INSERT INTO t2_myisam VALUES(2, b'1', 8);
153 INSERT INTO t2_innodb VALUES(1, b'0', 9);
154 INSERT INTO t2_innodb VALUES(2, b'1', 8);
155 SELECT k, HEX(a),HEX(b) FROM t2_myisam;
156 SELECT k, HEX(a),HEX(b) FROM t2_innodb;
157 --echo **** On Slave ****
158 --source include/sync_slave_sql_with_master.inc
159 SELECT k, HEX(a),HEX(b) FROM t1_myisam;
160 SELECT k, HEX(a),HEX(b) FROM t1_innodb;
161 SELECT k, HEX(a),HEX(b) FROM t2_myisam;
162 SELECT k, HEX(a),HEX(b) FROM t2_innodb;
163
164 --echo **** On Master ****
165 connection master;
166 UPDATE t1_myisam SET a=0 WHERE k=2;
167 SELECT k, HEX(a),HEX(b) FROM t1_myisam;
168 UPDATE t1_innodb SET a=0 WHERE k=2;
169 SELECT k, HEX(a),HEX(b) FROM t1_innodb;
170 UPDATE t2_myisam SET a=0 WHERE k=2;
171 SELECT k, HEX(a),HEX(b) FROM t2_myisam;
172 UPDATE t2_innodb SET a=0 WHERE k=2;
173 SELECT k, HEX(a),HEX(b) FROM t2_innodb;
174 --echo **** On Slave ****
175 --source include/sync_slave_sql_with_master.inc
176 SELECT k, HEX(a),HEX(b) FROM t1_myisam;
177 SELECT k, HEX(a),HEX(b) FROM t1_innodb;
178 SELECT k, HEX(a),HEX(b) FROM t2_myisam;
179 SELECT k, HEX(a),HEX(b) FROM t2_innodb;
180
181 --echo **** On Master ****
182 connection master;
183 DROP TABLE IF EXISTS t1_myisam, t1_innodb, t2_myisam, t2_innodb;
184 --source include/sync_slave_sql_with_master.inc
185
186 --echo #
187 --echo # Bug#27716 multi-update did partially and has not binlogged
188 --echo #
189
190 connection master;
191
192 --disable_warnings
193 drop table if exists t1, t2;
194 --enable_warnings
195 CREATE TABLE `t1` (
196 `a` int(11) NOT NULL auto_increment,
197 `b` int(11) default NULL,
198 PRIMARY KEY (`a`)
199 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
200
201 CREATE TABLE `t2` (
202 `a` int(11) NOT NULL auto_increment,
203 `b` int(11) default NULL,
204 PRIMARY KEY (`a`)
205 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
206
207 # testing multi_update::send_error() effective update
208 insert into t1 values (1,1),(2,2);
209 insert into t2 values (1,1),(4,4);
210
211 connection master;
212 error ER_DUP_ENTRY;
213 UPDATE t2,t1 SET t2.a=t1.a+2;
214 select * from t2 /* must be (3,1), (4,4) */;
215 --source include/sync_slave_sql_with_master.inc
216
217 connection slave;
218 select * from t2 /* must be (3,1), (4,4) */;
219
220 connection master;
221 drop table t1,t2;
222
223 --source include/sync_slave_sql_with_master.inc
224
225 --echo #
226 --echo # BUG#31702: Missing row on slave causes assertion failure under
227 --echo # row-based replication
228 --echo #
229
230 --source include/rpl_reset.inc
231
232 --echo **** On Master ****
233 connection master;
234 CREATE TABLE t1 (a INT PRIMARY KEY, b SET('master','slave'));
235 INSERT INTO t1 VALUES (1,'master,slave'), (2,'master,slave');
236 --echo **** On Slave ****
237 --source include/sync_slave_sql_with_master.inc
238 UPDATE t1 SET a = 5, b = 'slave' WHERE a = 1;
239 SELECT * FROM t1 ORDER BY a;
240 # since bug#31552/31609 idempotency is not default any longer. In
241 # order for the preceding test UPDATE t1 to pass, the mode is switched
242 # temprorarily
243 set @@global.replica_exec_mode= 'IDEMPOTENT';
244 --echo **** On Master ****
245 connection master;
246 UPDATE t1 SET a = 5, b = 'master' WHERE a = 1;
247 SELECT * FROM t1 ORDER BY a;
248 --echo **** On Slave ****
249 --source include/sync_slave_sql_with_master.inc
250 set @@global.replica_exec_mode= default;
251 let $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Error, 1);
252 disable_query_log;
253 eval SELECT "$last_error" AS Last_SQL_Error;
254 enable_query_log;
255
256 SELECT * FROM t1 ORDER BY a;
257
258 --echo **** On Master ****
259 connection master;
260 DROP TABLE t1;
261 --source include/rpl_end.inc