Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_extra_col_slave_innodb.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CALL mtr.add_suppression("Replica: .*Duplicate column name");
7 call mtr.add_suppression("Replica: Unknown table 'test.t6' Error_code: 1051");
8 call mtr.add_suppression("Replica SQL.*Column [0-9] of table .test.t[0-9]*. cannot be converted from type.* Error_code: MY-013146");
9 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
10 **** Diff Table Def Start ****
11 *** On Slave ***
12 STOP SLAVE;
13 Warnings:
14 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
15 SET @saved_replica_type_conversions = @@replica_type_conversions;
16 SET GLOBAL REPLICA_TYPE_CONVERSIONS = 'ALL_NON_LOSSY';
17 CREATE TABLE t1 (a INT, b INT PRIMARY KEY, c CHAR(20),
18 d FLOAT DEFAULT '2.00',
19 e CHAR(4) DEFAULT 'TEST')
20 ENGINE='InnoDB';
21 *** Create t1 on Master ***
22 CREATE TABLE t1 (a INT PRIMARY KEY, b INT, c CHAR(10)
23 ) ENGINE='InnoDB';
24 *** Start Slave ***
25 include/rpl_reset.inc
26 *** Master Data Insert ***
27 INSERT INTO t1 () VALUES(1,2,'TEXAS'),(2,1,'AUSTIN'),(3,4,'QA');
28 SELECT * FROM t1 ORDER BY a;
29 a b c
30 1 2 TEXAS
31 2 1 AUSTIN
32 3 4 QA
33 *** Select from slave ***
34 SELECT * FROM t1 ORDER BY a;
35 a b c d e
36 1 2 TEXAS 2 TEST
37 2 1 AUSTIN 2 TEST
38 3 4 QA 2 TEST
39 SET GLOBAL REPLICA_TYPE_CONVERSIONS = @saved_replica_type_conversions;
40 *** Drop t1 ***
41 DROP TABLE t1;
42 *** Create t2 on slave ***
43 STOP SLAVE;
44 Warnings:
45 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
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='InnoDB';
50 *** Create t2 on Master ***
51 CREATE TABLE t2 (a INT PRIMARY KEY, b INT, c CHAR(10)
52 ) ENGINE='InnoDB';
53 *** Start Slave ***
54 include/rpl_reset.inc
55 *** Master Data Insert ***
56 INSERT INTO t2 () VALUES(1,2,'Kyle, TEX'),(2,1,'JOE AUSTIN'),(3,4,'QA TESTING');
57 SELECT * FROM t2 ORDER BY a;
58 a b c
59 1 2 Kyle, TEX
60 2 1 JOE AUSTIN
61 3 4 QA TESTING
62 include/wait_for_slave_sql_error.inc [errno=13146]
63 STOP SLAVE;
64 Warnings:
65 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
66 include/rpl_reset.inc
67 SELECT * FROM t2 ORDER BY a;
68 a b c d e
69 *** Drop t2 ***
70 DROP TABLE t2;
71 *** Create t3 on slave ***
72 STOP SLAVE;
73 Warnings:
74 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
75 CREATE TABLE t3 (a INT, b INT PRIMARY KEY, c CHAR(20),
76 d FLOAT DEFAULT '2.00',
77 e CHAR(5) DEFAULT 'TEST2')
78 ENGINE='InnoDB';
79 *** Create t3 on Master ***
80 CREATE TABLE t3 (a BLOB, b INT PRIMARY KEY, c CHAR(20)
81 ) ENGINE='InnoDB';
82 *** Start Slave ***
83 include/rpl_reset.inc
84 *** Master Data Insert ***
85 set @b1 = 'b1';
86 set @b1 = concat(@b1,@b1);
87 INSERT INTO t3 () VALUES(@b1,2,'Kyle, TEX'),(@b1,1,'JOE AUSTIN'),(@b1,4,'QA TESTING');
88 ******************************************************************
89 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
90 ******************************************************************
91 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
92 *** Drop t3 ***
93 DROP TABLE t3;
94 *** Create t4 on slave ***
95 STOP SLAVE;
96 Warnings:
97 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
98 CREATE TABLE t4 (a INT, b INT PRIMARY KEY, c CHAR(20),
99 d FLOAT DEFAULT '2.00',
100 e CHAR(5) DEFAULT 'TEST2')
101 ENGINE='InnoDB';
102 *** Create t4 on Master ***
103 CREATE TABLE t4 (a DECIMAL(8,2), b INT PRIMARY KEY, c CHAR(20)
104 ) ENGINE='InnoDB';
105 *** Start Slave ***
106 include/rpl_reset.inc
107 *** Master Data Insert ***
108 INSERT INTO t4 () VALUES(100.22,2,'Kyle, TEX'),(200.26,1,'JOE AUSTIN'),
109 (30000.22,4,'QA TESTING');
110 ******************************************************************
111 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
112 ******************************************************************
113 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
114 *** Drop t4 ***
115 DROP TABLE t4;
116 *** Create t5 on slave ***
117 STOP SLAVE;
118 Warnings:
119 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
120 CREATE TABLE t5 (a INT PRIMARY KEY, b CHAR(5),
121 c FLOAT, d INT, e DOUBLE,
122 f DECIMAL(8,2))ENGINE='InnoDB';
123 *** Create t5 on Master ***
124 CREATE TABLE t5 (a INT PRIMARY KEY, b VARCHAR(6),
125 c DECIMAL(8,2), d BIT, e BLOB,
126 f FLOAT) ENGINE='InnoDB';
127 *** Start Slave ***
128 include/rpl_reset.inc
129 *** Master Data Insert ***
130 INSERT INTO t5 () VALUES(1,'Kyle',200.23,1,'b1b1',23.00098),
131 (2,'JOE',300.01,0,'b2b2',1.0000009);
132 ******************************************************************
133 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
134 ******************************************************************
135 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
136 *** Drop t5 ***
137 DROP TABLE t5;
138 *** Create t6 on slave ***
139 STOP SLAVE;
140 Warnings:
141 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
142 CREATE TABLE t6 (a INT PRIMARY KEY, b CHAR(5),
143 c FLOAT, d INT)ENGINE='InnoDB';
144 *** Create t6 on Master ***
145 CREATE TABLE t6 (a INT PRIMARY KEY, b VARCHAR(6),
146 c DECIMAL(8,2), d BIT
147 ) ENGINE='InnoDB';
148 *** Start Slave ***
149 include/rpl_reset.inc
150 *** Master Data Insert ***
151 INSERT INTO t6 () VALUES(1,'Kyle',200.23,1),
152 (2,'JOE',300.01,0);
153 ******************************************************************
154 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
155 ******************************************************************
156 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
157 *** Drop t6 ***
158 include/rpl_reset.inc
159 DROP TABLE t6;
160 **** Diff Table Def End ****
161 **** Extra Colums Start ****
162 *** Create t7 on slave ***
163 STOP SLAVE;
164 Warnings:
165 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
166 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
167 CREATE TABLE t7 (a INT KEY, b BLOB, c CHAR(5),
168 d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
169 e CHAR(20) DEFAULT 'Extra Column Testing')
170 ENGINE='InnoDB';
171 *** Create t7 on Master ***
172 CREATE TABLE t7 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
173 ) ENGINE='InnoDB';
174 *** Start Slave ***
175 include/rpl_reset.inc
176 *** Master Data Insert ***
177 set @b1 = 'b1';
178 set @b1 = concat(@b1,@b1);
179 INSERT INTO t7 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
180 SELECT * FROM t7 ORDER BY a;
181 a b c
182 1 b1b1 Kyle
183 2 b1b1 JOE
184 3 b1b1 QA
185 *** Select from slave ***
186 SELECT * FROM t7 ORDER BY a;
187 a b c d e
188 1 b1b1 Kyle 0000-00-00 00:00:00 Extra Column Testing
189 2 b1b1 JOE 0000-00-00 00:00:00 Extra Column Testing
190 3 b1b1 QA 0000-00-00 00:00:00 Extra Column Testing
191 *** Drop t7 ***
192 DROP TABLE t7;
193 *** Create t8 on slave ***
194 STOP SLAVE;
195 Warnings:
196 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
197 CREATE TABLE t8 (a INT KEY, b BLOB, c CHAR(5),
198 d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
199 e INT)ENGINE='InnoDB';
200 SET sql_mode = default;
201 *** Create t8 on Master ***
202 CREATE TABLE t8 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
203 ) ENGINE='InnoDB';
204 *** Start Slave ***
205 include/rpl_reset.inc
206 *** Master Data Insert ***
207 set @b1 = 'b1b1b1b1';
208 set @b1 = concat(@b1,@b1);
209 INSERT INTO t8 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
210 *** Drop t8 ***
211 DROP TABLE t8;
212 STOP SLAVE;
213 Warnings:
214 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
215 CREATE TABLE t9 (a INT KEY, b BLOB, c CHAR(5),
216 d TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
217 ON UPDATE CURRENT_TIMESTAMP,
218 e INT NOT NULL,
219 f text not null,
220 g text,
221 h blob not null,
222 i blob) ENGINE='InnoDB';
223 *** Create t9 on Master ***
224 CREATE TABLE t9 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
225 ) ENGINE='InnoDB';
226 SET @previous_sql_mode = @@sql_mode;
227 SET sql_mode = (select concat('ALLOW_INVALID_DATES,',
228 replace(replace(@@sql_mode,'NO_ZERO_DATE',''), 'NO_ZERO_IN_DATE','')));
229 *** Start Slave ***
230 include/rpl_reset.inc
231 SET @previous_sql_mode = @@sql_mode;
232 SET sql_mode = (select concat('ALLOW_INVALID_DATES,',
233 replace(replace(@@sql_mode,'NO_ZERO_DATE',''), 'NO_ZERO_IN_DATE','')));
234 *** Master Data Insert ***
235 set @b1 = 'b1b1b1b1';
236 set @b1 = concat(@b1,@b1);
237 INSERT INTO t9 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
238 select * from t9;
239 a b c d e f g h i
240 1 b1b1b1b1b1b1b1b1 Kyle CURRENT_TIMESTAMP 0 NULL NULL
241 2 b1b1b1b1b1b1b1b1 JOE CURRENT_TIMESTAMP 0 NULL NULL
242 3 b1b1b1b1b1b1b1b1 QA CURRENT_TIMESTAMP 0 NULL NULL
243 include/assert.inc [The values of column 'd' should have non-zero timetsamp.]
244 SET sql_mode = @previous_sql_mode;
245 DROP TABLE t9;
246 SET sql_mode = @previous_sql_mode;
247 *** Create t10 on slave ***
248 STOP SLAVE;
249 Warnings:
250 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
251 CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
252 c CHAR(5), e INT DEFAULT '1')ENGINE='InnoDB';
253 *** Create t10 on Master ***
254 CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
255 ) ENGINE='InnoDB';
256 *** Start Slave ***
257 include/rpl_reset.inc
258 *** Master Data Insert ***
259 set @b1 = 'b1b1b1b1';
260 set @b1 = concat(@b1,@b1);
261 INSERT INTO t10 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
262 ******************************************************************
263 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
264 ******************************************************************
265 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
266 *** Drop t10 ***
267 DROP TABLE t10;
268 *** Create t11 on slave ***
269 STOP SLAVE;
270 Warnings:
271 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
272 CREATE TABLE t11 (a INT KEY, b BLOB, f INT,
273 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='InnoDB';
274 *** Create t11 on Master ***
275 CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
276 ) ENGINE='InnoDB';
277 *** Start Slave ***
278 include/rpl_reset.inc
279 *** Master Data Insert ***
280 set @b1 = 'b1b1b1b1';
281 set @b1 = concat(@b1,@b1);
282 INSERT INTO t11 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
283 ******************************************************************
284 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
285 ******************************************************************
286 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
287 *** Drop t11 ***
288 DROP TABLE t11;
289 *** Create t12 on slave ***
290 STOP SLAVE;
291 Warnings:
292 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
293 CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
294 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='InnoDB';
295 *** Create t12 on Master ***
296 CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
297 ) ENGINE='InnoDB';
298 *** Start Slave ***
299 include/rpl_reset.inc
300 *** Master Data Insert ***
301 set @b1 = 'b1b1b1b1';
302 set @b1 = concat(@b1,@b1);
303 INSERT INTO t12 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
304 SELECT * FROM t12 ORDER BY a;
305 a b c
306 1 b1b1b1b1b1b1b1b1 Kyle
307 2 b1b1b1b1b1b1b1b1 JOE
308 3 b1b1b1b1b1b1b1b1 QA
309 *** Select on Slave ***
310 SELECT * FROM t12 ORDER BY a;
311 a b f c e
312 1 b1b1b1b1b1b1b1b1 Kyle test 1
313 2 b1b1b1b1b1b1b1b1 JOE test 1
314 3 b1b1b1b1b1b1b1b1 QA test 1
315 *** Drop t12 ***
316 DROP TABLE t12;
317 **** Extra Colums End ****
318 *** BUG 22177 Start ***
319 *** Create t13 on slave ***
320 STOP SLAVE;
321 Warnings:
322 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
323 CREATE TABLE t13 (a INT KEY, b BLOB, c CHAR(5),
324 d INT DEFAULT '1',
325 e TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
326 )ENGINE='InnoDB';
327 *** Create t13 on Master ***
328 CREATE TABLE t13 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
329 ) ENGINE='InnoDB';
330 *** Start Slave ***
331 include/rpl_reset.inc
332 *** Master Data Insert ***
333 set @b1 = 'b1b1b1b1';
334 set @b1 = concat(@b1,@b1);
335 INSERT INTO t13 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
336 SELECT * FROM t13 ORDER BY a;
337 a b c
338 1 b1b1b1b1b1b1b1b1 Kyle
339 2 b1b1b1b1b1b1b1b1 JOE
340 3 b1b1b1b1b1b1b1b1 QA
341 *** Select on Slave ****
342 SELECT * FROM t13 ORDER BY a;
343 a b c d e
344 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
345 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
346 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
347 *** Drop t13 ***
348 DROP TABLE t13;
349 *** 22117 END ***
350 *** Alter Master Table Testing Start ***
351 *** Create t14 on slave ***
352 STOP SLAVE;
353 Warnings:
354 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
355 CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
356 c6 INT DEFAULT '1',
357 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
358 )ENGINE='InnoDB';
359 *** Create t14 on Master ***
360 CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
361 ) ENGINE='InnoDB';
362 *** Start Slave ***
363 include/rpl_reset.inc
364 *** Master Data Insert ***
365 ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
366 ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
367 set @b1 = 'b1b1b1b1';
368 set @b1 = concat(@b1,@b1);
369 INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
370 (2,2.00,'This Test Should work',@b1,'JOE'),
371 (3,3.00,'If is does not, I will open a bug',@b1,'QA');
372 SELECT * FROM t14 ORDER BY c1;
373 c1 c2 c3 c4 c5
374 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle
375 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE
376 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA
377 *** Select on Slave ****
378 SELECT * FROM t14 ORDER BY c1;
379 c1 c2 c3 c4 c5 c6 c7
380 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
381 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
382 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
383 *** Create t14a on slave ***
384 STOP SLAVE;
385 Warnings:
386 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
387 CREATE TABLE t14a (c1 INT KEY, c4 BLOB, c5 CHAR(5),
388 c6 INT DEFAULT '1',
389 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
390 )ENGINE='InnoDB';
391 *** Create t14a on Master ***
392 CREATE TABLE t14a (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
393 ) ENGINE='InnoDB';
394 *** Start Slave ***
395 include/rpl_reset.inc
396 *** Master Data Insert ***
397 set @b1 = 'b1b1b1b1';
398 set @b1 = concat(@b1,@b1);
399 INSERT INTO t14a () VALUES(1,@b1,'Kyle'),
400 (2,@b1,'JOE'),
401 (3,@b1,'QA');
402 SELECT * FROM t14a ORDER BY c1;
403 c1 c4 c5
404 1 b1b1b1b1b1b1b1b1 Kyle
405 2 b1b1b1b1b1b1b1b1 JOE
406 3 b1b1b1b1b1b1b1b1 QA
407 *** Select on Slave ****
408 SELECT * FROM t14a ORDER BY c1;
409 c1 c4 c5 c6 c7
410 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
411 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
412 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
413 STOP SLAVE;
414 Warnings:
415 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
416 *** Master Drop c5 ***
417 ALTER TABLE t14a DROP COLUMN c5;
418 *** Start Slave ***
419 include/rpl_reset.inc
420 *** Master Data Insert ***
421 set @b1 = 'b1b1b1b1';
422 set @b1 = concat(@b1,@b1);
423 INSERT INTO t14a () VALUES(4,@b1),
424 (5,@b1),
425 (6,@b1);
426 SELECT * FROM t14a ORDER BY c1;
427 c1 c4
428 1 b1b1b1b1b1b1b1b1
429 2 b1b1b1b1b1b1b1b1
430 3 b1b1b1b1b1b1b1b1
431 4 b1b1b1b1b1b1b1b1
432 5 b1b1b1b1b1b1b1b1
433 6 b1b1b1b1b1b1b1b1
434 *** Select on Slave ****
435 SELECT * FROM t14a ORDER BY c1;
436 c1 c4 c5 c6 c7
437 1 b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
438 2 b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
439 3 b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
440 4 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP
441 5 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP
442 6 b1b1b1b1b1b1b1b1 NULL 1 CURRENT_TIMESTAMP
443 DROP TABLE t14a;
444 *** connect to master and drop columns ***
445 ALTER TABLE t14 DROP COLUMN c2;
446 ALTER TABLE t14 DROP COLUMN c4;
447 *** Select from Master ***
448 SELECT * FROM t14 ORDER BY c1;
449 c1 c3 c5
450 1 Replication Testing Extra Col Kyle
451 2 This Test Should work JOE
452 3 If is does not, I will open a bug QA
453 *** Select from Slave ***
454 SELECT * FROM t14 ORDER BY c1;
455 c1 c3 c5 c6 c7
456 1 Replication Testing Extra Col Kyle 1 CURRENT_TIMESTAMP
457 2 This Test Should work JOE 1 CURRENT_TIMESTAMP
458 3 If is does not, I will open a bug QA 1 CURRENT_TIMESTAMP
459 *** Drop t14 ***
460 DROP TABLE t14;
461 *** Create t15 on slave ***
462 STOP SLAVE;
463 Warnings:
464 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
465 CREATE TABLE t15 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
466 c4 BLOB, c5 CHAR(5),
467 c6 INT DEFAULT '1',
468 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
469 )ENGINE='InnoDB';
470 *** Create t15 on Master ***
471 CREATE TABLE t15 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
472 c4 BLOB, c5 CHAR(5)) ENGINE='InnoDB';
473 *** Start Slave ***
474 include/rpl_reset.inc
475 call mtr.add_suppression("Error .Unknown table .t6.. on query.* Error_code: 1051");
476 call mtr.add_suppression("Error .Duplicate column name .c6.. on query.* Error_code: MY-001060");
477 call mtr.add_suppression("Table definition on source and replica does not match: Column . ...e mismatch.* Error_code: 1535");
478 *** Master Data Insert ***
479 set @b1 = 'b1b1b1b1';
480 set @b1 = concat(@b1,@b1);
481 INSERT INTO t15 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
482 (2,2.00,'This Test Should work',@b1,'JOE'),
483 (3,3.00,'If is does not, I will open a bug',@b1,'QA');
484 SELECT * FROM t15 ORDER BY c1;
485 c1 c2 c3 c4 c5
486 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle
487 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE
488 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA
489 *** Select on Slave ****
490 SELECT * FROM t15 ORDER BY c1;
491 c1 c2 c3 c4 c5 c6 c7
492 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
493 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
494 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
495 *** Add column on master that is a Extra on Slave ***
496 ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5;
497 ********************************************************
498 *** Expect slave to fail with Error ER_DUP_FIELDNAME ***
499 ********************************************************
500 include/wait_for_slave_sql_error_and_skip.inc [errno=1060]
501 *** Try to insert in master ****
502 INSERT INTO t15 () VALUES(5,2.00,'Replication Testing',@b1,'Buda',2);
503 SELECT * FROM t15 ORDER BY c1;
504 c1 c2 c3 c4 c5 c6
505 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle NULL
506 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE NULL
507 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA NULL
508 5 2.00 Replication Testing b1b1b1b1b1b1b1b1 Buda 2
509 *** Try to select from slave ****
510 SELECT * FROM t15 ORDER BY c1;
511 c1 c2 c3 c4 c5 c6 c7
512 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
513 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
514 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
515 5 2.00 Replication Testing b1b1b1b1b1b1b1b1 Buda 2 CURRENT_TIMESTAMP
516 *** DROP TABLE t15 ***
517 DROP TABLE t15;
518 *** Create t16 on slave ***
519 STOP SLAVE;
520 Warnings:
521 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
522 CREATE TABLE t16 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
523 c4 BLOB, c5 CHAR(5),
524 c6 INT DEFAULT '1',
525 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
526 )ENGINE='InnoDB';
527 *** Create t16 on Master ***
528 CREATE TABLE t16 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
529 c4 BLOB, c5 CHAR(5))ENGINE='InnoDB';
530 *** Start Slave ***
531 include/rpl_reset.inc
532 *** Master Data Insert ***
533 set @b1 = 'b1b1b1b1';
534 set @b1 = concat(@b1,@b1);
535 INSERT INTO t16 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
536 (2,2.00,'This Test Should work',@b1,'JOE'),
537 (3,3.00,'If is does not, I will open a bug',@b1,'QA');
538 SELECT * FROM t16 ORDER BY c1;
539 c1 c2 c3 c4 c5
540 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle
541 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE
542 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA
543 *** Select on Slave ****
544 SELECT * FROM t16 ORDER BY c1;
545 c1 c2 c3 c4 c5 c6 c7
546 1 1.00 Replication Testing Extra Col b1b1b1b1b1b1b1b1 Kyle 1 CURRENT_TIMESTAMP
547 2 2.00 This Test Should work b1b1b1b1b1b1b1b1 JOE 1 CURRENT_TIMESTAMP
548 3 3.00 If is does not, I will open a bug b1b1b1b1b1b1b1b1 QA 1 CURRENT_TIMESTAMP
549 *** Add Partition on master if native partitioning is supported ***
550 ALTER TABLE t16 PARTITION BY KEY(c1) PARTITIONS 4;
551 INSERT INTO t16 () VALUES(4,1.00,'Replication Rocks',@b1,'Omer');
552 SHOW CREATE TABLE t16;
553 Table Create Table
554 t16 CREATE TABLE `t16` (
555 `c1` int NOT NULL,
556 `c2` decimal(8,2) DEFAULT NULL,
557 `c3` text,
558 `c4` blob,
559 `c5` char(5) DEFAULT NULL,
560 PRIMARY KEY (`c1`)
561 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
562 /*!50100 PARTITION BY KEY (c1)
563 PARTITIONS 4 */
564 *** Show table on Slave ****
565 SHOW CREATE TABLE t16;
566 Table Create Table
567 t16 CREATE TABLE `t16` (
568 `c1` int NOT NULL,
569 `c2` decimal(8,2) DEFAULT NULL,
570 `c3` text,
571 `c4` blob,
572 `c5` char(5) DEFAULT NULL,
573 `c6` int DEFAULT '1',
574 `c7` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
575 PRIMARY KEY (`c1`)
576 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
577 /*!50100 PARTITION BY KEY (c1)
578 PARTITIONS 4 */
579 *** DROP TABLE t16 ***
580 DROP TABLE t16;
581 *** Alter Master End ***
582 *** Create t17 on slave ***
583 STOP SLAVE;
584 Warnings:
585 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
586 CREATE TABLE t17 (a SMALLINT, b INT PRIMARY KEY, c CHAR(5),
587 d FLOAT DEFAULT '2.00',
588 e CHAR(5) DEFAULT 'TEST2')
589 ENGINE='InnoDB';
590 *** Create t17 on Master ***
591 CREATE TABLE t17 (a BIGINT PRIMARY KEY, b INT, c CHAR(10)
592 ) ENGINE='InnoDB';
593 *** Start Slave ***
594 include/rpl_reset.inc
595 *** Master Data Insert ***
596 INSERT INTO t17 () VALUES(9223372036854775807,2,'Kyle, TEX');
597 ******************************************************************
598 *** Expect slave to fail with Error ER_REPLICA_CONVERSION_FAILED ***
599 ******************************************************************
600 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
601 ** DROP table t17 ***
602 DROP TABLE t17;
603 include/rpl_end.inc