Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 call mtr.add_suppression("Slave: Unknown table 't6' error.* 1051");
4 call mtr.add_suppression("Slave SQL.*Column [0-9] of table .test.t[0-9]*. cannot be converted from type.* error.* 1677");
5 **** Diff Table Def Start ****
6 connection slave;
7 STOP SLAVE;
8 include/reset_slave.inc
9 SET @saved_slave_type_conversions = @@slave_type_conversions;
10 SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY';
11 CREATE TABLE t1 (a INT, b INT PRIMARY KEY, c CHAR(20),
12 d FLOAT DEFAULT '2.00',
13 e CHAR(4) DEFAULT 'TEST')
14 ENGINE='MyISAM';
15 *** Create t1 on Master ***
16 connection master;
17 CREATE TABLE t1 (a INT PRIMARY KEY, b INT, c CHAR(10)
18 ) ENGINE='MyISAM';
19 RESET MASTER;
20 *** Start Slave ***
21 connection slave;
22 START SLAVE;
23 *** Master Data Insert ***
24 connection master;
25 INSERT INTO t1 () VALUES(1,2,'TEXAS'),(2,1,'AUSTIN'),(3,4,'QA');
26 SELECT * FROM t1 ORDER BY a;
27 a b c
28 1 2 TEXAS
29 2 1 AUSTIN
30 3 4 QA
31 *** Select from slave ***
32 connection slave;
33 SELECT * FROM t1 ORDER BY a;
34 a b c d e
35 1 2 TEXAS 2 TEST
36 2 1 AUSTIN 2 TEST
37 3 4 QA 2 TEST
38 SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
39 *** Drop t1 ***
40 connection master;
41 DROP TABLE t1;
42 connection slave;
43 *** Create t2 on slave ***
44 STOP SLAVE;
45 include/reset_slave.inc
46 CREATE TABLE t2 (a INT, b INT PRIMARY KEY, c CHAR(5),
47 d FLOAT DEFAULT '2.00',
48 e CHAR(5) DEFAULT 'TEST2')
49 ENGINE='MyISAM';
50 *** Create t2 on Master ***
51 connection master;
52 CREATE TABLE t2 (a INT PRIMARY KEY, b INT, c CHAR(10)
53 ) ENGINE='MyISAM';
54 RESET MASTER;
55 *** Master Data Insert ***
56 connection master;
57 INSERT INTO t2 () VALUES(1,2,'Kyle, TEX'),(2,1,'JOE AUSTIN'),(3,4,'QA TESTING');
58 SELECT * FROM t2 ORDER BY a;
59 a b c
60 1 2 Kyle, TEX
61 2 1 JOE AUSTIN
62 3 4 QA TESTING
63 *** Start Slave ***
64 connection slave;
65 START SLAVE;
66 include/wait_for_slave_sql_error.inc [errno=1677]
67 Last_SQL_Error = 'Column 2 of table 'test.t2' cannot be converted from type 'char(40 octets)' to type 'char(20 octets) character set utf8mb4''
68 STOP SLAVE;
69 include/reset_slave.inc
70 Warnings:
71 Warning 1948 Specified value for @@gtid_slave_pos contains no value for replication domain 0. This conflicts with the binary log which contains GTID 0-2-4. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos
72 SELECT * FROM t2 ORDER BY a;
73 a b c d e
74 connection master;
75 RESET MASTER;
76 connection slave;
77 START SLAVE;
78 *** Drop t2 ***
79 connection master;
80 DROP TABLE t2;
81 connection slave;
82 *** Create t3 on slave ***
83 STOP SLAVE;
84 include/reset_slave.inc
85 CREATE TABLE t3 (a INT, b INT PRIMARY KEY, c CHAR(20),
86 d FLOAT DEFAULT '2.00',
87 e CHAR(5) DEFAULT 'TEST2')
88 ENGINE='MyISAM';
89 *** Create t3 on Master ***
90 connection master;
91 CREATE TABLE t3 (a BLOB, b INT PRIMARY KEY, c CHAR(20)
92 ) ENGINE='MyISAM';
93 RESET MASTER;
94 *** Start Slave ***
95 connection slave;
96 START SLAVE;
97 *** Master Data Insert ***
98 connection master;
99 set @b1 = 'b1';
100 set @b1 = concat(@b1,@b1);
101 INSERT INTO t3 () VALUES(@b1,2,'Kyle, TEX'),(@b1,1,'JOE AUSTIN'),(@b1,4,'QA TESTING');
102 ********************************************
103 *** Expect slave to fail with Error 1677 ***
104 ********************************************
105 connection slave;
106 include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
107 Last_SQL_Error = 'Column 0 of table 'test.t3' cannot be converted from type 'blob' to type 'int(11)''
108 *** Drop t3 ***
109 connection master;
110 DROP TABLE t3;
111 connection slave;
112 *** Create t4 on slave ***
113 STOP SLAVE;
114 include/reset_slave.inc
115 CREATE TABLE t4 (a INT, b INT PRIMARY KEY, c CHAR(20),
116 d FLOAT DEFAULT '2.00',
117 e CHAR(5) DEFAULT 'TEST2')
118 ENGINE='MyISAM';
119 *** Create t4 on Master ***
120 connection master;
121 CREATE TABLE t4 (a DECIMAL(8,2), b INT PRIMARY KEY, c CHAR(20)
122 ) ENGINE='MyISAM';
123 RESET MASTER;
124 *** Start Slave ***
125 connection slave;
126 START SLAVE;
127 *** Master Data Insert ***
128 connection master;
129 INSERT INTO t4 () VALUES(100.22,2,'Kyle, TEX'),(200.26,1,'JOE AUSTIN'),
130 (30000.22,4,'QA TESTING');
131 ********************************************
132 *** Expect slave to fail with Error 1677 ***
133 ********************************************
134 connection slave;
135 include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
136 Last_SQL_Error = 'Column 0 of table 'test.t4' cannot be converted from type 'decimal(8,2)' to type 'int(11)''
137 *** Drop t4 ***
138 connection master;
139 DROP TABLE t4;
140 connection slave;
141 *** Create t5 on slave ***
142 STOP SLAVE;
143 include/reset_slave.inc
144 CREATE TABLE t5 (a INT PRIMARY KEY, b CHAR(5),
145 c FLOAT, d INT, e DOUBLE,
146 f DECIMAL(8,2))ENGINE='MyISAM';
147 *** Create t5 on Master ***
148 connection master;
149 CREATE TABLE t5 (a INT PRIMARY KEY, b VARCHAR(6),
150 c DECIMAL(8,2), d BIT, e BLOB,
151 f FLOAT) ENGINE='MyISAM';
152 RESET MASTER;
153 *** Start Slave ***
154 connection slave;
155 START SLAVE;
156 *** Master Data Insert ***
157 connection master;
158 INSERT INTO t5 () VALUES(1,'Kyle',200.23,1,'b1b1',23.00098),
159 (2,'JOE',300.01,0,'b2b2',1.0000009);
160 ********************************************
161 *** Expect slave to fail with Error 1677 ***
162 ********************************************
163 connection slave;
164 include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
165 Last_SQL_Error = 'Column 1 of table 'test.t5' cannot be converted from type 'varchar(24 octets)' to type 'char(20 octets) character set utf8mb4''
166 *** Drop t5 ***
167 connection master;
168 DROP TABLE t5;
169 connection slave;
170 *** Create t6 on slave ***
171 STOP SLAVE;
172 include/reset_slave.inc
173 CREATE TABLE t6 (a INT PRIMARY KEY, b CHAR(5),
174 c FLOAT, d INT)ENGINE='MyISAM';
175 *** Create t6 on Master ***
176 connection master;
177 CREATE TABLE t6 (a INT PRIMARY KEY, b VARCHAR(6),
178 c DECIMAL(8,2), d BIT
179 ) ENGINE='MyISAM';
180 RESET MASTER;
181 *** Start Slave ***
182 connection slave;
183 START SLAVE;
184 *** Master Data Insert ***
185 connection master;
186 INSERT INTO t6 () VALUES(1,'Kyle',200.23,1),
187 (2,'JOE',300.01,0);
188 ********************************************
189 *** Expect slave to fail with Error 1677 ***
190 ********************************************
191 connection slave;
192 include/wait_for_slave_sql_error.inc [errno=1677]
193 Last_SQL_Error = 'Column 1 of table 'test.t6' cannot be converted from type 'varchar(24 octets)' to type 'char(20 octets) character set utf8mb4''
194 *** Drop t6 ***
195 include/rpl_reset.inc
196 connection master;
197 DROP TABLE t6;
198 connection slave;
199 **** Diff Table Def End ****
200 **** Extra Colums Start ****
201 *** Create t7 on slave ***
202 STOP SLAVE;
203 include/reset_slave.inc
204 CREATE TABLE t7 (a INT KEY, b BLOB, c CHAR(5),
205 d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
206 e CHAR(20) DEFAULT 'Extra Column Testing')
207 ENGINE='MyISAM';
208 *** Create t7 on Master ***
209 connection master;
210 CREATE TABLE t7 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
211 ) ENGINE='MyISAM';
212 RESET MASTER;
213 *** Start Slave ***
214 connection slave;
215 START SLAVE;
216 *** Master Data Insert ***
217 connection master;
218 set @b1 = 'b1';
219 set @b1 = concat(@b1,@b1);
220 INSERT INTO t7 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
221 SELECT * FROM t7 ORDER BY a;
222 a b c
223 1 b1b1 Kyle
224 2 b1b1 JOE
225 3 b1b1 QA
226 *** Select from slave ***
227 connection slave;
228 SELECT * FROM t7 ORDER BY a;
229 a b c d e
230 1 b1b1 Kyle 0000-00-00 00:00:00 Extra Column Testing
231 2 b1b1 JOE 0000-00-00 00:00:00 Extra Column Testing
232 3 b1b1 QA 0000-00-00 00:00:00 Extra Column Testing
233 *** Drop t7 ***
234 connection master;
235 DROP TABLE t7;
236 connection slave;
237 *** Create t8 on slave ***
238 STOP SLAVE;
239 include/reset_slave.inc
240 CREATE TABLE t8 (a INT KEY, b BLOB, c CHAR(5),
241 d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
242 e INT)ENGINE='MyISAM';
243 *** Create t8 on Master ***
244 connection master;
245 CREATE TABLE t8 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
246 ) ENGINE='MyISAM';
247 RESET MASTER;
248 *** Start Slave ***
249 connection slave;
250 START SLAVE;
251 *** Master Data Insert ***
252 connection master;
253 set @b1 = 'b1b1b1b1';
254 set @b1 = concat(@b1,@b1);
255 INSERT INTO t8 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
256 *** Drop t8 ***
257 connection master;
258 DROP TABLE t8;
259 connection slave;
260 STOP SLAVE;
261 include/reset_slave.inc
262 CREATE TABLE t9 (a INT KEY, b BLOB, c CHAR(5),
263 d TIMESTAMP NOT NULL DEFAULT 0,
264 e INT NOT NULL,
265 f text not null,
266 g text,
267 h blob not null,
268 i blob) ENGINE='MyISAM';
269 *** Create t9 on Master ***
270 connection master;
271 CREATE TABLE t9 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
272 ) ENGINE='MyISAM';
273 RESET MASTER;
274 *** Start Slave ***
275 connection slave;
276 START SLAVE;
277 *** Master Data Insert ***
278 connection master;
279 set @b1 = 'b1b1b1b1';
280 set @b1 = concat(@b1,@b1);
281 INSERT INTO t9 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
282 connection slave;
283 select * from t9;
284 a b c d e f g h i
285 1 b1b1b1b1b1b1b1b1 Kyle 0000-00-00 00:00:00 0 NULL NULL
286 2 b1b1b1b1b1b1b1b1 JOE 0000-00-00 00:00:00 0 NULL NULL
287 3 b1b1b1b1b1b1b1b1 QA 0000-00-00 00:00:00 0 NULL NULL
288 connection master;
289 DROP TABLE t9;
290 connection slave;
291 *** Create t10 on slave ***
292 STOP SLAVE;
293 include/reset_slave.inc
294 CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
295 c CHAR(5), e INT DEFAULT '1')ENGINE='MyISAM';
296 *** Create t10 on Master ***
297 connection master;
298 CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
299 ) ENGINE='MyISAM';
300 RESET MASTER;
301 *** Start Slave ***
302 connection slave;
303 START SLAVE;
304 *** Master Data Insert ***
305 connection master;
306 set @b1 = 'b1b1b1b1';
307 set @b1 = concat(@b1,@b1);
308 INSERT INTO t10 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
309 ********************************************
310 *** Expect slave to fail with Error 1677 ***
311 ********************************************
312 connection slave;
313 include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
314 Last_SQL_Error = 'Column 2 of table 'test.t10' cannot be converted from type 'char(20 octets)' to type 'double''
315 *** Drop t10 ***
316 connection master;
317 DROP TABLE t10;
318 connection slave;
319 *** Create t11 on slave ***
320 STOP SLAVE;
321 include/reset_slave.inc
322 CREATE TABLE t11 (a INT KEY, b BLOB, f INT,
323 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='MyISAM';
324 *** Create t11 on Master ***
325 connection master;
326 CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
327 ) ENGINE='MyISAM';
328 RESET MASTER;
329 *** Start Slave ***
330 connection slave;
331 START SLAVE;
332 *** Master Data Insert ***
333 connection master;
334 set @b1 = 'b1b1b1b1';
335 set @b1 = concat(@b1,@b1);
336 INSERT INTO t11 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
337 ********************************************
338 *** Expect slave to fail with Error 1677 ***
339 ********************************************
340 connection slave;
341 include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
342 Last_SQL_Error = 'Column 2 of table 'test.t11' cannot be converted from type 'varchar(1016 octets)' to type 'int(11)''
343 *** Drop t11 ***
344 connection master;
345 DROP TABLE t11;
346 connection slave;
347 *** Create t12 on slave ***
348 STOP SLAVE;
349 include/reset_slave.inc
350 CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
351 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='MyISAM';
352 *** Create t12 on Master ***
353 connection master;
354 CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
355 ) ENGINE='MyISAM';
356 RESET MASTER;
357 *** Start Slave ***
358 connection slave;
359 START SLAVE;
360 *** Master Data Insert ***
361 connection master;
362 set @b1 = 'b1b1b1b1';
363 set @b1 = concat(@b1,@b1);
364 INSERT INTO t12 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
365 SELECT * FROM t12 ORDER BY a;
366 a b c
367 1 b1b1b1b1b1b1b1b1 Kyle
368 2 b1b1b1b1b1b1b1b1 JOE
369 3 b1b1b1b1b1b1b1b1 QA
370 *** Select on Slave ***
371 connection slave;
372 SELECT * FROM t12 ORDER BY a;
373 a b f c e
374 1 b1b1b1b1b1b1b1b1 Kyle test 1
375 2 b1b1b1b1b1b1b1b1 JOE test 1
376 3 b1b1b1b1b1b1b1b1 QA test 1
377 *** Drop t12 ***
378 connection master;
379 DROP TABLE t12;
380 connection slave;
381 **** Extra Colums End ****
382 *** BUG 22177 Start ***
383 *** Create t13 on slave ***
384 STOP SLAVE;
385 include/reset_slave.inc
386 CREATE TABLE t13 (a INT KEY, b BLOB, c CHAR(5),
387 d INT DEFAULT '1',
388 e TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
389 )ENGINE='MyISAM';
390 *** Create t13 on Master ***
391 connection master;
392 CREATE TABLE t13 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
393 ) ENGINE='MyISAM';
394 RESET MASTER;
395 *** Start Slave ***
396 connection slave;
397 START SLAVE;
398 *** Master Data Insert ***
399 connection master;
400 set @b1 = 'b1b1b1b1';
401 set @b1 = concat(@b1,@b1);
402 INSERT INTO t13 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
403 SELECT * FROM t13 ORDER BY a;
404 a b c
405 1 b1b1b1b1b1b1b1b1 Kyle
406 2 b1b1b1b1b1b1b1b1 JOE
407 3 b1b1b1b1b1b1b1b1 QA
408 *** Select on Slave ****
409 connection slave;
410 SELECT * FROM t13 ORDER BY a;
411 a b c d e
412 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
413 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
414 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
415 *** Drop t13 ***
416 connection master;
417 DROP TABLE t13;
418 connection slave;
419 *** 22117 END ***
420 *** Alter Master Table Testing Start ***
421 *** Create t14 on slave ***
422 STOP SLAVE;
423 include/reset_slave.inc
424 CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
425 c6 INT DEFAULT '1',
426 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
427 )ENGINE='MyISAM';
428 *** Create t14 on Master ***
429 connection master;
430 CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
431 ) ENGINE='MyISAM';
432 RESET MASTER;
433 *** Start Slave ***
434 connection slave;
435 START SLAVE;
436 *** Master Data Insert ***
437 connection master;
438 ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
439 ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
440 set @b1 = 'b1b1b1b1';
441 set @b1 = concat(@b1,@b1);
442 INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
443 (2,2.00,'This Test Should work',@b1,'JOE'),
444 (3,3.00,'If is does not, I will open a bug',@b1,'QA');
445 SELECT * FROM t14 ORDER BY c1;
446 c1 c2 c3 c4 c5
447 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle
448 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE
449 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA
450 *** Select on Slave ****
451 connection slave;
452 SELECT * FROM t14 ORDER BY c1;
453 c1 c2 c3 c4 c5 c6 c7
454 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
455 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
456 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
457 *** Create t14a on slave ***
458 STOP SLAVE;
459 include/reset_slave.inc
460 CREATE TABLE t14a (c1 INT KEY, c4 BLOB, c5 CHAR(5),
461 c6 INT DEFAULT '1',
462 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
463 )ENGINE='MyISAM';
464 *** Create t14a on Master ***
465 connection master;
466 CREATE TABLE t14a (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
467 ) ENGINE='MyISAM';
468 RESET MASTER;
469 *** Start Slave ***
470 connection slave;
471 START SLAVE;
472 *** Master Data Insert ***
473 connection master;
474 set @b1 = 'b1b1b1b1';
475 set @b1 = concat(@b1,@b1);
476 INSERT INTO t14a () VALUES(1,@b1,'Kyle'),
477 (2,@b1,'JOE'),
478 (3,@b1,'QA');
479 SELECT * FROM t14a ORDER BY c1;
480 c1 c4 c5
481 1 b1b1b1b1b1b1b1b1 Kyle
482 2 b1b1b1b1b1b1b1b1 JOE
483 3 b1b1b1b1b1b1b1b1 QA
484 *** Select on Slave ****
485 connection slave;
486 SELECT * FROM t14a ORDER BY c1;
487 c1 c4 c5 c6 c7
488 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
489 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
490 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
491 STOP SLAVE;
492 include/reset_slave.inc
493 *** Master Drop c5 ***
494 connection master;
495 ALTER TABLE t14a DROP COLUMN c5;
496 RESET MASTER;
497 *** Start Slave ***
498 connection slave;
499 START SLAVE;
500 *** Master Data Insert ***
501 connection master;
502 set @b1 = 'b1b1b1b1';
503 set @b1 = concat(@b1,@b1);
504 INSERT INTO t14a () VALUES(4,@b1),
505 (5,@b1),
506 (6,@b1);
507 SELECT * FROM t14a ORDER BY c1;
508 c1 c4
509 1 b1b1b1b1b1b1b1b1
510 2 b1b1b1b1b1b1b1b1
511 3 b1b1b1b1b1b1b1b1
512 4 b1b1b1b1b1b1b1b1
513 5 b1b1b1b1b1b1b1b1
514 6 b1b1b1b1b1b1b1b1
515 *** Select on Slave ****
516 connection slave;
517 SELECT * FROM t14a ORDER BY c1;
518 c1 c4 c5 c6 c7
519 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
520 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
521 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
522 4 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP
523 5 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP
524 6 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP
525 connection master;
526 DROP TABLE t14a;
527 connection slave;
528 *** connect to master and drop columns ***
529 connection master;
530 ALTER TABLE t14 DROP COLUMN c2;
531 ALTER TABLE t14 DROP COLUMN c4;
532 *** Select from Master ***
533 SELECT * FROM t14 ORDER BY c1;
534 c1 c3 c5
535 1 Replication Testing Extra Col Kyle
536 2 This Test Should work JOE
537 3 If is does not, I will open a bug QA
538 *** Select from Slave ***
539 connection slave;
540 SELECT * FROM t14 ORDER BY c1;
541 c1 c3 c5 c6 c7
542 1 Replication Testing Extra Col Kyle 1 CURRENT_TIMESTAMP
543 2 This Test Should work JOE 1 CURRENT_TIMESTAMP
544 3 If is does not, I will open a bug QA 1 CURRENT_TIMESTAMP
545 *** Drop t14 ***
546 connection master;
547 DROP TABLE t14;
548 connection slave;
549 *** Create t15 on slave ***
550 STOP SLAVE;
551 include/reset_slave.inc
552 CREATE TABLE t15 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
553 c4 BLOB, c5 CHAR(5),
554 c6 INT DEFAULT '1',
555 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
556 )ENGINE='MyISAM';
557 *** Create t15 on Master ***
558 connection master;
559 CREATE TABLE t15 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
560 c4 BLOB, c5 CHAR(5)) ENGINE='MyISAM';
561 RESET MASTER;
562 *** Start Slave ***
563 connection slave;
564 START SLAVE;
565 call mtr.add_suppression("Error .Unknown table .t6.. on query.* error.* 1051");
566 call mtr.add_suppression("Error .Duplicate column name .c6.. on query.* error.* 1060");
567 call mtr.add_suppression("Table definition on master and slave does not match: Column . ...e mismatch.* error.* 1535");
568 *** Master Data Insert ***
569 connection master;
570 set @b1 = 'b1b1b1b1';
571 set @b1 = concat(@b1,@b1);
572 INSERT INTO t15 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
573 (2,2.00,'This Test Should work',@b1,'JOE'),
574 (3,3.00,'If is does not, I will open a bug',@b1,'QA');
575 SELECT * FROM t15 ORDER BY c1;
576 c1 c2 c3 c4 c5
577 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle
578 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE
579 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA
580 *** Select on Slave ****
581 connection slave;
582 SELECT * FROM t15 ORDER BY c1;
583 c1 c2 c3 c4 c5 c6 c7
584 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
585 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
586 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
587 *** Add column on master that is a Extra on Slave ***
588 connection master;
589 ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5;
590 ********************************************
591 *** Expect slave to fail with Error 1060 ***
592 ********************************************
593 connection slave;
594 include/wait_for_slave_sql_error_and_skip.inc [errno=1060]
595 Last_SQL_Error = 'Error 'Duplicate column name 'c6'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5''
596 *** Try to insert in master ****
597 connection master;
598 INSERT INTO t15 () VALUES(5,2.00,'Replication Testing',@b1,'Buda',2);
599 SELECT * FROM t15 ORDER BY c1;
600 c1 c2 c3 c4 c5 c6
601 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle NULL
602 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE NULL
603 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA NULL
604 5 2.00 Replication Testing b1b1b1b1b1b1b1b1 Buda 2
605 *** Try to select from slave ****
606 connection slave;
607 SELECT * FROM t15 ORDER BY c1;
608 c1 c2 c3 c4 c5 c6 c7
609 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
610 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
611 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
612 5 2.00 Replication Testing b1b1b1b1b1b1b1b1 Buda 2 CURRENT_TIMESTAMP
613 *** DROP TABLE t15 ***
614 connection master;
615 DROP TABLE t15;
616 connection slave;
617 *** Create t16 on slave ***
618 STOP SLAVE;
619 include/reset_slave.inc
620 CREATE TABLE t16 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
621 c4 BLOB, c5 CHAR(5),
622 c6 INT DEFAULT '1',
623 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
624 )ENGINE='MyISAM';
625 *** Create t16 on Master ***
626 connection master;
627 CREATE TABLE t16 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
628 c4 BLOB, c5 CHAR(5))ENGINE='MyISAM';
629 RESET MASTER;
630 *** Start Slave ***
631 connection slave;
632 START SLAVE;
633 *** Master Data Insert ***
634 connection master;
635 set @b1 = 'b1b1b1b1';
636 set @b1 = concat(@b1,@b1);
637 INSERT INTO t16 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
638 (2,2.00,'This Test Should work',@b1,'JOE'),
639 (3,3.00,'If is does not, I will open a bug',@b1,'QA');
640 SELECT * FROM t16 ORDER BY c1;
641 c1 c2 c3 c4 c5
642 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle
643 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE
644 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA
645 *** Select on Slave ****
646 connection slave;
647 SELECT * FROM t16 ORDER BY c1;
648 c1 c2 c3 c4 c5 c6 c7
649 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
650 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
651 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
652 *** Add Partition on master ***
653 connection master;
654 ALTER TABLE t16 PARTITION BY KEY(c1) PARTITIONS 4;
655 INSERT INTO t16 () VALUES(4,1.00,'Replication Rocks',@b1,'Omer');
656 SHOW CREATE TABLE t16;
657 Table Create Table
658 t16 CREATE TABLE `t16` (
659 `c1` int(11) NOT NULL,
660 `c2` decimal(8,2) DEFAULT NULL,
661 `c3` text DEFAULT NULL,
662 `c4` blob DEFAULT NULL,
663 `c5` char(5) DEFAULT NULL,
664 PRIMARY KEY (`c1`)
665 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
666 PARTITION BY KEY (`c1`)
667 PARTITIONS 4
668 *** Show table on Slave ****
669 connection slave;
670 SHOW CREATE TABLE t16;
671 Table Create Table
672 t16 CREATE TABLE `t16` (
673 `c1` int(11) NOT NULL,
674 `c2` decimal(8,2) DEFAULT NULL,
675 `c3` text DEFAULT NULL,
676 `c4` blob DEFAULT NULL,
677 `c5` char(5) DEFAULT NULL,
678 `c6` int(11) DEFAULT 1,
679 `c7` timestamp NULL DEFAULT current_timestamp(),
680 PRIMARY KEY (`c1`)
681 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
682 PARTITION BY KEY (`c1`)
683 PARTITIONS 4
684 *** DROP TABLE t16 ***
685 connection master;
686 DROP TABLE t16;
687 connection slave;
688 *** Alter Master End ***
689 *** Create t17 on slave ***
690 STOP SLAVE;
691 include/reset_slave.inc
692 CREATE TABLE t17 (a SMALLINT, b INT PRIMARY KEY, c CHAR(5),
693 d FLOAT DEFAULT '2.00',
694 e CHAR(5) DEFAULT 'TEST2')
695 ENGINE='MyISAM';
696 *** Create t17 on Master ***
697 connection master;
698 CREATE TABLE t17 (a BIGINT PRIMARY KEY, b INT, c CHAR(10)
699 ) ENGINE='MyISAM';
700 RESET MASTER;
701 *** Start Slave ***
702 connection slave;
703 START SLAVE;
704 *** Master Data Insert ***
705 connection master;
706 INSERT INTO t17 () VALUES(9223372036854775807,2,'Kyle, TEX');
707 ********************************************
708 *** Expect slave to fail with Error 1677 ***
709 ********************************************
710 connection slave;
711 include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
712 Last_SQL_Error = 'Column 0 of table 'test.t17' cannot be converted from type 'bigint' to type 'smallint(6)''
713 ** DROP table t17 ***
714 connection master;
715 DROP TABLE t17;
716 connection slave;
717 include/rpl_end.inc