Debian Codegraph @

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

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