1
include/master-slave.inc
3
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
7
***********************************************************
8
***********************************************************
9
***************** Start of Testing ************************
10
***********************************************************
11
***********************************************************
12
* This test format == binlog_format ROW and engine == 'MyISAM'
13
***********************************************************
14
***********************************************************
16
***** Testing more columns on the Master *****
18
CREATE TABLE t1 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
20
f5 FLOAT DEFAULT '2.00',
21
f6 CHAR(4) DEFAULT 'TEST',
26
f11 VARBINARY(64))ENGINE='MyISAM';
28
* Alter Table on Slave and drop columns f5 through f11 *
30
alter table t1 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
32
* Insert data in Master then update and delete some rows*
34
* Select count and 20 rows from Master *
36
SELECT COUNT(*) FROM t1;
40
SELECT f1,f2,f3,f4,f5,f6,f7,f8,f9,
41
hex(f10),hex(f11) FROM t1 ORDER BY f3 LIMIT 20;
42
f1 f2 f3 f4 f5 f6 f7 f8 f9 hex(f10) hex(f11)
43
2 2 2 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
44
3 3 3 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
45
5 5 5 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
46
6 6 6 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
47
8 8 8 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
48
9 9 9 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
49
11 11 11 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
50
12 12 12 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
51
14 14 14 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
52
15 15 15 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
53
17 17 17 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
54
18 18 18 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
55
20 20 20 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
56
21 21 21 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
57
23 23 23 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
58
24 24 24 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
59
26 26 26 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
60
27 27 27 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
61
29 29 29 second 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
62
30 30 30 next 2 kaks 2 got stolen from the paradise very fat blob 1555 123456
64
* Select count and 20 rows from Slave *
66
SELECT COUNT(*) FROM t1;
70
SELECT * FROM t1 ORDER BY f3 LIMIT 20;
92
include/check_slave_is_running.inc
94
***** Testing Altering table def scenario *****
96
CREATE TABLE t2 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
98
f5 DOUBLE DEFAULT '2.00',
99
f6 ENUM('a', 'b', 'c') default 'a',
100
f7 DECIMAL(17,9) default '1000.00',
102
f9 NUMERIC(6,2) default '2000.00',
104
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',
105
f12 SET('a', 'b', 'c') default 'b')
108
CREATE TABLE t3 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
110
f5 DOUBLE DEFAULT '2.00',
111
f6 ENUM('a', 'b', 'c') default 'a',
114
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',
115
f12 SET('a', 'b', 'c') default 'b')
118
CREATE TABLE t4 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
120
f5 DOUBLE DEFAULT '2.00',
121
f6 DECIMAL(17,9) default '1000.00',
123
f8 NUMERIC(6,2) default '2000.00',
125
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
CREATE TABLE t31 (f1 INT, f2 INT, f3 INT PRIMARY KEY, f4 CHAR(20),
156
f30 ENUM ('a','b', 'c') default 'a',
159
f33 SET ('a', 'b', 'c') default 'b',
164
** Alter tables on slave and drop columns **
166
alter table t2 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11, drop
168
alter table t3 drop f5, drop f6, drop f8, drop f10, drop f11, drop f12;
169
alter table t4 drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11;
171
drop f5, drop f6, drop f7, drop f8, drop f9, drop f10, drop f11,
172
drop f12, drop f13, drop f14, drop f15, drop f16, drop f17, drop f18,
173
drop f19, drop f20, drop f21, drop f22, drop f23, drop f24, drop f25,
174
drop f26, drop f27, drop f28, drop f29, drop f30, drop f31, drop f32,
175
drop f33, drop f34, drop f35;
177
** Insert Data into Master **
178
INSERT into t2 set f1=1, f2=1, f3=1, f4='first', f8='f8: medium size blob', f10='f10:
180
INSERT into t2 values (2, 2, 2, 'second',
181
2.0, 'b', 2000.0002, 'f8: medium size blob', 2000, 'f10: some var char',
184
3.0, 'b', 3000.0003, 'f8: medium size blob', 3000, 'f10: some var char',
186
INSERT into t3 set f1=1, f2=1, f3=1, f4='first', f10='f10: some var char';
187
INSERT into t4 set f1=1, f2=1, f3=1, f4='first', f7='f7: medium size blob', f10='f10:
189
INSERT into t31 set f1=1, f2=1, f3=1, f4='first';
190
INSERT into t31 set f1=1, f2=1, f3=2, f4='second',
191
f9=2.2, f10='seven samurai', f28=222.222, f35='222';
193
Warning 1366 Incorrect integer value: 'seven samurai' for column 'f10' at row 1
194
INSERT into t31 values (1, 1, 3, 'third',
195
/* f5 BIGINT, */ 333333333333333333333333,
196
/* f6 BLOB, */ '3333333333333333333333',
197
/* f7 DATE, */ '2007-07-18',
198
/* f8 DATETIME, */ "2007-07-18",
199
/* f9 FLOAT, */ 3.33333333,
200
/* f10 INT, */ 333333333,
201
/* f11 LONGBLOB, */ '3333333333333333333',
202
/* f12 LONGTEXT, */ '3333333333333333333',
203
/* f13 MEDIUMBLOB, */ '3333333333333333333',
204
/* f14 MEDIUMINT, */ 33,
205
/* f15 MEDIUMTEXT, */ 3.3,
207
/* f17 SMALLINT, */ 3,
208
/* f18 TEXT, */ '33',
209
/* f19 TIME, */ '2:59:58.999',
210
/* f20 TIMESTAMP, */ 20000303000000,
211
/* f21 TINYBLOB, */ '3333',
212
/* f22 TINYINT, */ 3,
213
/* f23 TINYTEXT, */ '3',
214
/* f24 YEAR, */ 3000,
215
/* f25 BINARY(255), */ 'three_33333',
216
/* f26 BIT(64), */ b'011',
217
/* f27 CHAR(255), */ 'three',
218
/* f28 DECIMAL(30,7), */ 3.333,
219
/* f29 DOUBLE, */ 3.333333333333333333333333333,
220
/* f30 ENUM ('a','b','c')*/ 'c',
221
/* f31 FLOAT, */ 3.0,
222
/* f32 NUMERIC(17,9), */ 3.3333,
223
/* f33 SET ('a','b','c'),*/ 'c',
224
/*f34 VARBINARY(1025),*/ '3333 minus 3',
225
/*f35 VARCHAR(257),*/ 'three times three'
228
Warning 1264 Out of range value for column 'f5' at row 1
229
Warning 1264 Out of range value for column 'f24' at row 1
230
INSERT into t31 values (1, 1, 4, 'fourth',
231
/* f5 BIGINT, */ 333333333333333333333333,
232
/* f6 BLOB, */ '3333333333333333333333',
233
/* f7 DATE, */ '2007-07-18',
234
/* f8 DATETIME, */ "2007-07-18",
235
/* f9 FLOAT, */ 3.33333333,
236
/* f10 INT, */ 333333333,
237
/* f11 LONGBLOB, */ '3333333333333333333',
238
/* f12 LONGTEXT, */ '3333333333333333333',
239
/* f13 MEDIUMBLOB, */ '3333333333333333333',
240
/* f14 MEDIUMINT, */ 33,
241
/* f15 MEDIUMTEXT, */ 3.3,
243
/* f17 SMALLINT, */ 3,
244
/* f18 TEXT, */ '33',
245
/* f19 TIME, */ '2:59:58.999',
246
/* f20 TIMESTAMP, */ 20000303000000,
247
/* f21 TINYBLOB, */ '3333',
248
/* f22 TINYINT, */ 3,
249
/* f23 TINYTEXT, */ '3',
250
/* f24 YEAR, */ 3000,
251
/* f25 BINARY(255), */ 'three_33333',
252
/* f26 BIT(64), */ b'011',
253
/* f27 CHAR(255), */ 'three',
254
/* f28 DECIMAL(30,7), */ 3.333,
255
/* f29 DOUBLE, */ 3.333333333333333333333333333,
256
/* f30 ENUM ('a','b','c')*/ 'c',
257
/* f31 FLOAT, */ 3.0,
258
/* f32 NUMERIC(17,9), */ 3.3333,
259
/* f33 SET ('a','b','c'),*/ 'c',
260
/*f34 VARBINARY(1025),*/ '3333 minus 3',
261
/*f35 VARCHAR(257),*/ 'three times three'
264
/* f5 BIGINT, */ 333333333333333333333333,
265
/* f6 BLOB, */ '3333333333333333333333',
266
/* f7 DATE, */ '2007-07-18',
267
/* f8 DATETIME, */ "2007-07-18",
268
/* f9 FLOAT, */ 3.33333333,
269
/* f10 INT, */ 333333333,
270
/* f11 LONGBLOB, */ '3333333333333333333',
271
/* f12 LONGTEXT, */ '3333333333333333333',
272
/* f13 MEDIUMBLOB, */ '3333333333333333333',
273
/* f14 MEDIUMINT, */ 33,
274
/* f15 MEDIUMTEXT, */ 3.3,
276
/* f17 SMALLINT, */ 3,
277
/* f18 TEXT, */ '33',
278
/* f19 TIME, */ '2:59:58.999',
279
/* f20 TIMESTAMP, */ 20000303000000,
280
/* f21 TINYBLOB, */ '3333',
281
/* f22 TINYINT, */ 3,
282
/* f23 TINYTEXT, */ '3',
283
/* f24 YEAR, */ 3000,
284
/* f25 BINARY(255), */ 'three_33333',
285
/* f26 BIT(64), */ b'011',
286
/* f27 CHAR(255), */ 'three',
287
/* f28 DECIMAL(30,7), */ 3.333,
288
/* f29 DOUBLE, */ 3.333333333333333333333333333,
289
/* f30 ENUM ('a','b','c')*/ 'c',
290
/* f31 FLOAT, */ 3.0,
291
/* f32 NUMERIC(17,9), */ 3.3333,
292
/* f33 SET ('a','b','c'),*/ 'c',
293
/*f34 VARBINARY(1025),*/ '3333 minus 3',
294
/*f35 VARCHAR(257),*/ 'three times three'
297
/* f5 BIGINT, */ NULL,
298
/* f6 BLOB, */ '3333333333333333333333',
299
/* f7 DATE, */ '2007-07-18',
300
/* f8 DATETIME, */ "2007-07-18",
301
/* f9 FLOAT, */ 3.33333333,
302
/* f10 INT, */ 333333333,
303
/* f11 LONGBLOB, */ '3333333333333333333',
304
/* f12 LONGTEXT, */ '3333333333333333333',
305
/* f13 MEDIUMBLOB, */ '3333333333333333333',
306
/* f14 MEDIUMINT, */ 33,
307
/* f15 MEDIUMTEXT, */ 3.3,
309
/* f17 SMALLINT, */ 3,
310
/* f18 TEXT, */ '33',
311
/* f19 TIME, */ '2:59:58.999',
312
/* f20 TIMESTAMP, */ 20000303000000,
313
/* f21 TINYBLOB, */ '3333',
314
/* f22 TINYINT, */ 3,
315
/* f23 TINYTEXT, */ '3',
316
/* f24 YEAR, */ 3000,
317
/* f25 BINARY(255), */ 'three_33333',
318
/* f26 BIT(64), */ b'011',
319
/* f27 CHAR(255), */ 'three',
320
/* f28 DECIMAL(30,7), */ 3.333,
321
/* f29 DOUBLE, */ 3.333333333333333333333333333,
322
/* f30 ENUM ('a','b','c')*/ 'c',
323
/* f31 FLOAT, */ 3.0,
324
/* f32 NUMERIC(17,9), */ 3.3333,
325
/* f33 SET ('a','b','c'),*/ 'c',
326
/*f34 VARBINARY(1025),*/ '3333 minus 3',
327
/*f35 VARCHAR(257),*/ NULL
330
Warning 1264 Out of range value for column 'f5' at row 1
331
Warning 1264 Out of range value for column 'f24' at row 1
332
Warning 1264 Out of range value for column 'f5' at row 2
333
Warning 1264 Out of range value for column 'f24' at row 2
334
Warning 1264 Out of range value for column 'f24' at row 3
336
** Sync slave with master **
337
** Do selects from tables **
339
select * from t1 order by f3;
381
select * from t2 order by f1;
386
select * from t3 order by f1;
389
select * from t4 order by f1;
392
select * from t31 order by f3;
401
** Do updates master **
403
update t31 set f5=555555555555555 where f3=6;
404
update t31 set f2=2 where f3=2;
405
update t31 set f1=NULL where f3=1;
406
update t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3;
408
Warning 1048 Column 'f3' cannot be null
410
** Delete from Master **
420
** Check slave status **
422
include/check_slave_is_running.inc
424
****************************************
425
* columns in master at middle of table *
426
* Expect: Proper error message *
427
****************************************
429
** Stop and Reset Slave **
433
** create table slave side **
434
CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
437
** Connect to master and create table **
439
CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
440
c CHAR(5), e INT DEFAULT '1')ENGINE='MyISAM';
443
include/rpl_reset.inc
445
*** Master Data Insert ***
446
set @b1 = 'b1b1b1b1';
447
set @b1 = concat(@b1,@b1);
448
INSERT INTO t10 () VALUES(1,@b1,DEFAULT,'Kyle',DEFAULT),
449
(2,@b1,DEFAULT,'JOE',DEFAULT),
450
(3,@b1,DEFAULT,'QA',DEFAULT);
452
********************************************
453
*** Expect slave to fail with Error 1677 ***
454
********************************************
456
include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
461
*********************************************
462
* More columns in master at middle of table *
463
* Expect: Proper error message *
464
*********************************************
466
*** Create t11 on slave ***
468
CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
471
*** Create t11 on Master ***
472
CREATE TABLE t11 (a INT KEY, b BLOB, f TEXT,
473
c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='MyISAM';
476
include/rpl_reset.inc
478
*** Master Data Insert ***
479
set @b1 = 'b1b1b1b1';
480
set @b1 = concat(@b1,@b1);
481
INSERT INTO t11 () VALUES(1,@b1,'Testing is fun','Kyle',DEFAULT),
482
(2,@b1,'Testing is cool','JOE',DEFAULT),
483
(3,@b1,DEFAULT,'QA',DEFAULT);
485
********************************************
486
*** Expect slave to fail with Error 1677 ***
487
********************************************
489
include/wait_for_slave_sql_error_and_skip.inc [errno=1677]
494
*********************************************
495
* More columns in master at middle of table *
496
* Expect: This one should pass blob-text *
497
*********************************************
499
*** Create t12 on slave ***
501
CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
504
*** Create t12 on Master ***
505
CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
506
c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE='MyISAM';
509
include/rpl_reset.inc
511
*** Master Data Insert ***
512
set @b1 = 'b1b1b1b1';
513
set @b1 = concat(@b1,@b1);
514
INSERT INTO t12 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
515
(2,@b1,'JOE',DEFAULT,DEFAULT),
516
(3,@b1,'QA',DEFAULT,DEFAULT);
518
SELECT a,hex(b),f,c,e FROM t12 ORDER BY a;
520
1 62316231623162316231623162316231 Kyle test 1
521
2 62316231623162316231623162316231 JOE test 1
522
3 62316231623162316231623162316231 QA test 1
524
*** Select on Slave ***
525
SELECT a,hex(b),c FROM t12 ORDER BY a;
527
1 62316231623162316231623162316231 Kyle
528
2 62316231623162316231623162316231 JOE
529
3 62316231623162316231623162316231 QA
534
****************************************************
535
* - Alter Master adding columns at middle of table *
536
* Expect: columns added *
537
****************************************************
540
*** Create t14 on slave ***
542
CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
545
*** Create t14 on Master ***
546
CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
548
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
552
include/rpl_reset.inc
554
*** Master Data Insert ***
555
ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
556
ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
558
set @b1 = 'b1b1b1b1';
559
set @b1 = concat(@b1,@b1);
560
INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle',DEFAULT,DEFAULT),
561
(2,2.00,'This Test Should work',@b1,'JOE',DEFAULT,DEFAULT),
562
(3,3.00,'If is does not, I will open a bug',@b1,'QA',DEFAULT,DEFAULT);
564
SELECT c1,c2,c3,hex(c4),c5,c6,c7 FROM t14 ORDER BY c1;
565
c1 c2 c3 hex(c4) c5 c6 c7
566
1 1.00 Replication Testing Extra Col 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
567
2 2.00 This Test Should work 62316231623162316231623162316231 JOE 1 CURRENT_TIMESTAMP
568
3 3.00 If is does not, I will open a bug 62316231623162316231623162316231 QA 1 CURRENT_TIMESTAMP
570
*** Select on Slave ****
571
SELECT c1,c2,c3,hex(c4),c5 FROM t14 ORDER BY c1;
573
1 1.00 Replication Testing Extra Col 62316231623162316231623162316231 Kyle
574
2 2.00 This Test Should work 62316231623162316231623162316231 JOE
575
3 3.00 If is does not, I will open a bug 62316231623162316231623162316231 QA
577
****************************************************
578
* - Alter Master Dropping columns from the middle. *
579
* Expect: columns dropped *
580
****************************************************
582
*** connect to master and drop columns ***
583
ALTER TABLE t14 DROP COLUMN c2;
584
ALTER TABLE t14 DROP COLUMN c7;
586
*** Select from Master ***
587
SELECT c1,c3,hex(c4),c5,c6 FROM t14 ORDER BY c1;
589
1 Replication Testing Extra Col 62316231623162316231623162316231 Kyle 1
590
2 This Test Should work 62316231623162316231623162316231 JOE 1
591
3 If is does not, I will open a bug 62316231623162316231623162316231 QA 1
596
include/wait_for_slave_sql_error.inc [errno=1091]
602
include/rpl_reset.inc
604
*************************************************
605
* - Alter Master adding columns at end of table *
606
* Expect: Error 1054 *
607
*************************************************
609
*** Create t15 on slave ***
611
CREATE TABLE t15 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
614
*** Create t15 on Master ***
615
CREATE TABLE t15 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
617
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
621
include/rpl_reset.inc
623
*** Master Data Insert ***
624
ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7;
625
set @b1 = 'b1b1b1b1';
626
set @b1 = concat(@b1,@b1);
627
INSERT INTO t15 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT,3.00),
628
(2,@b1,'JOE',DEFAULT,DEFAULT,3.00),
629
(3,@b1,'QA',DEFAULT,DEFAULT,3.00);
630
SELECT c1,hex(c4),c5,c6,c7,c2 FROM t15 ORDER BY c1;
631
c1 hex(c4) c5 c6 c7 c2
632
1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP 3.00
633
2 62316231623162316231623162316231 JOE 1 CURRENT_TIMESTAMP 3.00
634
3 62316231623162316231623162316231 QA 1 CURRENT_TIMESTAMP 3.00
636
********************************************
637
*** Expect slave to fail with Error 1054 ***
638
********************************************
640
include/wait_for_slave_sql_error.inc [errno=1054]
646
include/rpl_reset.inc
648
************************************************
649
* - Create index on Master column not on slave *
651
************************************************
653
*** Create t16 on slave ***
655
CREATE TABLE t16 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
658
*** Create t16 on Master ***
659
CREATE TABLE t16 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
661
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
665
include/rpl_reset.inc
667
*** Master Create Index and Data Insert ***
668
CREATE INDEX part_of_c6 ON t16 (c6);
669
set @b1 = 'b1b1b1b1';
670
set @b1 = concat(@b1,@b1);
671
INSERT INTO t16 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
672
(2,@b1,'JOE',2,DEFAULT),
673
(3,@b1,'QA',3,DEFAULT);
674
SELECT c1,hex(c4),c5,c6,c7 FROM t16 ORDER BY c1;
676
1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
677
2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
678
3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
684
include/wait_for_slave_sql_error.inc [errno=1072]
690
include/rpl_reset.inc
692
*****************************************************
693
* - Delete rows using column on Master not on slave *
694
* Expect: Rows Deleted *
695
*****************************************************
697
*** Create t17 on slave ***
699
CREATE TABLE t17 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
702
*** Create t17 on Master ***
703
CREATE TABLE t17 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
705
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
709
include/rpl_reset.inc
711
*** Master Data Insert ***
712
set @b1 = 'b1b1b1b1';
713
set @b1 = concat(@b1,@b1);
714
INSERT INTO t17 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
715
(2,@b1,'JOE',2,DEFAULT),
716
(3,@b1,'QA',3,DEFAULT);
717
SELECT c1,hex(c4),c5,c6,c7 FROM t17 ORDER BY c1;
719
1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
720
2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
721
3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
723
** Select * from Slave **
724
SELECT c1,hex(c4),c5 FROM t17 ORDER BY c1;
726
1 62316231623162316231623162316231 Kyle
727
2 62316231623162316231623162316231 JOE
728
3 62316231623162316231623162316231 QA
730
** Delete from master **
731
DELETE FROM t17 WHERE c6 = 3;
732
SELECT c1,hex(c4),c5,c6,c7 FROM t17 ORDER BY c1;
734
1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
735
2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
738
SELECT c1,hex(c4),c5 FROM t17 ORDER BY c1;
740
1 62316231623162316231623162316231 Kyle
741
2 62316231623162316231623162316231 JOE
745
*****************************************************
746
* - Update row using column on Master not on slave *
747
* Expect: Rows updated *
748
*****************************************************
752
*** Create t18 on slave ***
755
CREATE TABLE t18 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
758
*** Create t18 on Master ***
759
CREATE TABLE t18 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
761
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
765
include/rpl_reset.inc
767
*** Master Data Insert ***
768
set @b1 = 'b1b1b1b1';
769
set @b1 = concat(@b1,@b1);
770
INSERT INTO t18 () VALUES(1,@b1,'Kyle',DEFAULT,DEFAULT),
771
(2,@b1,'JOE',2,DEFAULT),
772
(3,@b1,'QA',3,DEFAULT);
773
SELECT c1,hex(c4),c5,c6,c7 FROM t18 ORDER BY c1;
775
1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
776
2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
777
3 62316231623162316231623162316231 QA 3 CURRENT_TIMESTAMP
779
** Select * from Slave **
780
SELECT c1,hex(c4),c5 FROM t18 ORDER BY c1;
782
1 62316231623162316231623162316231 Kyle
783
2 62316231623162316231623162316231 JOE
784
3 62316231623162316231623162316231 QA
786
** update from master **
787
UPDATE t18 SET c5 = 'TEST' WHERE c6 = 3;
788
SELECT c1,hex(c4),c5,c6,c7 FROM t18 ORDER BY c1;
790
1 62316231623162316231623162316231 Kyle 1 CURRENT_TIMESTAMP
791
2 62316231623162316231623162316231 JOE 2 CURRENT_TIMESTAMP
792
3 62316231623162316231623162316231 TEST 3 CURRENT_TIMESTAMP
795
SELECT c1,hex(c4),c5 FROM t18 ORDER BY c1;
797
1 62316231623162316231623162316231 Kyle
798
2 62316231623162316231623162316231 JOE
799
3 62316231623162316231623162316231 TEST
803
*****************************************************
804
* - Insert UUID column on Master not on slave *
805
* Expect: Rows inserted *
806
*****************************************************
808
*** Create t5 on slave ***
810
CREATE TABLE t5 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
813
*** Create t5 on Master ***
814
CREATE TABLE t5 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
816
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
820
include/rpl_reset.inc
822
*** Master Data Insert ***
823
set @b1 = 'b1b1b1b1';
824
INSERT INTO t5 () VALUES(1,@b1,'Kyle',UUID(),DEFAULT),
825
(2,@b1,'JOE',UUID(),DEFAULT),
826
(3,@b1,'QA',UUID(),DEFAULT);
827
SELECT c1,hex(c4),c5,c6,c7 FROM t5 ORDER BY c1;
829
1 6231623162316231 Kyle UUID TIME
830
2 6231623162316231 JOE UUID TIME
831
3 6231623162316231 QA UUID TIME
833
** Select * from Slave **
834
SELECT c1,hex(c4),c5 FROM t5 ORDER BY c1;
836
1 6231623162316231 Kyle
837
2 6231623162316231 JOE
838
3 6231623162316231 QA
841
include/rpl_reset.inc
844
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(255) CHARACTER SET UTF8 NOT NULL) ENGINE='MyISAM';
846
CREATE TABLE t1 (c1 INT) ENGINE='MyISAM';
847
INSERT INTO t1 VALUES ();
848
SET @text= REPEAT(_utf8'ç', 255);
849
INSERT INTO t1 VALUES (1, @text);
850
SELECT * FROM t1 ORDER BY c1;
853
1 ççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççççç
854
SELECT * FROM t1 ORDER BY c1;