Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 DROP TABLE IF EXISTS t1;
4 **** Testing WL#3228 changes. ****
5 *** Create "wider" table on slave ***
6 connection slave;
7 Checking MYSQL_TYPE_NEWDECIMAL fields
8 connection master;
9 DROP TABLE IF EXISTS t1;
10 Warnings:
11 Note 1051 Unknown table 'test.t1'
12 connection slave;
13 STOP SLAVE;
14 include/reset_slave.inc
15 CREATE TABLE t1 (a DECIMAL(5,2));
16 connection master;
17 CREATE TABLE t1 (a DECIMAL(20, 10));
18 RESET MASTER;
19 INSERT INTO t1 VALUES (901251.90125);
20 connection slave;
21 START SLAVE;
22 include/wait_for_slave_sql_error.inc [errno=1677]
23 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'decimal(20,10)' to type 'decimal(5,2)''
24 SELECT COUNT(*) FROM t1;
25 COUNT(*)
26 0
27 STOP SLAVE;
28 include/reset_slave.inc
29 Warnings:
30 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
31 connection master;
32 RESET MASTER;
33 connection slave;
34 START SLAVE;
35 connection master;
36 DROP TABLE IF EXISTS t1;
37 connection slave;
38 STOP SLAVE;
39 include/reset_slave.inc
40 Warnings:
41 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
42 CREATE TABLE t1 (a DECIMAL(27, 9));
43 connection master;
44 CREATE TABLE t1 (a DECIMAL(27, 18));
45 RESET MASTER;
46 INSERT INTO t1 VALUES (901251.90125);
47 connection slave;
48 START SLAVE;
49 include/wait_for_slave_sql_error.inc [errno=1677]
50 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'decimal(27,18)' to type 'decimal(27,9)''
51 SELECT COUNT(*) FROM t1;
52 COUNT(*)
53 0
54 STOP SLAVE;
55 include/reset_slave.inc
56 Warnings:
57 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
58 connection master;
59 RESET MASTER;
60 connection slave;
61 START SLAVE;
62 connection master;
63 DROP TABLE IF EXISTS t1;
64 connection slave;
65 STOP SLAVE;
66 include/reset_slave.inc
67 Warnings:
68 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
69 CREATE TABLE t1 (a NUMERIC(5,2));
70 connection master;
71 CREATE TABLE t1 (a NUMERIC(20, 10));
72 RESET MASTER;
73 INSERT INTO t1 VALUES (901251.90125);
74 connection slave;
75 START SLAVE;
76 include/wait_for_slave_sql_error.inc [errno=1677]
77 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'decimal(20,10)' to type 'decimal(5,2)''
78 SELECT COUNT(*) FROM t1;
79 COUNT(*)
80 0
81 STOP SLAVE;
82 include/reset_slave.inc
83 Warnings:
84 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
85 connection master;
86 RESET MASTER;
87 connection slave;
88 START SLAVE;
89 Checking MYSQL_TYPE_FLOAT fields
90 connection master;
91 DROP TABLE IF EXISTS t1;
92 connection slave;
93 STOP SLAVE;
94 include/reset_slave.inc
95 Warnings:
96 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
97 CREATE TABLE t1 (a FLOAT(20));
98 connection master;
99 CREATE TABLE t1 (a FLOAT(47));
100 RESET MASTER;
101 INSERT INTO t1 VALUES (901251.90125);
102 connection slave;
103 START SLAVE;
104 include/wait_for_slave_sql_error.inc [errno=1677]
105 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'double' to type 'float''
106 SELECT COUNT(*) FROM t1;
107 COUNT(*)
108 0
109 STOP SLAVE;
110 include/reset_slave.inc
111 Warnings:
112 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
113 connection master;
114 RESET MASTER;
115 connection slave;
116 START SLAVE;
117 Checking MYSQL_TYPE_BIT fields
118 connection master;
119 DROP TABLE IF EXISTS t1;
120 connection slave;
121 STOP SLAVE;
122 include/reset_slave.inc
123 Warnings:
124 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
125 CREATE TABLE t1 (a BIT(5));
126 connection master;
127 CREATE TABLE t1 (a BIT(64));
128 RESET MASTER;
129 INSERT INTO t1 VALUES (B'10101');
130 connection slave;
131 START SLAVE;
132 include/wait_for_slave_sql_error.inc [errno=1677]
133 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'bit(64)' to type 'bit(5)''
134 SELECT COUNT(*) FROM t1;
135 COUNT(*)
136 0
137 STOP SLAVE;
138 include/reset_slave.inc
139 Warnings:
140 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
141 connection master;
142 RESET MASTER;
143 connection slave;
144 START SLAVE;
145 connection master;
146 DROP TABLE IF EXISTS t1;
147 connection slave;
148 STOP SLAVE;
149 include/reset_slave.inc
150 Warnings:
151 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
152 CREATE TABLE t1 (a BIT(11));
153 connection master;
154 CREATE TABLE t1 (a BIT(12));
155 RESET MASTER;
156 INSERT INTO t1 VALUES (B'10101');
157 connection slave;
158 START SLAVE;
159 include/wait_for_slave_sql_error.inc [errno=1677]
160 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'bit(12)' to type 'bit(11)''
161 SELECT COUNT(*) FROM t1;
162 COUNT(*)
163 0
164 STOP SLAVE;
165 include/reset_slave.inc
166 Warnings:
167 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
168 connection master;
169 RESET MASTER;
170 connection slave;
171 START SLAVE;
172 Checking MYSQL_TYPE_SET fields
173 connection master;
174 DROP TABLE IF EXISTS t1;
175 connection slave;
176 STOP SLAVE;
177 include/reset_slave.inc
178 Warnings:
179 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
180 CREATE TABLE t1 (a SET('4'));
181 connection master;
182 CREATE TABLE t1 (a SET('1','2','3','4','5','6','7','8','9'));
183 RESET MASTER;
184 INSERT INTO t1 VALUES ('4');
185 connection slave;
186 START SLAVE;
187 include/wait_for_slave_sql_error.inc [errno=1677]
188 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'set' to type 'set('4')''
189 SELECT COUNT(*) FROM t1;
190 COUNT(*)
191 0
192 STOP SLAVE;
193 include/reset_slave.inc
194 Warnings:
195 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
196 connection master;
197 RESET MASTER;
198 connection slave;
199 START SLAVE;
200 Checking MYSQL_TYPE_STRING fields
201 connection master;
202 DROP TABLE IF EXISTS t1;
203 connection slave;
204 STOP SLAVE;
205 include/reset_slave.inc
206 Warnings:
207 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
208 CREATE TABLE t1 (a CHAR(10));
209 connection master;
210 CREATE TABLE t1 (a CHAR(20));
211 RESET MASTER;
212 INSERT INTO t1 VALUES ('This is a test.');
213 connection slave;
214 START SLAVE;
215 include/wait_for_slave_sql_error.inc [errno=1677]
216 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'char(80 octets)' to type 'char(40 octets) character set utf8mb4''
217 SELECT COUNT(*) FROM t1;
218 COUNT(*)
219 0
220 STOP SLAVE;
221 include/reset_slave.inc
222 Warnings:
223 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
224 connection master;
225 RESET MASTER;
226 connection slave;
227 START SLAVE;
228 Checking MYSQL_TYPE_ENUM fields
229 connection master;
230 DROP TABLE IF EXISTS t1;
231 connection slave;
232 STOP SLAVE;
233 include/reset_slave.inc
234 Warnings:
235 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
236 CREATE TABLE t1 (a ENUM('44','54'));
237 connection master;
238 CREATE TABLE t1 (a ENUM(
239 '01','02','03','04','05','06','07','08','09',
240 '11','12','13','14','15','16','17','18','19',
241 '21','22','23','24','25','26','27','28','29',
242 '31','32','33','34','35','36','37','38','39',
243 '41','42','43','44','45','46','47','48','49',
244 '51','52','53','54','55','56','57','58','59',
245 '61','62','63','64','65','66','67','68','69',
246 '71','72','73','74','75','76','77','78','79',
247 '81','82','83','84','85','86','87','88','89',
248 '91','92','93','94','95','96','97','98','99',
249 '101','102','103','104','105','106','107','108','109',
250 '111','112','113','114','115','116','117','118','119',
251 '121','122','123','124','125','126','127','128','129',
252 '131','132','133','134','135','136','137','138','139',
253 '141','142','143','144','145','146','147','148','149',
254 '151','152','153','154','155','156','157','158','159',
255 '161','162','163','164','165','166','167','168','169',
256 '171','172','173','174','175','176','177','178','179',
257 '181','182','183','184','185','186','187','188','189',
258 '191','192','193','194','195','196','197','198','199',
259 '201','202','203','204','205','206','207','208','209',
260 '211','212','213','214','215','216','217','218','219',
261 '221','222','223','224','225','226','227','228','229',
262 '231','232','233','234','235','236','237','238','239',
263 '241','242','243','244','245','246','247','248','249',
264 '251','252','253','254','255','256','257','258','259',
265 '261','262','263','264','265','266','267','268','269',
266 '271','272','273','274','275','276','277','278','279',
267 '281','282','283','284','285','286','287','288','289',
268 '291','292','293','294','295','296','297','298','299'
269 ));
270 RESET MASTER;
271 INSERT INTO t1 VALUES ('44');
272 connection slave;
273 START SLAVE;
274 include/wait_for_slave_sql_error.inc [errno=1677]
275 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'enum' to type 'enum('44','54')''
276 SELECT COUNT(*) FROM t1;
277 COUNT(*)
278 0
279 STOP SLAVE;
280 include/reset_slave.inc
281 Warnings:
282 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
283 connection master;
284 RESET MASTER;
285 connection slave;
286 START SLAVE;
287 Checking MYSQL_TYPE_VARCHAR fields
288 connection master;
289 DROP TABLE IF EXISTS t1;
290 connection slave;
291 STOP SLAVE;
292 include/reset_slave.inc
293 Warnings:
294 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
295 CREATE TABLE t1 (a VARCHAR(100));
296 connection master;
297 CREATE TABLE t1 (a VARCHAR(2000));
298 RESET MASTER;
299 INSERT INTO t1 VALUES ('This is a test.');
300 connection slave;
301 START SLAVE;
302 include/wait_for_slave_sql_error.inc [errno=1677]
303 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'varchar(8000 octets)' to type 'varchar(400 octets) character set utf8mb4''
304 SELECT COUNT(*) FROM t1;
305 COUNT(*)
306 0
307 STOP SLAVE;
308 include/reset_slave.inc
309 Warnings:
310 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
311 connection master;
312 RESET MASTER;
313 connection slave;
314 START SLAVE;
315 connection master;
316 DROP TABLE IF EXISTS t1;
317 connection slave;
318 STOP SLAVE;
319 include/reset_slave.inc
320 Warnings:
321 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
322 CREATE TABLE t1 (a VARCHAR(10));
323 connection master;
324 CREATE TABLE t1 (a VARCHAR(200));
325 RESET MASTER;
326 INSERT INTO t1 VALUES ('This is a test.');
327 connection slave;
328 START SLAVE;
329 include/wait_for_slave_sql_error.inc [errno=1677]
330 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'varchar(800 octets)' to type 'varchar(40 octets) character set utf8mb4''
331 SELECT COUNT(*) FROM t1;
332 COUNT(*)
333 0
334 STOP SLAVE;
335 include/reset_slave.inc
336 Warnings:
337 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
338 connection master;
339 RESET MASTER;
340 connection slave;
341 START SLAVE;
342 connection master;
343 DROP TABLE IF EXISTS t1;
344 connection slave;
345 STOP SLAVE;
346 include/reset_slave.inc
347 Warnings:
348 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
349 CREATE TABLE t1 (a VARCHAR(1000));
350 connection master;
351 CREATE TABLE t1 (a VARCHAR(2000));
352 RESET MASTER;
353 INSERT INTO t1 VALUES ('This is a test.');
354 connection slave;
355 START SLAVE;
356 include/wait_for_slave_sql_error.inc [errno=1677]
357 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'varchar(8000 octets)' to type 'varchar(4000 octets) character set utf8mb4''
358 SELECT COUNT(*) FROM t1;
359 COUNT(*)
360 0
361 STOP SLAVE;
362 include/reset_slave.inc
363 Warnings:
364 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
365 connection master;
366 RESET MASTER;
367 connection slave;
368 START SLAVE;
369 Checking MYSQL_TYPE_BLOB fields
370 connection master;
371 DROP TABLE IF EXISTS t1;
372 connection slave;
373 STOP SLAVE;
374 include/reset_slave.inc
375 Warnings:
376 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
377 CREATE TABLE t1 (a TINYBLOB);
378 connection master;
379 CREATE TABLE t1 (a LONGBLOB);
380 RESET MASTER;
381 INSERT INTO t1 VALUES ('This is a test.');
382 connection slave;
383 START SLAVE;
384 include/wait_for_slave_sql_error.inc [errno=1677]
385 Last_SQL_Error = 'Column 0 of table 'test.t1' cannot be converted from type 'longblob' to type 'tinyblob''
386 SELECT COUNT(*) FROM t1;
387 COUNT(*)
388 0
389 STOP SLAVE;
390 include/reset_slave.inc
391 Warnings:
392 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
393 connection master;
394 RESET MASTER;
395 connection slave;
396 START SLAVE;
397 connection slave;
398 call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 0 ...e mismatch.* error.* 1535");
399 call mtr.add_suppression("Slave SQL.*Column 0 of table .test.t1. cannot be converted from type.* error.* 1677");
400 *** Cleanup ***
401 connection master;
402 DROP TABLE IF EXISTS t1;
403 connection slave;
404 include/rpl_end.inc