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