Debian Codegraph @

mysql-test/suite/rpl_ndb/r/rpl_ndb_extra_col_master.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 set binlog_format='row';
7 Warnings:
8 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
9
10 ***********************************************************
11 ***********************************************************
12 ***************** Start of Testing ************************
13 ***********************************************************
14 ***********************************************************
15 * This test format == binlog_format ROW and engine == 'NDB'
16 ***********************************************************
17 ***********************************************************
18
19 ***** Testing more columns on the Master *****
20
21 CREATE TABLE t1 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
22 /* extra */
23 f5 FLOAT DEFAULT '2.00',
24 f6 CHAR(4) DEFAULT 'TEST',
25 f7 INT DEFAULT '0',
26 f8 TEXT,
27 f9 LONGBLOB,
28 f10 BIT(63),
29 f11 VARBINARY(64))ENGINE='NDB';
30
31 * Alter Table on Slave and drop columns f5 through f11 *
32
33 alter table t1 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
34
35 * Insert data in Master then update and delete some rows*
36
37 * Select count and 20 rows from Master *
38
39 SELECT COUNT(*) FROM t1;
40 COUNT(*)
41 40
42
43 SELECT f1,f2,f3,f4,f5,f6,f7,f8,f9,
44 hex(f10),hex(f11) FROM t1 ORDER BY f3 LIMIT 20;
45 f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex(f11)
46 2 2 2 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
47 3 3 3 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
48 5 5 5 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
49 6 6 6 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
50 8 8 8 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
51 9 9 9 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
52 11 11 11 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
53 12 12 12 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
54 14 14 14 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
55 15 15 15 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
56 17 17 17 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
57 18 18 18 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
58 20 20 20 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
59 21 21 21 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
60 23 23 23 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
61 24 24 24 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
62 26 26 26 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
63 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
64 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
65 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
66
67 * Select count and 20 rows from Slave *
68
69 SELECT COUNT(*) FROM t1;
70 COUNT(*)
71 40
72
73 SELECT * FROM t1 ORDER BY f3 LIMIT 20;
74 f1 f2 f3 f4
75 2 2 2 second
76 3 3 3 next
77 5 5 5 second
78 6 6 6 next
79 8 8 8 second
80 9 9 9 next
81 11 11 11 second
82 12 12 12 next
83 14 14 14 second
84 15 15 15 next
85 17 17 17 second
86 18 18 18 next
87 20 20 20 second
88 21 21 21 next
89 23 23 23 second
90 24 24 24 next
91 26 26 26 second
92 27 27 27 next
93 29 29 29 second
94 30 30 30 next
95 include/check_slave_is_running.inc
96
97 ***** Testing Altering table def scenario *****
98
99 CREATE TABLE t2 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
100 /* extra */
101 f5 DOUBLE DEFAULT '2.00',
102 f6 ENUM('a', 'b', 'c') default 'a',
103 f7 DECIMAL(17,9) default '1000.00',
104 f8 MEDIUMBLOB,
105 f9 NUMERIC(6,2) default '2000.00',
106 f10 VARCHAR(1024),
107 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
108 f12 SET('a', 'b', 'c') default 'b')
109 ENGINE='NDB';
110
111 CREATE TABLE t3 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
112 /* extra */
113 f5 DOUBLE DEFAULT '2.00',
114 f6 ENUM('a', 'b', 'c') default 'a',
115 f8 MEDIUMBLOB,
116 f10 VARCHAR(1024),
117 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
118 f12 SET('a', 'b', 'c') default 'b')
119 ENGINE='NDB';
120
121 CREATE TABLE t4 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
122 /* extra */
123 f5 DOUBLE DEFAULT '2.00',
124 f6 DECIMAL(17,9) default '1000.00',
125 f7 MEDIUMBLOB,
126 f8 NUMERIC(6,2) default '2000.00',
127 f9 VARCHAR(1024),
128 f10 BINARY(20) not null default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
129 f11 CHAR(255))
130 ENGINE='NDB';
131
132 CREATE TABLE t31 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
133 /* extra */
134 f5 BIGINT,
135 f6 BLOB,
136 f7 DATE,
137 f8 DATETIME,
138 f9 FLOAT,
139 f10 INT,
140 f11 LONGBLOB,
141 f12 LONGTEXT,
142 f13 MEDIUMBLOB,
143 f14 MEDIUMINT,
144 f15 MEDIUMTEXT,
145 f16 REAL,
146 f17 SMALLINT,
147 f18 TEXT,
148 f19 TIME,
149 f20 TIMESTAMP,
150 f21 TINYBLOB,
151 f22 TINYINT,
152 f23 TINYTEXT,
153 f24 YEAR,
154 f25 BINARY(255),
155 f26 BIT(64),
156 f27 CHAR(255),
157 f28 DECIMAL(30,7),
158 f29 DOUBLE,
159 f30 ENUM ('a','b', 'c') default 'a',
160 f31 FLOAT,
161 f32 NUMERIC(17,9),
162 f33 SET ('a', 'b', 'c') default 'b',
163 f34 VARBINARY(1025),
164 f35 VARCHAR(257)
165 ) ENGINE='NDB';
166
167 ** Alter tables on slave and drop columns **
168
169 alter table t2 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11, drop
170 f12;
171 alter table t3 drop f5, drop f6, drop f8, drop f10, drop f11, drop f12;
172 alter table t4 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
173 alter table t31
174 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11,
175 drop f12, drop f13, drop f14, drop f15, drop f16, drop f17, drop f18,
176 drop f19, drop f20, drop f21, drop f22, drop f23, drop f24, drop f25,
177 drop f26, drop f27, drop f28, drop f29, drop f30, drop f31, drop f32,
178 drop f33, drop f34, drop f35;
179
180 ** Insert Data into Master **
181 INSERT into t2 set f1=1, f2=1, f3=1, f4='first', f8='f8: medium size blob', f10='f10:
182 some var char';
183 INSERT into t2 values (2, 2, 2, 'second',
184 2.0, 'b', 2000.0002, 'f8: medium size blob', 2000, 'f10: some var char',
185 '01234567', 'c'),
186 (3, 3, 3, 'third',
187 3.0, 'b', 3000.0003, 'f8: medium size blob', 3000, 'f10: some var char',
188 '01234567', 'c');
189 INSERT into t3 set f1=1, f2=1, f3=1, f4='first', f10='f10: some var char';
190 INSERT into t4 set f1=1, f2=1, f3=1, f4='first', f7='f7: medium size blob', f10='f10:
191 binary data';
192 INSERT into t31 set f1=1, f2=1, f3=1, f4='first';
193 INSERT IGNORE into t31 set f1=1, f2=1, f3=2, f4='second',
194 f9=2.2, f10='seven samurai', f28=222.222, f35='222';
195 Warnings:
196 Warning 1366 Incorrect integer value: 'seven samurai' for column 'f10' at row 1
197 INSERT IGNORE into t31 values (1, 1, 3, 'third',
198 /* f5 BIGINT, */ 333333333333333333333333,
199 /* f6 BLOB, */ '3333333333333333333333',
200 /* f7 DATE, */ '2007-07-18',
201 /* f8 DATETIME, */ "2007-07-18",
202 /* f9 FLOAT, */ 3.33333333,
203 /* f10 INT, */ 333333333,
204 /* f11 LONGBLOB, */ '3333333333333333333',
205 /* f12 LONGTEXT, */ '3333333333333333333',
206 /* f13 MEDIUMBLOB, */ '3333333333333333333',
207 /* f14 MEDIUMINT, */ 33,
208 /* f15 MEDIUMTEXT, */ 3.3,
209 /* f16 REAL, */ 3.3,
210 /* f17 SMALLINT, */ 3,
211 /* f18 TEXT, */ '33',
212 /* f19 TIME, */ '2:59:58.999',
213 /* f20 TIMESTAMP, */ 20000303000000,
214 /* f21 TINYBLOB, */ '3333',
215 /* f22 TINYINT, */ 3,
216 /* f23 TINYTEXT, */ '3',
217 /* f24 YEAR, */ 3000,
218 /* f25 BINARY(255), */ 'three_33333',
219 /* f26 BIT(64), */ b'011',
220 /* f27 CHAR(255), */ 'three',
221 /* f28 DECIMAL(30,7), */ 3.333,
222 /* f29 DOUBLE, */ 3.333333333333333333333333333,
223 /* f30 ENUM ('a','b','c')*/ 'c',
224 /* f31 FLOAT, */ 3.0,
225 /* f32 NUMERIC(17,9), */ 3.3333,
226 /* f33 SET ('a','b','c'),*/ 'c',
227 /*f34 VARBINARY(1025),*/ '3333 minus 3',
228 /*f35 VARCHAR(257),*/ 'three times three'
229 );
230 Warnings:
231 Warning 1264 Out of range value for column 'f5' at row 1
232 Warning 1264 Out of range value for column 'f24' at row 1
233 INSERT IGNORE into t31 values (1, 1, 4, 'fourth',
234 /* f5 BIGINT, */ 333333333333333333333333,
235 /* f6 BLOB, */ '3333333333333333333333',
236 /* f7 DATE, */ '2007-07-18',
237 /* f8 DATETIME, */ "2007-07-18",
238 /* f9 FLOAT, */ 3.33333333,
239 /* f10 INT, */ 333333333,
240 /* f11 LONGBLOB, */ '3333333333333333333',
241 /* f12 LONGTEXT, */ '3333333333333333333',
242 /* f13 MEDIUMBLOB, */ '3333333333333333333',
243 /* f14 MEDIUMINT, */ 33,
244 /* f15 MEDIUMTEXT, */ 3.3,
245 /* f16 REAL, */ 3.3,
246 /* f17 SMALLINT, */ 3,
247 /* f18 TEXT, */ '33',
248 /* f19 TIME, */ '2:59:58.999',
249 /* f20 TIMESTAMP, */ 20000303000000,
250 /* f21 TINYBLOB, */ '3333',
251 /* f22 TINYINT, */ 3,
252 /* f23 TINYTEXT, */ '3',
253 /* f24 YEAR, */ 3000,
254 /* f25 BINARY(255), */ 'three_33333',
255 /* f26 BIT(64), */ b'011',
256 /* f27 CHAR(255), */ 'three',
257 /* f28 DECIMAL(30,7), */ 3.333,
258 /* f29 DOUBLE, */ 3.333333333333333333333333333,
259 /* f30 ENUM ('a','b','c')*/ 'c',
260 /* f31 FLOAT, */ 3.0,
261 /* f32 NUMERIC(17,9), */ 3.3333,
262 /* f33 SET ('a','b','c'),*/ 'c',
263 /*f34 VARBINARY(1025),*/ '3333 minus 3',
264 /*f35 VARCHAR(257),*/ 'three times three'
265 ),
266 (1, 1, 5, 'fifth',
267 /* f5 BIGINT, */ 333333333333333333333333,
268 /* f6 BLOB, */ '3333333333333333333333',
269 /* f7 DATE, */ '2007-07-18',
270 /* f8 DATETIME, */ "2007-07-18",
271 /* f9 FLOAT, */ 3.33333333,
272 /* f10 INT, */ 333333333,
273 /* f11 LONGBLOB, */ '3333333333333333333',
274 /* f12 LONGTEXT, */ '3333333333333333333',
275 /* f13 MEDIUMBLOB, */ '3333333333333333333',
276 /* f14 MEDIUMINT, */ 33,
277 /* f15 MEDIUMTEXT, */ 3.3,
278 /* f16 REAL, */ 3.3,
279 /* f17 SMALLINT, */ 3,
280 /* f18 TEXT, */ '33',
281 /* f19 TIME, */ '2:59:58.999',
282 /* f20 TIMESTAMP, */ 20000303000000,
283 /* f21 TINYBLOB, */ '3333',
284 /* f22 TINYINT, */ 3,
285 /* f23 TINYTEXT, */ '3',
286 /* f24 YEAR, */ 3000,
287 /* f25 BINARY(255), */ 'three_33333',
288 /* f26 BIT(64), */ b'011',
289 /* f27 CHAR(255), */ 'three',
290 /* f28 DECIMAL(30,7), */ 3.333,
291 /* f29 DOUBLE, */ 3.333333333333333333333333333,
292 /* f30 ENUM ('a','b','c')*/ 'c',
293 /* f31 FLOAT, */ 3.0,
294 /* f32 NUMERIC(17,9), */ 3.3333,
295 /* f33 SET ('a','b','c'),*/ 'c',
296 /*f34 VARBINARY(1025),*/ '3333 minus 3',
297 /*f35 VARCHAR(257),*/ 'three times three'
298 ),
299 (1, 1, 6, 'sixth',
300 /* f5 BIGINT, */ NULL,
301 /* f6 BLOB, */ '3333333333333333333333',
302 /* f7 DATE, */ '2007-07-18',
303 /* f8 DATETIME, */ "2007-07-18",
304 /* f9 FLOAT, */ 3.33333333,
305 /* f10 INT, */ 333333333,
306 /* f11 LONGBLOB, */ '3333333333333333333',
307 /* f12 LONGTEXT, */ '3333333333333333333',
308 /* f13 MEDIUMBLOB, */ '3333333333333333333',
309 /* f14 MEDIUMINT, */ 33,
310 /* f15 MEDIUMTEXT, */ 3.3,
311 /* f16 REAL, */ 3.3,
312 /* f17 SMALLINT, */ 3,
313 /* f18 TEXT, */ '33',
314 /* f19 TIME, */ '2:59:58.999',
315 /* f20 TIMESTAMP, */ 20000303000000,
316 /* f21 TINYBLOB, */ '3333',
317 /* f22 TINYINT, */ 3,
318 /* f23 TINYTEXT, */ '3',
319 /* f24 YEAR, */ 3000,
320 /* f25 BINARY(255), */ 'three_33333',
321 /* f26 BIT(64), */ b'011',
322 /* f27 CHAR(255), */ 'three',
323 /* f28 DECIMAL(30,7), */ 3.333,
324 /* f29 DOUBLE, */ 3.333333333333333333333333333,
325 /* f30 ENUM ('a','b','c')*/ 'c',
326 /* f31 FLOAT, */ 3.0,
327 /* f32 NUMERIC(17,9), */ 3.3333,
328 /* f33 SET ('a','b','c'),*/ 'c',
329 /*f34 VARBINARY(1025),*/ '3333 minus 3',
330 /*f35 VARCHAR(257),*/ NULL
331 );
332 Warnings:
333 Warning 1264 Out of range value for column 'f5' at row 1
334 Warning 1264 Out of range value for column 'f24' at row 1
335 Warning 1264 Out of range value for column 'f5' at row 2
336 Warning 1264 Out of range value for column 'f24' at row 2
337 Warning 1264 Out of range value for column 'f24' at row 3
338
339 ** Sync slave with master **
340 ** Do selects from tables **
341
342 select * from t1 order by f3;
343 f1 f2 f3 f4
344 2 2 2 second
345 3 3 3 next
346 5 5 5 second
347 6 6 6 next
348 8 8 8 second
349 9 9 9 next
350 11 11 11 second
351 12 12 12 next
352 14 14 14 second
353 15 15 15 next
354 17 17 17 second
355 18 18 18 next
356 20 20 20 second
357 21 21 21 next
358 23 23 23 second
359 24 24 24 next
360 26 26 26 second
361 27 27 27 next
362 29 29 29 second
363 30 30 30 next
364 31 31 31 second
365 32 32 32 second
366 33 33 33 second
367 34 34 34 second
368 35 35 35 second
369 36 36 36 second
370 37 37 37 second
371 38 38 38 second
372 39 39 39 second
373 40 40 40 second
374 41 41 41 second
375 42 42 42 second
376 43 43 43 second
377 44 44 44 second
378 45 45 45 second
379 46 46 46 second
380 47 47 47 second
381 48 48 48 second
382 49 49 49 second
383 50 50 50 second
384 select * from t2 order by f1;
385 f1 f2 f3 f4
386 1 1 1 first
387 2 2 2 second
388 3 3 3 third
389 select * from t3 order by f1;
390 f1 f2 f3 f4
391 1 1 1 first
392 select * from t4 order by f1;
393 f1 f2 f3 f4
394 1 1 1 first
395 select * from t31 order by f3;
396 f1 f2 f3 f4
397 1 1 1 first
398 1 1 2 second
399 1 1 3 third
400 1 1 4 fourth
401 1 1 5 fifth
402 1 1 6 sixth
403
404 ** Do updates master **
405
406 update t31 set f5=555555555555555 where f3=6;
407 update t31 set f2=2 where f3=2;
408 update t31 set f1=NULL where f3=1;
409 update ignore t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3;
410 Warnings:
411 Warning 1048 Column 'f3' cannot be null
412
413 ** Delete from Master **
414
415 delete from t1;
416 delete from t2;
417 delete from t3;
418 delete from t4;
419 delete from t31;
420 select * from t31;
421 f1 f2 f3 f4
422
423 ** Check slave status **
424
425 include/check_slave_is_running.inc
426
427 ****************************************
428 * columns in master at middle of table *
429 * Expect: Proper error message *
430 ****************************************
431
432 ** Stop and Reset Slave **
433
434 STOP SLAVE;
435 Warnings:
436 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
437
438 ** create table slave side **
439 CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
440 ) ENGINE='NDB';
441
442 ** Connect to master and create table **
443
444 CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
445 c CHAR(5), e INT DEFAULT '1')ENGINE='NDB';
446
447 *** Start Slave ***
448 include/rpl_reset.inc
449
450 *** Master Data Insert ***
451 set @b1 = 'b1b1b1b1';
452 set @b1 = concat(@b1,@b1);
453 INSERT INTO t10 () VALUES(1,@b1,DEFAULT,'Kyle',DEFAULT),
454 (2,@b1,DEFAULT,'JOE',DEFAULT),
455 (3,@b1,DEFAULT,'QA',DEFAULT);
456
457 ********************************************
458 *** Expect slave to fail with Error 1677 ***
459 ********************************************
460
461 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
462
463 *** Drop t10 ***
464 DROP TABLE t10;
465
466 *********************************************
467 * More columns in master at middle of table *
468 * Expect: Proper error message *
469 *********************************************
470
471 *** Create t11 on slave ***
472 STOP SLAVE;
473 Warnings:
474 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
475 CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
476 ) ENGINE='NDB';
477
478 *** Create t11 on Master ***
479 CREATE TABLE t11 (a INT KEY, b BLOB, f TEXT,
480 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='NDB';
481
482 *** Start Slave ***
483 include/rpl_reset.inc
484
485 *** Master Data Insert ***
486 set @b1 = 'b1b1b1b1';
487 set @b1 = concat(@b1,@b1);
488 INSERT INTO t11 () VALUES(1,@b1,'Testing is fun','Kyle',DEFAULT),
489 (2,@b1,'Testing is cool','JOE',DEFAULT),
490 (3,@b1,DEFAULT,'QA',DEFAULT);
491
492 ********************************************
493 *** Expect slave to fail with Error 1677 ***
494 ********************************************
495
496 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
497
498 *** Drop t11 ***
499 DROP TABLE t11;
500
501 *********************************************
502 * More columns in master at middle of table *
503 * Expect: This one should pass blob-text *
504 *********************************************
505
506 *** Create t12 on slave ***
507 STOP SLAVE;
508 Warnings:
509 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
510 CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
511 ) ENGINE='NDB';
512
513 *** Create t12 on Master ***
514 CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
515 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='NDB';
516
517 *** Start Slave ***
518 include/rpl_reset.inc
519
520 *** Master Data Insert ***
521 set @b1 = 'b1b1b1b1';
522 set @b1 = concat(@b1,@b1);
523 INSERT INTO t12 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
524 (2,@b1,'JOE',DEFAULT,DEFAULT),
525 (3,@b1,'QA',DEFAULT,DEFAULT);
526
527 SELECT a,hex(b),f,c,e FROM t12 ORDER BY a;
528 a hex(b) f c e
529 1 62316231623162316231623162316231 Kyle test 1
530 2 62316231623162316231623162316231 JOE test 1
531 3 62316231623162316231623162316231 QA test 1
532
533 *** Select on Slave ***
534 SELECT a,hex(b),c FROM t12 ORDER BY a;
535 a hex(b) c
536 1 62316231623162316231623162316231 Kyle
537 2 62316231623162316231623162316231 JOE
538 3 62316231623162316231623162316231 QA
539
540 *** Drop t12 ***
541 DROP TABLE t12;
542
543 ****************************************************
544 * - Alter Master adding columns at middle of table *
545 * Expect: columns added *
546 ****************************************************
547
548
549 *** Create t14 on slave ***
550 STOP SLAVE;
551 Warnings:
552 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
553 CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
554 ) ENGINE='NDB';
555
556 *** Create t14 on Master ***
557 CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
558 c6 INT DEFAULT '1',
559 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
560 )ENGINE='NDB';
561
562 *** Start Slave ***
563 include/rpl_reset.inc
564
565 *** Master Data Insert ***
566 ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
567 ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
568
569 set @b1 = 'b1b1b1b1';
570 set @b1 = concat(@b1,@b1);
571 INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle',DEFAULT,DEFAULT),
572 (2,2.00,'This Test Should work',@b1,'JOE',DEFAULT,DEFAULT),
573 (3,3.00,'If is does not, I will open a bug',@b1,'QA',DEFAULT,DEFAULT);
574
575 SELECT c1,c2,c3,hex(c4),c5,c6,c7 FROM t14 ORDER BY c1;
576 c1 c2 c3 hex(c4) c5 c6 c7
577 1 1.00 Replication Testing Extra Col 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
578 2 2.00 This Test Should work 62316231623162316231623162316231 JOE 1 CURRENT_TIMESTAMP
579 3 3.00 If is does not, I will open a bug 62316231623162316231623162316231 QA 1 CURRENT_TIMESTAMP
580
581 *** Select on Slave ****
582 SELECT c1,c2,c3,hex(c4),c5 FROM t14 ORDER BY c1;
583 c1 c2 c3 hex(c4) c5
584 1 1.00 Replication Testing Extra Col 62316231623162316231623162316231 Kyle
585 2 2.00 This Test Should work 62316231623162316231623162316231 JOE
586 3 3.00 If is does not, I will open a bug 62316231623162316231623162316231 QA
587
588 ****************************************************
589 * - Alter Master Dropping columns from the middle. *
590 * Expect: columns dropped *
591 ****************************************************
592
593 *** connect to master and drop columns ***
594 ALTER TABLE t14 DROP COLUMN c2;
595 ALTER TABLE t14 DROP COLUMN c7;
596
597 *** Select from Master ***
598 SELECT c1,c3,hex(c4),c5,c6 FROM t14 ORDER BY c1;
599 c1 c3 hex(c4) c5 c6
600 1 Replication Testing Extra Col 62316231623162316231623162316231 Kyle 1
601 2 This Test Should work 62316231623162316231623162316231 JOE 1
602 3 If is does not, I will open a bug 62316231623162316231623162316231 QA 1
603
604 ************
605 * Bug30415 *
606 ************
607 include/wait_for_slave_sql_error.inc [errno=1091]
608 STOP SLAVE;
609 Warnings:
610 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
611
612 *** Drop t14 ***
613 DROP TABLE t14;
614 DROP TABLE t14;
615 RESET REPLICA;
616 include/rpl_reset.inc
617
618 *************************************************
619 * - Alter Master adding columns at end of table *
620 * Expect: Error 1054 *
621 *************************************************
622
623 *** Create t15 on slave ***
624 STOP SLAVE;
625 Warnings:
626 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
627 CREATE TABLE t15 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
628 ) ENGINE='NDB';
629
630 *** Create t15 on Master ***
631 CREATE TABLE t15 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
632 c6 INT DEFAULT '1',
633 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
634 )ENGINE='NDB';
635
636 *** Start Slave ***
637 include/rpl_reset.inc
638
639 *** Master Data Insert ***
640 ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7;
641 Warnings:
642 Warning 1478 Converted FIXED field 'c2' to DYNAMIC to enable online ADD COLUMN
643 set @b1 = 'b1b1b1b1';
644 set @b1 = concat(@b1,@b1);
645 INSERT INTO t15 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT,3.00),
646 (2,@b1,'JOE',DEFAULT,DEFAULT,3.00),
647 (3,@b1,'QA',DEFAULT,DEFAULT,3.00);
648 SELECT c1,hex(c4),c5,c6,c7,c2 FROM t15 ORDER BY c1;
649 c1 hex(c4) c5 c6 c7 c2
650 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP 3.00
651 2 62316231623162316231623162316231 JOE 1 CURRENT_TIMESTAMP 3.00
652 3 62316231623162316231623162316231 QA 1 CURRENT_TIMESTAMP 3.00
653
654 ********************************************
655 *** Expect slave to fail with Error 1054 ***
656 ********************************************
657
658 include/wait_for_slave_sql_error.inc [errno=1054]
659 STOP SLAVE;
660 Warnings:
661 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
662
663 *** Drop t15 ***
664 DROP TABLE t15;
665 DROP TABLE t15;
666 include/rpl_reset.inc
667
668 ************************************************
669 * - Create index on Master column not on slave *
670 * Expect:Warning *
671 ************************************************
672
673 *** Create t16 on slave ***
674 STOP SLAVE;
675 Warnings:
676 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
677 CREATE TABLE t16 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
678 ) ENGINE='NDB';
679
680 *** Create t16 on Master ***
681 CREATE TABLE t16 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
682 c6 INT DEFAULT '1',
683 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
684 )ENGINE='NDB';
685
686 *** Start Slave ***
687 include/rpl_reset.inc
688
689 *** Master Create Index and Data Insert ***
690 CREATE INDEX part_of_c6 ON t16 (c6);
691 set @b1 = 'b1b1b1b1';
692 set @b1 = concat(@b1,@b1);
693 INSERT INTO t16 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
694 (2,@b1,'JOE',2,DEFAULT),
695 (3,@b1,'QA',3,DEFAULT);
696 SELECT c1,hex(c4),c5,c6,c7 FROM t16 ORDER BY c1;
697 c1 hex(c4) c5 c6 c7
698 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
699 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
700 3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
701
702 *****************
703 *** BUG 30434 ***
704 *****************
705
706 include/wait_for_slave_sql_error.inc [errno=1072]
707 STOP SLAVE;
708 Warnings:
709 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
710
711 *** Drop t16 ***
712 DROP TABLE t16;
713 DROP TABLE t16;
714 include/rpl_reset.inc
715
716 *****************************************************
717 * - Delete rows using column on Master not on slave *
718 * Expect: Rows Deleted *
719 *****************************************************
720
721 *** Create t17 on slave ***
722 STOP SLAVE;
723 Warnings:
724 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
725 CREATE TABLE t17 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
726 ) ENGINE='NDB';
727
728 *** Create t17 on Master ***
729 CREATE TABLE t17 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
730 c6 INT DEFAULT '1',
731 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
732 )ENGINE='NDB';
733
734 *** Start Slave ***
735 include/rpl_reset.inc
736
737 *** Master Data Insert ***
738 set @b1 = 'b1b1b1b1';
739 set @b1 = concat(@b1,@b1);
740 INSERT INTO t17 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
741 (2,@b1,'JOE',2,DEFAULT),
742 (3,@b1,'QA',3,DEFAULT);
743 SELECT c1,hex(c4),c5,c6,c7 FROM t17 ORDER BY c1;
744 c1 hex(c4) c5 c6 c7
745 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
746 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
747 3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
748
749 ** Select * from Slave **
750 SELECT c1,hex(c4),c5 FROM t17 ORDER BY c1;
751 c1 hex(c4) c5
752 1 62316231623162316231623162316231 Kyle
753 2 62316231623162316231623162316231 JOE
754 3 62316231623162316231623162316231 QA
755
756 ** Delete from master **
757 DELETE FROM t17 WHERE c6 = 3;
758 SELECT c1,hex(c4),c5,c6,c7 FROM t17 ORDER BY c1;
759 c1 hex(c4) c5 c6 c7
760 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
761 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
762
763 ** Check slave **
764 SELECT c1,hex(c4),c5 FROM t17 ORDER BY c1;
765 c1 hex(c4) c5
766 1 62316231623162316231623162316231 Kyle
767 2 62316231623162316231623162316231 JOE
768 DROP TABLE t17;
769
770
771 *****************************************************
772 * - Update row using column on Master not on slave *
773 * Expect: Rows updated *
774 *****************************************************
775
776 ** Bug30674 **
777
778 *** Create t18 on slave ***
779
780 STOP SLAVE;
781 Warnings:
782 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
783 CREATE TABLE t18 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
784 ) ENGINE='NDB';
785
786 *** Create t18 on Master ***
787 CREATE TABLE t18 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
788 c6 INT DEFAULT '1',
789 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
790 )ENGINE='NDB';
791
792 *** Start Slave ***
793 include/rpl_reset.inc
794
795 *** Master Data Insert ***
796 set @b1 = 'b1b1b1b1';
797 set @b1 = concat(@b1,@b1);
798 INSERT INTO t18 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
799 (2,@b1,'JOE',2,DEFAULT),
800 (3,@b1,'QA',3,DEFAULT);
801 SELECT c1,hex(c4),c5,c6,c7 FROM t18 ORDER BY c1;
802 c1 hex(c4) c5 c6 c7
803 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
804 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
805 3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
806
807 ** Select * from Slave **
808 SELECT c1,hex(c4),c5 FROM t18 ORDER BY c1;
809 c1 hex(c4) c5
810 1 62316231623162316231623162316231 Kyle
811 2 62316231623162316231623162316231 JOE
812 3 62316231623162316231623162316231 QA
813
814 ** update from master **
815 UPDATE t18 SET c5 = 'TEST' WHERE c6 = 3;
816 SELECT c1,hex(c4),c5,c6,c7 FROM t18 ORDER BY c1;
817 c1 hex(c4) c5 c6 c7
818 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
819 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
820 3 62316231623162316231623162316231 TEST 3 CURRENT_TIMESTAMP
821
822 ** Check slave **
823 SELECT c1,hex(c4),c5 FROM t18 ORDER BY c1;
824 c1 hex(c4) c5
825 1 62316231623162316231623162316231 Kyle
826 2 62316231623162316231623162316231 JOE
827 3 62316231623162316231623162316231 TEST
828 DROP TABLE t18;
829
830
831 *****************************************************
832 * - Insert UUID column on Master not on slave *
833 * Expect: Rows inserted *
834 *****************************************************
835
836 *** Create t5 on slave ***
837 STOP SLAVE;
838 Warnings:
839 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
840 CREATE TABLE t5 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
841 ) ENGINE='NDB';
842
843 *** Create t5 on Master ***
844 CREATE TABLE t5 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
845 c6 LONG,
846 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
847 )ENGINE='NDB';
848
849 *** Start Slave ***
850 include/rpl_reset.inc
851
852 *** Master Data Insert ***
853 set @b1 = 'b1b1b1b1';
854 INSERT INTO t5 () VALUES(1,@b1,'Kyle',UUID(),DEFAULT),
855 (2,@b1,'JOE',UUID(),DEFAULT),
856 (3,@b1,'QA',UUID(),DEFAULT);
857 SELECT c1,hex(c4),c5,c6,c7 FROM t5 ORDER BY c1;
858 c1 hex(c4) c5 c6 c7
859 1 6231623162316231 Kyle UUID TIME
860 2 6231623162316231 JOE UUID TIME
861 3 6231623162316231 QA UUID TIME
862
863 ** Select * from Slave **
864 SELECT c1,hex(c4),c5 FROM t5 ORDER BY c1;
865 c1 hex(c4) c5
866 1 6231623162316231 Kyle
867 2 6231623162316231 JOE
868 3 6231623162316231 QA
869 DROP TABLE t5;
870
871 include/rpl_reset.inc
872 SET NAMES utf8;
873 Warnings:
874 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
875 SET SQL_LOG_BIN=0;
876 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(255) CHARACTER SET UTF8 NOT NULL) ENGINE='NDB';
877 Warnings:
878 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
879 SET SQL_LOG_BIN=1;
880 CREATE TABLE t1 (c1 INT) ENGINE='NDB';
881 INSERT IGNORE INTO t1 VALUES ();
882 SET @text= REPEAT(_utf8'ç', 255);
883 INSERT INTO t1 VALUES (1, @text);
884 SELECT * FROM t1 ORDER BY c1;
885 c1 c2
886 0
887 1 ççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççç
888 SELECT * FROM t1 ORDER BY c1;
889 c1
890 0
891 1
892 DROP TABLE t1;
893 set binlog_format='mixed';
894 Warnings:
895 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
896
897 ***********************************************************
898 ***********************************************************
899 ***************** Start of Testing ************************
900 ***********************************************************
901 ***********************************************************
902 * This test format == binlog_format MIXED and engine == 'NDB'
903 ***********************************************************
904 ***********************************************************
905
906 ***** Testing more columns on the Master *****
907
908 CREATE TABLE t1 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
909 /* extra */
910 f5 FLOAT DEFAULT '2.00',
911 f6 CHAR(4) DEFAULT 'TEST',
912 f7 INT DEFAULT '0',
913 f8 TEXT,
914 f9 LONGBLOB,
915 f10 BIT(63),
916 f11 VARBINARY(64))ENGINE='NDB';
917
918 * Alter Table on Slave and drop columns f5 through f11 *
919
920 alter table t1 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
921
922 * Insert data in Master then update and delete some rows*
923
924 * Select count and 20 rows from Master *
925
926 SELECT COUNT(*) FROM t1;
927 COUNT(*)
928 40
929
930 SELECT f1,f2,f3,f4,f5,f6,f7,f8,f9,
931 hex(f10),hex(f11) FROM t1 ORDER BY f3 LIMIT 20;
932 f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex(f11)
933 2 2 2 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
934 3 3 3 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
935 5 5 5 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
936 6 6 6 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
937 8 8 8 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
938 9 9 9 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
939 11 11 11 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
940 12 12 12 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
941 14 14 14 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
942 15 15 15 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
943 17 17 17 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
944 18 18 18 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
945 20 20 20 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
946 21 21 21 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
947 23 23 23 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
948 24 24 24 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
949 26 26 26 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
950 27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
951 29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
952 30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
953
954 * Select count and 20 rows from Slave *
955
956 SELECT COUNT(*) FROM t1;
957 COUNT(*)
958 40
959
960 SELECT * FROM t1 ORDER BY f3 LIMIT 20;
961 f1 f2 f3 f4
962 2 2 2 second
963 3 3 3 next
964 5 5 5 second
965 6 6 6 next
966 8 8 8 second
967 9 9 9 next
968 11 11 11 second
969 12 12 12 next
970 14 14 14 second
971 15 15 15 next
972 17 17 17 second
973 18 18 18 next
974 20 20 20 second
975 21 21 21 next
976 23 23 23 second
977 24 24 24 next
978 26 26 26 second
979 27 27 27 next
980 29 29 29 second
981 30 30 30 next
982 include/check_slave_is_running.inc
983
984 ***** Testing Altering table def scenario *****
985
986 CREATE TABLE t2 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
987 /* extra */
988 f5 DOUBLE DEFAULT '2.00',
989 f6 ENUM('a', 'b', 'c') default 'a',
990 f7 DECIMAL(17,9) default '1000.00',
991 f8 MEDIUMBLOB,
992 f9 NUMERIC(6,2) default '2000.00',
993 f10 VARCHAR(1024),
994 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
995 f12 SET('a', 'b', 'c') default 'b')
996 ENGINE='NDB';
997
998 CREATE TABLE t3 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
999 /* extra */
1000 f5 DOUBLE DEFAULT '2.00',
1001 f6 ENUM('a', 'b', 'c') default 'a',
1002 f8 MEDIUMBLOB,
1003 f10 VARCHAR(1024),
1004 f11 BINARY(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1005 f12 SET('a', 'b', 'c') default 'b')
1006 ENGINE='NDB';
1007
1008 CREATE TABLE t4 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
1009 /* extra */
1010 f5 DOUBLE DEFAULT '2.00',
1011 f6 DECIMAL(17,9) default '1000.00',
1012 f7 MEDIUMBLOB,
1013 f8 NUMERIC(6,2) default '2000.00',
1014 f9 VARCHAR(1024),
1015 f10 BINARY(20) not null default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1016 f11 CHAR(255))
1017 ENGINE='NDB';
1018
1019 CREATE TABLE t31 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
1020 /* extra */
1021 f5 BIGINT,
1022 f6 BLOB,
1023 f7 DATE,
1024 f8 DATETIME,
1025 f9 FLOAT,
1026 f10 INT,
1027 f11 LONGBLOB,
1028 f12 LONGTEXT,
1029 f13 MEDIUMBLOB,
1030 f14 MEDIUMINT,
1031 f15 MEDIUMTEXT,
1032 f16 REAL,
1033 f17 SMALLINT,
1034 f18 TEXT,
1035 f19 TIME,
1036 f20 TIMESTAMP,
1037 f21 TINYBLOB,
1038 f22 TINYINT,
1039 f23 TINYTEXT,
1040 f24 YEAR,
1041 f25 BINARY(255),
1042 f26 BIT(64),
1043 f27 CHAR(255),
1044 f28 DECIMAL(30,7),
1045 f29 DOUBLE,
1046 f30 ENUM ('a','b', 'c') default 'a',
1047 f31 FLOAT,
1048 f32 NUMERIC(17,9),
1049 f33 SET ('a', 'b', 'c') default 'b',
1050 f34 VARBINARY(1025),
1051 f35 VARCHAR(257)
1052 ) ENGINE='NDB';
1053
1054 ** Alter tables on slave and drop columns **
1055
1056 alter table t2 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11, drop
1057 f12;
1058 alter table t3 drop f5, drop f6, drop f8, drop f10, drop f11, drop f12;
1059 alter table t4 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
1060 alter table t31
1061 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11,
1062 drop f12, drop f13, drop f14, drop f15, drop f16, drop f17, drop f18,
1063 drop f19, drop f20, drop f21, drop f22, drop f23, drop f24, drop f25,
1064 drop f26, drop f27, drop f28, drop f29, drop f30, drop f31, drop f32,
1065 drop f33, drop f34, drop f35;
1066
1067 ** Insert Data into Master **
1068 INSERT into t2 set f1=1, f2=1, f3=1, f4='first', f8='f8: medium size blob', f10='f10:
1069 some var char';
1070 INSERT into t2 values (2, 2, 2, 'second',
1071 2.0, 'b', 2000.0002, 'f8: medium size blob', 2000, 'f10: some var char',
1072 '01234567', 'c'),
1073 (3, 3, 3, 'third',
1074 3.0, 'b', 3000.0003, 'f8: medium size blob', 3000, 'f10: some var char',
1075 '01234567', 'c');
1076 INSERT into t3 set f1=1, f2=1, f3=1, f4='first', f10='f10: some var char';
1077 INSERT into t4 set f1=1, f2=1, f3=1, f4='first', f7='f7: medium size blob', f10='f10:
1078 binary data';
1079 INSERT into t31 set f1=1, f2=1, f3=1, f4='first';
1080 INSERT IGNORE into t31 set f1=1, f2=1, f3=2, f4='second',
1081 f9=2.2, f10='seven samurai', f28=222.222, f35='222';
1082 Warnings:
1083 Warning 1366 Incorrect integer value: 'seven samurai' for column 'f10' at row 1
1084 INSERT IGNORE into t31 values (1, 1, 3, 'third',
1085 /* f5 BIGINT, */ 333333333333333333333333,
1086 /* f6 BLOB, */ '3333333333333333333333',
1087 /* f7 DATE, */ '2007-07-18',
1088 /* f8 DATETIME, */ "2007-07-18",
1089 /* f9 FLOAT, */ 3.33333333,
1090 /* f10 INT, */ 333333333,
1091 /* f11 LONGBLOB, */ '3333333333333333333',
1092 /* f12 LONGTEXT, */ '3333333333333333333',
1093 /* f13 MEDIUMBLOB, */ '3333333333333333333',
1094 /* f14 MEDIUMINT, */ 33,
1095 /* f15 MEDIUMTEXT, */ 3.3,
1096 /* f16 REAL, */ 3.3,
1097 /* f17 SMALLINT, */ 3,
1098 /* f18 TEXT, */ '33',
1099 /* f19 TIME, */ '2:59:58.999',
1100 /* f20 TIMESTAMP, */ 20000303000000,
1101 /* f21 TINYBLOB, */ '3333',
1102 /* f22 TINYINT, */ 3,
1103 /* f23 TINYTEXT, */ '3',
1104 /* f24 YEAR, */ 3000,
1105 /* f25 BINARY(255), */ 'three_33333',
1106 /* f26 BIT(64), */ b'011',
1107 /* f27 CHAR(255), */ 'three',
1108 /* f28 DECIMAL(30,7), */ 3.333,
1109 /* f29 DOUBLE, */ 3.333333333333333333333333333,
1110 /* f30 ENUM ('a','b','c')*/ 'c',
1111 /* f31 FLOAT, */ 3.0,
1112 /* f32 NUMERIC(17,9), */ 3.3333,
1113 /* f33 SET ('a','b','c'),*/ 'c',
1114 /*f34 VARBINARY(1025),*/ '3333 minus 3',
1115 /*f35 VARCHAR(257),*/ 'three times three'
1116 );
1117 Warnings:
1118 Warning 1264 Out of range value for column 'f5' at row 1
1119 Warning 1264 Out of range value for column 'f24' at row 1
1120 INSERT IGNORE into t31 values (1, 1, 4, 'fourth',
1121 /* f5 BIGINT, */ 333333333333333333333333,
1122 /* f6 BLOB, */ '3333333333333333333333',
1123 /* f7 DATE, */ '2007-07-18',
1124 /* f8 DATETIME, */ "2007-07-18",
1125 /* f9 FLOAT, */ 3.33333333,
1126 /* f10 INT, */ 333333333,
1127 /* f11 LONGBLOB, */ '3333333333333333333',
1128 /* f12 LONGTEXT, */ '3333333333333333333',
1129 /* f13 MEDIUMBLOB, */ '3333333333333333333',
1130 /* f14 MEDIUMINT, */ 33,
1131 /* f15 MEDIUMTEXT, */ 3.3,
1132 /* f16 REAL, */ 3.3,
1133 /* f17 SMALLINT, */ 3,
1134 /* f18 TEXT, */ '33',
1135 /* f19 TIME, */ '2:59:58.999',
1136 /* f20 TIMESTAMP, */ 20000303000000,
1137 /* f21 TINYBLOB, */ '3333',
1138 /* f22 TINYINT, */ 3,
1139 /* f23 TINYTEXT, */ '3',
1140 /* f24 YEAR, */ 3000,
1141 /* f25 BINARY(255), */ 'three_33333',
1142 /* f26 BIT(64), */ b'011',
1143 /* f27 CHAR(255), */ 'three',
1144 /* f28 DECIMAL(30,7), */ 3.333,
1145 /* f29 DOUBLE, */ 3.333333333333333333333333333,
1146 /* f30 ENUM ('a','b','c')*/ 'c',
1147 /* f31 FLOAT, */ 3.0,
1148 /* f32 NUMERIC(17,9), */ 3.3333,
1149 /* f33 SET ('a','b','c'),*/ 'c',
1150 /*f34 VARBINARY(1025),*/ '3333 minus 3',
1151 /*f35 VARCHAR(257),*/ 'three times three'
1152 ),
1153 (1, 1, 5, 'fifth',
1154 /* f5 BIGINT, */ 333333333333333333333333,
1155 /* f6 BLOB, */ '3333333333333333333333',
1156 /* f7 DATE, */ '2007-07-18',
1157 /* f8 DATETIME, */ "2007-07-18",
1158 /* f9 FLOAT, */ 3.33333333,
1159 /* f10 INT, */ 333333333,
1160 /* f11 LONGBLOB, */ '3333333333333333333',
1161 /* f12 LONGTEXT, */ '3333333333333333333',
1162 /* f13 MEDIUMBLOB, */ '3333333333333333333',
1163 /* f14 MEDIUMINT, */ 33,
1164 /* f15 MEDIUMTEXT, */ 3.3,
1165 /* f16 REAL, */ 3.3,
1166 /* f17 SMALLINT, */ 3,
1167 /* f18 TEXT, */ '33',
1168 /* f19 TIME, */ '2:59:58.999',
1169 /* f20 TIMESTAMP, */ 20000303000000,
1170 /* f21 TINYBLOB, */ '3333',
1171 /* f22 TINYINT, */ 3,
1172 /* f23 TINYTEXT, */ '3',
1173 /* f24 YEAR, */ 3000,
1174 /* f25 BINARY(255), */ 'three_33333',
1175 /* f26 BIT(64), */ b'011',
1176 /* f27 CHAR(255), */ 'three',
1177 /* f28 DECIMAL(30,7), */ 3.333,
1178 /* f29 DOUBLE, */ 3.333333333333333333333333333,
1179 /* f30 ENUM ('a','b','c')*/ 'c',
1180 /* f31 FLOAT, */ 3.0,
1181 /* f32 NUMERIC(17,9), */ 3.3333,
1182 /* f33 SET ('a','b','c'),*/ 'c',
1183 /*f34 VARBINARY(1025),*/ '3333 minus 3',
1184 /*f35 VARCHAR(257),*/ 'three times three'
1185 ),
1186 (1, 1, 6, 'sixth',
1187 /* f5 BIGINT, */ NULL,
1188 /* f6 BLOB, */ '3333333333333333333333',
1189 /* f7 DATE, */ '2007-07-18',
1190 /* f8 DATETIME, */ "2007-07-18",
1191 /* f9 FLOAT, */ 3.33333333,
1192 /* f10 INT, */ 333333333,
1193 /* f11 LONGBLOB, */ '3333333333333333333',
1194 /* f12 LONGTEXT, */ '3333333333333333333',
1195 /* f13 MEDIUMBLOB, */ '3333333333333333333',
1196 /* f14 MEDIUMINT, */ 33,
1197 /* f15 MEDIUMTEXT, */ 3.3,
1198 /* f16 REAL, */ 3.3,
1199 /* f17 SMALLINT, */ 3,
1200 /* f18 TEXT, */ '33',
1201 /* f19 TIME, */ '2:59:58.999',
1202 /* f20 TIMESTAMP, */ 20000303000000,
1203 /* f21 TINYBLOB, */ '3333',
1204 /* f22 TINYINT, */ 3,
1205 /* f23 TINYTEXT, */ '3',
1206 /* f24 YEAR, */ 3000,
1207 /* f25 BINARY(255), */ 'three_33333',
1208 /* f26 BIT(64), */ b'011',
1209 /* f27 CHAR(255), */ 'three',
1210 /* f28 DECIMAL(30,7), */ 3.333,
1211 /* f29 DOUBLE, */ 3.333333333333333333333333333,
1212 /* f30 ENUM ('a','b','c')*/ 'c',
1213 /* f31 FLOAT, */ 3.0,
1214 /* f32 NUMERIC(17,9), */ 3.3333,
1215 /* f33 SET ('a','b','c'),*/ 'c',
1216 /*f34 VARBINARY(1025),*/ '3333 minus 3',
1217 /*f35 VARCHAR(257),*/ NULL
1218 );
1219 Warnings:
1220 Warning 1264 Out of range value for column 'f5' at row 1
1221 Warning 1264 Out of range value for column 'f24' at row 1
1222 Warning 1264 Out of range value for column 'f5' at row 2
1223 Warning 1264 Out of range value for column 'f24' at row 2
1224 Warning 1264 Out of range value for column 'f24' at row 3
1225
1226 ** Sync slave with master **
1227 ** Do selects from tables **
1228
1229 select * from t1 order by f3;
1230 f1 f2 f3 f4
1231 2 2 2 second
1232 3 3 3 next
1233 5 5 5 second
1234 6 6 6 next
1235 8 8 8 second
1236 9 9 9 next
1237 11 11 11 second
1238 12 12 12 next
1239 14 14 14 second
1240 15 15 15 next
1241 17 17 17 second
1242 18 18 18 next
1243 20 20 20 second
1244 21 21 21 next
1245 23 23 23 second
1246 24 24 24 next
1247 26 26 26 second
1248 27 27 27 next
1249 29 29 29 second
1250 30 30 30 next
1251 31 31 31 second
1252 32 32 32 second
1253 33 33 33 second
1254 34 34 34 second
1255 35 35 35 second
1256 36 36 36 second
1257 37 37 37 second
1258 38 38 38 second
1259 39 39 39 second
1260 40 40 40 second
1261 41 41 41 second
1262 42 42 42 second
1263 43 43 43 second
1264 44 44 44 second
1265 45 45 45 second
1266 46 46 46 second
1267 47 47 47 second
1268 48 48 48 second
1269 49 49 49 second
1270 50 50 50 second
1271 select * from t2 order by f1;
1272 f1 f2 f3 f4
1273 1 1 1 first
1274 2 2 2 second
1275 3 3 3 third
1276 select * from t3 order by f1;
1277 f1 f2 f3 f4
1278 1 1 1 first
1279 select * from t4 order by f1;
1280 f1 f2 f3 f4
1281 1 1 1 first
1282 select * from t31 order by f3;
1283 f1 f2 f3 f4
1284 1 1 1 first
1285 1 1 2 second
1286 1 1 3 third
1287 1 1 4 fourth
1288 1 1 5 fifth
1289 1 1 6 sixth
1290
1291 ** Do updates master **
1292
1293 update t31 set f5=555555555555555 where f3=6;
1294 update t31 set f2=2 where f3=2;
1295 update t31 set f1=NULL where f3=1;
1296 update ignore t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3;
1297 Warnings:
1298 Warning 1048 Column 'f3' cannot be null
1299
1300 ** Delete from Master **
1301
1302 delete from t1;
1303 delete from t2;
1304 delete from t3;
1305 delete from t4;
1306 delete from t31;
1307 select * from t31;
1308 f1 f2 f3 f4
1309
1310 ** Check slave status **
1311
1312 include/check_slave_is_running.inc
1313
1314 ****************************************
1315 * columns in master at middle of table *
1316 * Expect: Proper error message *
1317 ****************************************
1318
1319 ** Stop and Reset Slave **
1320
1321 STOP SLAVE;
1322 Warnings:
1323 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1324
1325 ** create table slave side **
1326 CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
1327 ) ENGINE='NDB';
1328
1329 ** Connect to master and create table **
1330
1331 CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
1332 c CHAR(5), e INT DEFAULT '1')ENGINE='NDB';
1333
1334 *** Start Slave ***
1335 include/rpl_reset.inc
1336
1337 *** Master Data Insert ***
1338 set @b1 = 'b1b1b1b1';
1339 set @b1 = concat(@b1,@b1);
1340 INSERT INTO t10 () VALUES(1,@b1,DEFAULT,'Kyle',DEFAULT),
1341 (2,@b1,DEFAULT,'JOE',DEFAULT),
1342 (3,@b1,DEFAULT,'QA',DEFAULT);
1343
1344 ********************************************
1345 *** Expect slave to fail with Error 1677 ***
1346 ********************************************
1347
1348 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
1349
1350 *** Drop t10 ***
1351 DROP TABLE t10;
1352
1353 *********************************************
1354 * More columns in master at middle of table *
1355 * Expect: Proper error message *
1356 *********************************************
1357
1358 *** Create t11 on slave ***
1359 STOP SLAVE;
1360 Warnings:
1361 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1362 CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
1363 ) ENGINE='NDB';
1364
1365 *** Create t11 on Master ***
1366 CREATE TABLE t11 (a INT KEY, b BLOB, f TEXT,
1367 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='NDB';
1368
1369 *** Start Slave ***
1370 include/rpl_reset.inc
1371
1372 *** Master Data Insert ***
1373 set @b1 = 'b1b1b1b1';
1374 set @b1 = concat(@b1,@b1);
1375 INSERT INTO t11 () VALUES(1,@b1,'Testing is fun','Kyle',DEFAULT),
1376 (2,@b1,'Testing is cool','JOE',DEFAULT),
1377 (3,@b1,DEFAULT,'QA',DEFAULT);
1378
1379 ********************************************
1380 *** Expect slave to fail with Error 1677 ***
1381 ********************************************
1382
1383 include/wait_for_slave_sql_error_and_skip.inc [errno=13146]
1384
1385 *** Drop t11 ***
1386 DROP TABLE t11;
1387
1388 *********************************************
1389 * More columns in master at middle of table *
1390 * Expect: This one should pass blob-text *
1391 *********************************************
1392
1393 *** Create t12 on slave ***
1394 STOP SLAVE;
1395 Warnings:
1396 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1397 CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
1398 ) ENGINE='NDB';
1399
1400 *** Create t12 on Master ***
1401 CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
1402 c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='NDB';
1403
1404 *** Start Slave ***
1405 include/rpl_reset.inc
1406
1407 *** Master Data Insert ***
1408 set @b1 = 'b1b1b1b1';
1409 set @b1 = concat(@b1,@b1);
1410 INSERT INTO t12 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
1411 (2,@b1,'JOE',DEFAULT,DEFAULT),
1412 (3,@b1,'QA',DEFAULT,DEFAULT);
1413
1414 SELECT a,hex(b),f,c,e FROM t12 ORDER BY a;
1415 a hex(b) f c e
1416 1 62316231623162316231623162316231 Kyle test 1
1417 2 62316231623162316231623162316231 JOE test 1
1418 3 62316231623162316231623162316231 QA test 1
1419
1420 *** Select on Slave ***
1421 SELECT a,hex(b),c FROM t12 ORDER BY a;
1422 a hex(b) c
1423 1 62316231623162316231623162316231 Kyle
1424 2 62316231623162316231623162316231 JOE
1425 3 62316231623162316231623162316231 QA
1426
1427 *** Drop t12 ***
1428 DROP TABLE t12;
1429
1430 ****************************************************
1431 * - Alter Master adding columns at middle of table *
1432 * Expect: columns added *
1433 ****************************************************
1434
1435
1436 *** Create t14 on slave ***
1437 STOP SLAVE;
1438 Warnings:
1439 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1440 CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
1441 ) ENGINE='NDB';
1442
1443 *** Create t14 on Master ***
1444 CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
1445 c6 INT DEFAULT '1',
1446 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
1447 )ENGINE='NDB';
1448
1449 *** Start Slave ***
1450 include/rpl_reset.inc
1451
1452 *** Master Data Insert ***
1453 ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
1454 ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
1455
1456 set @b1 = 'b1b1b1b1';
1457 set @b1 = concat(@b1,@b1);
1458 INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle',DEFAULT,DEFAULT),
1459 (2,2.00,'This Test Should work',@b1,'JOE',DEFAULT,DEFAULT),
1460 (3,3.00,'If is does not, I will open a bug',@b1,'QA',DEFAULT,DEFAULT);
1461
1462 SELECT c1,c2,c3,hex(c4),c5,c6,c7 FROM t14 ORDER BY c1;
1463 c1 c2 c3 hex(c4) c5 c6 c7
1464 1 1.00 Replication Testing Extra Col 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
1465 2 2.00 This Test Should work 62316231623162316231623162316231 JOE 1 CURRENT_TIMESTAMP
1466 3 3.00 If is does not, I will open a bug 62316231623162316231623162316231 QA 1 CURRENT_TIMESTAMP
1467
1468 *** Select on Slave ****
1469 SELECT c1,c2,c3,hex(c4),c5 FROM t14 ORDER BY c1;
1470 c1 c2 c3 hex(c4) c5
1471 1 1.00 Replication Testing Extra Col 62316231623162316231623162316231 Kyle
1472 2 2.00 This Test Should work 62316231623162316231623162316231 JOE
1473 3 3.00 If is does not, I will open a bug 62316231623162316231623162316231 QA
1474
1475 ****************************************************
1476 * - Alter Master Dropping columns from the middle. *
1477 * Expect: columns dropped *
1478 ****************************************************
1479
1480 *** connect to master and drop columns ***
1481 ALTER TABLE t14 DROP COLUMN c2;
1482 ALTER TABLE t14 DROP COLUMN c7;
1483
1484 *** Select from Master ***
1485 SELECT c1,c3,hex(c4),c5,c6 FROM t14 ORDER BY c1;
1486 c1 c3 hex(c4) c5 c6
1487 1 Replication Testing Extra Col 62316231623162316231623162316231 Kyle 1
1488 2 This Test Should work 62316231623162316231623162316231 JOE 1
1489 3 If is does not, I will open a bug 62316231623162316231623162316231 QA 1
1490
1491 ************
1492 * Bug30415 *
1493 ************
1494 include/wait_for_slave_sql_error.inc [errno=1091]
1495 STOP SLAVE;
1496 Warnings:
1497 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1498
1499 *** Drop t14 ***
1500 DROP TABLE t14;
1501 DROP TABLE t14;
1502 RESET REPLICA;
1503 include/rpl_reset.inc
1504
1505 *************************************************
1506 * - Alter Master adding columns at end of table *
1507 * Expect: Error 1054 *
1508 *************************************************
1509
1510 *** Create t15 on slave ***
1511 STOP SLAVE;
1512 Warnings:
1513 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1514 CREATE TABLE t15 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
1515 ) ENGINE='NDB';
1516
1517 *** Create t15 on Master ***
1518 CREATE TABLE t15 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
1519 c6 INT DEFAULT '1',
1520 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
1521 )ENGINE='NDB';
1522
1523 *** Start Slave ***
1524 include/rpl_reset.inc
1525
1526 *** Master Data Insert ***
1527 ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7;
1528 Warnings:
1529 Warning 1478 Converted FIXED field 'c2' to DYNAMIC to enable online ADD COLUMN
1530 set @b1 = 'b1b1b1b1';
1531 set @b1 = concat(@b1,@b1);
1532 INSERT INTO t15 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT,3.00),
1533 (2,@b1,'JOE',DEFAULT,DEFAULT,3.00),
1534 (3,@b1,'QA',DEFAULT,DEFAULT,3.00);
1535 SELECT c1,hex(c4),c5,c6,c7,c2 FROM t15 ORDER BY c1;
1536 c1 hex(c4) c5 c6 c7 c2
1537 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP 3.00
1538 2 62316231623162316231623162316231 JOE 1 CURRENT_TIMESTAMP 3.00
1539 3 62316231623162316231623162316231 QA 1 CURRENT_TIMESTAMP 3.00
1540
1541 ********************************************
1542 *** Expect slave to fail with Error 1054 ***
1543 ********************************************
1544
1545 include/wait_for_slave_sql_error.inc [errno=1054]
1546 STOP SLAVE;
1547 Warnings:
1548 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1549
1550 *** Drop t15 ***
1551 DROP TABLE t15;
1552 DROP TABLE t15;
1553 include/rpl_reset.inc
1554
1555 ************************************************
1556 * - Create index on Master column not on slave *
1557 * Expect:Warning *
1558 ************************************************
1559
1560 *** Create t16 on slave ***
1561 STOP SLAVE;
1562 Warnings:
1563 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1564 CREATE TABLE t16 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
1565 ) ENGINE='NDB';
1566
1567 *** Create t16 on Master ***
1568 CREATE TABLE t16 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
1569 c6 INT DEFAULT '1',
1570 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
1571 )ENGINE='NDB';
1572
1573 *** Start Slave ***
1574 include/rpl_reset.inc
1575
1576 *** Master Create Index and Data Insert ***
1577 CREATE INDEX part_of_c6 ON t16 (c6);
1578 set @b1 = 'b1b1b1b1';
1579 set @b1 = concat(@b1,@b1);
1580 INSERT INTO t16 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
1581 (2,@b1,'JOE',2,DEFAULT),
1582 (3,@b1,'QA',3,DEFAULT);
1583 SELECT c1,hex(c4),c5,c6,c7 FROM t16 ORDER BY c1;
1584 c1 hex(c4) c5 c6 c7
1585 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
1586 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
1587 3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
1588
1589 *****************
1590 *** BUG 30434 ***
1591 *****************
1592
1593 include/wait_for_slave_sql_error.inc [errno=1072]
1594 STOP SLAVE;
1595 Warnings:
1596 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1597
1598 *** Drop t16 ***
1599 DROP TABLE t16;
1600 DROP TABLE t16;
1601 include/rpl_reset.inc
1602
1603 *****************************************************
1604 * - Delete rows using column on Master not on slave *
1605 * Expect: Rows Deleted *
1606 *****************************************************
1607
1608 *** Create t17 on slave ***
1609 STOP SLAVE;
1610 Warnings:
1611 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1612 CREATE TABLE t17 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
1613 ) ENGINE='NDB';
1614
1615 *** Create t17 on Master ***
1616 CREATE TABLE t17 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
1617 c6 INT DEFAULT '1',
1618 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
1619 )ENGINE='NDB';
1620
1621 *** Start Slave ***
1622 include/rpl_reset.inc
1623
1624 *** Master Data Insert ***
1625 set @b1 = 'b1b1b1b1';
1626 set @b1 = concat(@b1,@b1);
1627 INSERT INTO t17 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
1628 (2,@b1,'JOE',2,DEFAULT),
1629 (3,@b1,'QA',3,DEFAULT);
1630 SELECT c1,hex(c4),c5,c6,c7 FROM t17 ORDER BY c1;
1631 c1 hex(c4) c5 c6 c7
1632 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
1633 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
1634 3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
1635
1636 ** Select * from Slave **
1637 SELECT c1,hex(c4),c5 FROM t17 ORDER BY c1;
1638 c1 hex(c4) c5
1639 1 62316231623162316231623162316231 Kyle
1640 2 62316231623162316231623162316231 JOE
1641 3 62316231623162316231623162316231 QA
1642
1643 ** Delete from master **
1644 DELETE FROM t17 WHERE c6 = 3;
1645 SELECT c1,hex(c4),c5,c6,c7 FROM t17 ORDER BY c1;
1646 c1 hex(c4) c5 c6 c7
1647 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
1648 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
1649
1650 ** Check slave **
1651 SELECT c1,hex(c4),c5 FROM t17 ORDER BY c1;
1652 c1 hex(c4) c5
1653 1 62316231623162316231623162316231 Kyle
1654 2 62316231623162316231623162316231 JOE
1655 DROP TABLE t17;
1656
1657
1658 *****************************************************
1659 * - Update row using column on Master not on slave *
1660 * Expect: Rows updated *
1661 *****************************************************
1662
1663 ** Bug30674 **
1664
1665 *** Create t18 on slave ***
1666
1667 STOP SLAVE;
1668 Warnings:
1669 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1670 CREATE TABLE t18 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
1671 ) ENGINE='NDB';
1672
1673 *** Create t18 on Master ***
1674 CREATE TABLE t18 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
1675 c6 INT DEFAULT '1',
1676 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
1677 )ENGINE='NDB';
1678
1679 *** Start Slave ***
1680 include/rpl_reset.inc
1681
1682 *** Master Data Insert ***
1683 set @b1 = 'b1b1b1b1';
1684 set @b1 = concat(@b1,@b1);
1685 INSERT INTO t18 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
1686 (2,@b1,'JOE',2,DEFAULT),
1687 (3,@b1,'QA',3,DEFAULT);
1688 SELECT c1,hex(c4),c5,c6,c7 FROM t18 ORDER BY c1;
1689 c1 hex(c4) c5 c6 c7
1690 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
1691 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
1692 3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
1693
1694 ** Select * from Slave **
1695 SELECT c1,hex(c4),c5 FROM t18 ORDER BY c1;
1696 c1 hex(c4) c5
1697 1 62316231623162316231623162316231 Kyle
1698 2 62316231623162316231623162316231 JOE
1699 3 62316231623162316231623162316231 QA
1700
1701 ** update from master **
1702 UPDATE t18 SET c5 = 'TEST' WHERE c6 = 3;
1703 SELECT c1,hex(c4),c5,c6,c7 FROM t18 ORDER BY c1;
1704 c1 hex(c4) c5 c6 c7
1705 1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
1706 2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
1707 3 62316231623162316231623162316231 TEST 3 CURRENT_TIMESTAMP
1708
1709 ** Check slave **
1710 SELECT c1,hex(c4),c5 FROM t18 ORDER BY c1;
1711 c1 hex(c4) c5
1712 1 62316231623162316231623162316231 Kyle
1713 2 62316231623162316231623162316231 JOE
1714 3 62316231623162316231623162316231 TEST
1715 DROP TABLE t18;
1716
1717
1718 *****************************************************
1719 * - Insert UUID column on Master not on slave *
1720 * Expect: Rows inserted *
1721 *****************************************************
1722
1723 *** Create t5 on slave ***
1724 STOP SLAVE;
1725 Warnings:
1726 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
1727 CREATE TABLE t5 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
1728 ) ENGINE='NDB';
1729
1730 *** Create t5 on Master ***
1731 CREATE TABLE t5 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
1732 c6 LONG,
1733 c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
1734 )ENGINE='NDB';
1735
1736 *** Start Slave ***
1737 include/rpl_reset.inc
1738
1739 *** Master Data Insert ***
1740 set @b1 = 'b1b1b1b1';
1741 INSERT INTO t5 () VALUES(1,@b1,'Kyle',UUID(),DEFAULT),
1742 (2,@b1,'JOE',UUID(),DEFAULT),
1743 (3,@b1,'QA',UUID(),DEFAULT);
1744 SELECT c1,hex(c4),c5,c6,c7 FROM t5 ORDER BY c1;
1745 c1 hex(c4) c5 c6 c7
1746 1 6231623162316231 Kyle UUID TIME
1747 2 6231623162316231 JOE UUID TIME
1748 3 6231623162316231 QA UUID TIME
1749
1750 ** Select * from Slave **
1751 SELECT c1,hex(c4),c5 FROM t5 ORDER BY c1;
1752 c1 hex(c4) c5
1753 1 6231623162316231 Kyle
1754 2 6231623162316231 JOE
1755 3 6231623162316231 QA
1756 DROP TABLE t5;
1757
1758 include/rpl_reset.inc
1759 SET NAMES utf8;
1760 Warnings:
1761 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1762 SET SQL_LOG_BIN=0;
1763 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(255) CHARACTER SET UTF8 NOT NULL) ENGINE='NDB';
1764 Warnings:
1765 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1766 SET SQL_LOG_BIN=1;
1767 CREATE TABLE t1 (c1 INT) ENGINE='NDB';
1768 INSERT IGNORE INTO t1 VALUES ();
1769 SET @text= REPEAT(_utf8'ç', 255);
1770 INSERT INTO t1 VALUES (1, @text);
1771 SELECT * FROM t1 ORDER BY c1;
1772 c1 c2
1773 0
1774 1 ççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççç
1775 SELECT * FROM t1 ORDER BY c1;
1776 c1
1777 0
1778 1
1779 DROP TABLE t1;
1780 include/rpl_end.inc