1
#################################################
2
# Purpose: To test having extra columns on the slave.
3
##################################################
5
# Some tests in here requre partitioning
6
-- source include/have_partition.inc
8
#################################################
9
############ Different Table Def Test ###########
10
#################################################
11
# Purpose: To have different table def on the #
12
# master and slave. Most of these tests#
13
# should stop the slave. #
14
#################################################
16
call mtr.add_suppression("Slave: Unknown table 't6' Error_code: 1051");
18
--echo **** Diff Table Def Start ****
20
##############################################
21
### Try to replicate w/ PK on diff columns ###
22
### Should Stop Slave ###
23
##############################################
25
--echo *** On Slave ***
26
sync_slave_with_master;
30
eval CREATE TABLE t1 (a INT, b INT PRIMARY KEY, c CHAR(20),
31
d FLOAT DEFAULT '2.00',
32
e CHAR(4) DEFAULT 'TEST')
35
--echo *** Create t1 on Master ***
37
eval CREATE TABLE t1 (a INT PRIMARY KEY, b INT, c CHAR(10)
38
) ENGINE=$engine_type;
42
--echo *** Start Slave ***
46
--echo *** Master Data Insert ***
49
INSERT INTO t1 () VALUES(1,2,'TEXAS'),(2,1,'AUSTIN'),(3,4,'QA');
50
SELECT * FROM t1 ORDER BY a;
52
--echo *** Select from slave ***
53
sync_slave_with_master;
54
SELECT * FROM t1 ORDER BY a;
56
--echo *** Drop t1 ***
59
sync_slave_with_master;
61
############################################
62
### Try to replicate CHAR(10) to CHAR(5) ###
63
### Should Stop Slave or truncate value ###
64
############################################
67
--echo *** Create t2 on slave ***
70
eval CREATE TABLE t2 (a INT, b INT PRIMARY KEY, c CHAR(5),
71
d FLOAT DEFAULT '2.00',
72
e CHAR(5) DEFAULT 'TEST2')
75
--echo *** Create t2 on Master ***
77
eval CREATE TABLE t2 (a INT PRIMARY KEY, b INT, c CHAR(10)
78
) ENGINE=$engine_type;
81
--echo *** Master Data Insert ***
84
INSERT INTO t2 () VALUES(1,2,'Kyle, TEX'),(2,1,'JOE AUSTIN'),(3,4,'QA TESTING');
85
SELECT * FROM t2 ORDER BY a;
87
--echo *** Start Slave ***
90
--let $slave_sql_errno= 1535
91
--let $show_slave_sql_error= 1
92
--source include/wait_for_slave_sql_error.inc
95
SELECT * FROM t2 ORDER BY a;
103
--echo *** Drop t2 ***
106
sync_slave_with_master;
108
####################################
109
### Try to replicate BLOB to INT ###
110
### Should Stop Slave ###
111
####################################
112
--echo *** Create t3 on slave ***
115
eval CREATE TABLE t3 (a INT, b INT PRIMARY KEY, c CHAR(20),
116
d FLOAT DEFAULT '2.00',
117
e CHAR(5) DEFAULT 'TEST2')
120
--echo *** Create t3 on Master ***
122
eval CREATE TABLE t3 (a BLOB, b INT PRIMARY KEY, c CHAR(20)
123
) ENGINE=$engine_type;
126
--echo *** Start Slave ***
130
--echo *** Master Data Insert ***
134
set @b1 = concat(@b1,@b1);
136
INSERT INTO t3 () VALUES(@b1,2,'Kyle, TEX'),(@b1,1,'JOE AUSTIN'),(@b1,4,'QA TESTING');
138
--echo ********************************************
139
--echo *** Expect slave to fail with Error 1535 ***
140
--echo ********************************************
142
--let $slave_sql_errno= 1535
143
--let $slave_skip_counter= 2
144
--let $show_slave_sql_error= 1
145
--source include/wait_for_slave_sql_error_and_skip.inc
147
--echo *** Drop t3 ***
150
sync_slave_with_master;
152
#####################################################
153
# Columns with different types, more columns at end #
154
# Expect: proper error message (wrong types) #
155
#####################################################
157
--echo *** Create t4 on slave ***
160
eval CREATE TABLE t4 (a INT, b INT PRIMARY KEY, c CHAR(20),
161
d FLOAT DEFAULT '2.00',
162
e CHAR(5) DEFAULT 'TEST2')
165
--echo *** Create t4 on Master ***
167
eval CREATE TABLE t4 (a DECIMAL(8,2), b INT PRIMARY KEY, c CHAR(20)
168
) ENGINE=$engine_type;
171
--echo *** Start Slave ***
175
--echo *** Master Data Insert ***
178
INSERT INTO t4 () VALUES(100.22,2,'Kyle, TEX'),(200.26,1,'JOE AUSTIN'),
179
(30000.22,4,'QA TESTING');
181
--echo ********************************************
182
--echo *** Expect slave to fail with Error 1535 ***
183
--echo ********************************************
185
--let $slave_sql_errno= 1535
186
--let $slave_skip_counter= 2
187
--let $show_slave_sql_error= 1
188
--source include/wait_for_slave_sql_error_and_skip.inc
190
--echo *** Drop t4 ***
193
sync_slave_with_master;
195
#######################################################
196
# Columns with different types, same number of colums #
197
# Expect: Proper error message #
198
#######################################################
200
--echo *** Create t5 on slave ***
203
eval CREATE TABLE t5 (a INT PRIMARY KEY, b CHAR(5),
204
c FLOAT, d INT, e DOUBLE,
205
f DECIMAL(8,2))ENGINE=$engine_type;
207
--echo *** Create t5 on Master ***
209
eval CREATE TABLE t5 (a INT PRIMARY KEY, b VARCHAR(6),
210
c DECIMAL(8,2), d BIT, e BLOB,
211
f FLOAT) ENGINE=$engine_type;
214
--echo *** Start Slave ***
218
--echo *** Master Data Insert ***
221
INSERT INTO t5 () VALUES(1,'Kyle',200.23,1,'b1b1',23.00098),
222
(2,'JOE',300.01,0,'b2b2',1.0000009);
224
--echo ********************************************
225
--echo *** Expect slave to fail with Error 1535 ***
226
--echo ********************************************
228
--let $slave_sql_errno= 1535
229
--let $slave_skip_counter= 2
230
--let $show_slave_sql_error= 1
231
--source include/wait_for_slave_sql_error_and_skip.inc
233
--echo *** Drop t5 ***
236
sync_slave_with_master;
238
#######################################################
239
################## Continued ##########################
240
#######################################################
241
# Columns with different types, same number of colums #
242
# Expect: Proper error message #
243
#######################################################
245
--echo *** Create t6 on slave ***
248
eval CREATE TABLE t6 (a INT PRIMARY KEY, b CHAR(5),
249
c FLOAT, d INT)ENGINE=$engine_type;
251
--echo *** Create t6 on Master ***
253
eval CREATE TABLE t6 (a INT PRIMARY KEY, b VARCHAR(6),
254
c DECIMAL(8,2), d BIT
255
) ENGINE=$engine_type;
258
--echo *** Start Slave ***
262
--echo *** Master Data Insert ***
265
INSERT INTO t6 () VALUES(1,'Kyle',200.23,1),
268
--echo ********************************************
269
--echo *** Expect slave to fail with Error 1535 ***
270
--echo ********************************************
272
--let $slave_sql_errno= 1535
273
--let $show_slave_sql_error= 1
274
--source include/wait_for_slave_sql_error.inc
275
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=3;
278
--echo *** Drop t6 ***
284
#sync_slave_with_master;
287
--echo **** Diff Table Def End ****
289
#######################################
290
#### Extra Column on Slave Testing ####
291
#######################################
292
# Purpose: To test extra colums on the#
294
#######################################
296
--echo **** Extra Colums Start ****
298
##########################################
299
# More columns in slave at end of table, #
300
# added columns have default values #
301
# Expect: it should work, default values #
303
##########################################
305
--echo *** Create t7 on slave ***
308
eval CREATE TABLE t7 (a INT KEY, b BLOB, c CHAR(5),
309
d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
310
e CHAR(20) DEFAULT 'Extra Column Testing')
313
--echo *** Create t7 on Master ***
315
eval CREATE TABLE t7 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
316
) ENGINE=$engine_type;
319
--echo *** Start Slave ***
323
--echo *** Master Data Insert ***
326
set @b1 = concat(@b1,@b1);
327
INSERT INTO t7 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
328
SELECT * FROM t7 ORDER BY a;
330
--echo *** Select from slave ***
331
sync_slave_with_master;
332
SELECT * FROM t7 ORDER BY a;
334
--echo *** Drop t7 ***
337
sync_slave_with_master;
339
###########################################
340
# More columns in slave at end of table, #
341
# added columns do not have default values#
342
# Expect: Proper error message #
343
###########################################
344
# NOTE: This should fail but currently #
346
###########################################
347
--echo *** Create t8 on slave ***
350
eval CREATE TABLE t8 (a INT KEY, b BLOB, c CHAR(5),
351
d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
352
e INT)ENGINE=$engine_type;
354
--echo *** Create t8 on Master ***
356
eval CREATE TABLE t8 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
357
) ENGINE=$engine_type;
360
--echo *** Start Slave ***
364
--echo *** Master Data Insert ***
366
set @b1 = 'b1b1b1b1';
367
set @b1 = concat(@b1,@b1);
368
INSERT INTO t8 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
370
### Uncomment once bug is fixed
373
#--let $slave_sql_errno= SOMETHING
374
#--let $slave_skip_counter= 2
375
#--let $show_slave_sql_error= 1
376
#--source include/wait_for_slave_sql_error_and_skip.inc
378
--echo *** Drop t8 ***
381
sync_slave_with_master;
383
###########################################
384
############# Continued ###################
385
# More columns in slave at end of table, #
386
# added columns do not have default values#
387
# Expect: Proper error message #
388
###########################################
389
# Bug#22234, Bug#23907 Extra Slave Col is not
390
# erroring on extra col with no default values.
391
###############################################################
392
# Error reaction is up to sql_mode of the slave sql (bug#38173)
393
#--echo *** Create t9 on slave ***
394
# Please, check BUG#47741 to see why you are not testing NDB.
395
if (`SELECT $engine_type != 'NDB'`)
399
eval CREATE TABLE t9 (a INT KEY, b BLOB, c CHAR(5),
405
i blob) ENGINE=$engine_type;
407
--echo *** Create t9 on Master ***
409
eval CREATE TABLE t9 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
410
) ENGINE=$engine_type;
413
--echo *** Start Slave ***
417
--echo *** Master Data Insert ***
419
set @b1 = 'b1b1b1b1';
421
set @b1 = concat(@b1,@b1);
422
INSERT INTO t9 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
424
# the test would stop slave if @@sql_mode for the sql thread
425
# was set to strict. Otherwise, as with this tests setup,
426
# the implicit defaults will be inserted into fields even though
427
# they are declared without DEFAULT clause.
429
sync_slave_with_master;
432
# todo: fix Bug #43992 slave sql thread can't tune own sql_mode ...
433
# and add/restore waiting for stop test
435
#--let $slave_sql_errno= SOMETHING
436
#--let $slave_skip_counter= 2
437
#--let $show_slave_sql_error= 1
438
#--source include/wait_for_slave_sql_error_and_skip.inc
441
#--echo *** Drop t9 ***
444
sync_slave_with_master;
446
############################################
447
# More columns in slave at middle of table #
448
# Expect: Proper error message #
449
############################################
450
--echo *** Create t10 on slave ***
453
eval CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
454
c CHAR(5), e INT DEFAULT '1')ENGINE=$engine_type;
456
--echo *** Create t10 on Master ***
458
eval CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
459
) ENGINE=$engine_type;
462
--echo *** Start Slave ***
466
--echo *** Master Data Insert ***
468
set @b1 = 'b1b1b1b1';
469
set @b1 = concat(@b1,@b1);
470
INSERT INTO t10 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
472
--echo ********************************************
473
--echo *** Expect slave to fail with Error 1535 ***
474
--echo ********************************************
476
--let $slave_sql_errno= 1535
477
--let $slave_skip_counter= 2
478
--let $show_slave_sql_error= 1
479
--source include/wait_for_slave_sql_error_and_skip.inc
481
--echo *** Drop t10 ***
484
sync_slave_with_master;
486
############################################
487
############## Continued ###################
488
############################################
489
# More columns in slave at middle of table #
490
# Expect: Proper error message #
491
############################################
492
--echo *** Create t11 on slave ***
495
eval CREATE TABLE t11 (a INT KEY, b BLOB, f TEXT,
496
c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE=$engine_type;
498
--echo *** Create t11 on Master ***
500
eval CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
501
) ENGINE=$engine_type;
504
--echo *** Start Slave ***
508
--echo *** Master Data Insert ***
510
set @b1 = 'b1b1b1b1';
511
set @b1 = concat(@b1,@b1);
512
INSERT INTO t11 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
514
--echo ********************************************
515
--echo *** Expect slave to fail with Error 1535 ***
516
--echo ********************************************
518
--let $slave_sql_errno= 1535
519
--let $slave_skip_counter= 2
520
--let $show_slave_sql_error= 1
521
--source include/wait_for_slave_sql_error_and_skip.inc
523
--echo *** Drop t11 ***
526
sync_slave_with_master;
528
############################################
529
############## Continued ###################
530
############################################
531
# More columns in slave at middle of table #
532
# Expect: This one should pass blob-text #
533
############################################
534
--echo *** Create t12 on slave ***
537
eval CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
538
c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE=$engine_type;
540
--echo *** Create t12 on Master ***
542
eval CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
543
) ENGINE=$engine_type;
546
--echo *** Start Slave ***
550
--echo *** Master Data Insert ***
552
set @b1 = 'b1b1b1b1';
553
set @b1 = concat(@b1,@b1);
554
INSERT INTO t12 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
555
SELECT * FROM t12 ORDER BY a;
557
--echo *** Select on Slave ***
558
sync_slave_with_master;
559
SELECT * FROM t12 ORDER BY a;
561
--echo *** Drop t12 ***
564
sync_slave_with_master;
566
--echo **** Extra Colums End ****
568
###############################
569
# BUG#22177 CURRENT_TIMESTAMP #
570
# Sould work with ^ #
571
###############################
572
--echo *** BUG 22177 Start ***
573
--echo *** Create t13 on slave ***
576
eval CREATE TABLE t13 (a INT KEY, b BLOB, c CHAR(5),
578
e TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
579
)ENGINE=$engine_type;
581
--echo *** Create t13 on Master ***
583
eval CREATE TABLE t13 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
584
) ENGINE=$engine_type;
587
--echo *** Start Slave ***
591
--echo *** Master Data Insert ***
593
set @b1 = 'b1b1b1b1';
594
set @b1 = concat(@b1,@b1);
595
INSERT INTO t13 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
596
SELECT * FROM t13 ORDER BY a;
598
--echo *** Select on Slave ****
599
sync_slave_with_master;
600
--replace_column 5 CURRENT_TIMESTAMP
601
SELECT * FROM t13 ORDER BY a;
603
--echo *** Drop t13 ***
606
sync_slave_with_master;
608
--echo *** 22117 END ***
610
##############################
611
# ALTER MASTER TABLE TESTING #
612
##############################
614
--echo *** Alter Master Table Testing Start ***
616
####################################################
617
# - Alter Master adding columns at middle of table #
618
# Expect: columns added #
619
####################################################
621
--echo *** Create t14 on slave ***
624
eval CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
626
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
627
)ENGINE=$engine_type;
629
--echo *** Create t14 on Master ***
631
eval CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
632
) ENGINE=$engine_type;
635
--echo *** Start Slave ***
639
--echo *** Master Data Insert ***
641
ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
642
ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
643
set @b1 = 'b1b1b1b1';
644
set @b1 = concat(@b1,@b1);
645
INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
646
(2,2.00,'This Test Should work',@b1,'JOE'),
647
(3,3.00,'If is does not, I will open a bug',@b1,'QA');
648
SELECT * FROM t14 ORDER BY c1;
651
--echo *** Select on Slave ****
652
sync_slave_with_master;
653
--replace_column 7 CURRENT_TIMESTAMP
654
SELECT * FROM t14 ORDER BY c1;
656
####################################################
657
# - Alter Master drop column at end of table #
658
# Expect: column dropped #
659
####################################################
661
--echo *** Create t14a on slave ***
664
eval CREATE TABLE t14a (c1 INT KEY, c4 BLOB, c5 CHAR(5),
666
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
667
)ENGINE=$engine_type;
669
--echo *** Create t14a on Master ***
671
eval CREATE TABLE t14a (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
672
) ENGINE=$engine_type;
675
--echo *** Start Slave ***
679
--echo *** Master Data Insert ***
681
set @b1 = 'b1b1b1b1';
682
set @b1 = concat(@b1,@b1);
683
INSERT INTO t14a () VALUES(1,@b1,'Kyle'),
687
SELECT * FROM t14a ORDER BY c1;
688
--echo *** Select on Slave ****
689
sync_slave_with_master;
690
--replace_column 5 CURRENT_TIMESTAMP
691
SELECT * FROM t14a ORDER BY c1;
695
--echo *** Master Drop c5 ***
697
ALTER TABLE t14a DROP COLUMN c5;
700
--echo *** Start Slave ***
704
--echo *** Master Data Insert ***
706
set @b1 = 'b1b1b1b1';
707
set @b1 = concat(@b1,@b1);
709
INSERT INTO t14a () VALUES(4,@b1),
712
SELECT * FROM t14a ORDER BY c1;
714
--echo *** Select on Slave ****
715
sync_slave_with_master;
716
--replace_column 5 CURRENT_TIMESTAMP
717
SELECT * FROM t14a ORDER BY c1;
721
--sync_slave_with_master
723
####################################################
724
# - Alter Master Dropping columns from the middle. #
725
# Expect: columns dropped #
726
####################################################
728
--echo *** connect to master and drop columns ***
730
ALTER TABLE t14 DROP COLUMN c2;
731
ALTER TABLE t14 DROP COLUMN c4;
732
--echo *** Select from Master ***
733
SELECT * FROM t14 ORDER BY c1;
735
--echo *** Select from Slave ***
736
sync_slave_with_master;
737
--replace_column 5 CURRENT_TIMESTAMP
738
SELECT * FROM t14 ORDER BY c1;
740
--echo *** Drop t14 ***
743
sync_slave_with_master;
745
##############################################################
746
# - Alter Master adding columns that already exist on slave. #
747
# Expect: proper error message #
748
##############################################################
750
--echo *** Create t15 on slave ***
753
eval CREATE TABLE t15 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
756
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
757
)ENGINE=$engine_type;
759
--echo *** Create t15 on Master ***
761
eval CREATE TABLE t15 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
762
c4 BLOB, c5 CHAR(5)) ENGINE=$engine_type;
765
--echo *** Start Slave ***
769
call mtr.add_suppression("Slave SQL.*Error .Unknown table .t6.. on query.* Error_code: 1051");
770
call mtr.add_suppression("Slave SQL.*Error .Duplicate column name .c6.. on query.* Error_code: 1060");
771
call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column . ...e mismatch.* Error_code: 1535");
773
--echo *** Master Data Insert ***
775
set @b1 = 'b1b1b1b1';
776
set @b1 = concat(@b1,@b1);
777
INSERT INTO t15 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
778
(2,2.00,'This Test Should work',@b1,'JOE'),
779
(3,3.00,'If is does not, I will open a bug',@b1,'QA');
780
SELECT * FROM t15 ORDER BY c1;
783
--echo *** Select on Slave ****
784
sync_slave_with_master;
785
--replace_column 7 CURRENT_TIMESTAMP
786
SELECT * FROM t15 ORDER BY c1;
788
--echo *** Add column on master that is a Extra on Slave ***
790
ALTER TABLE t15 ADD COLUMN c6 INT AFTER c5;
792
--echo ********************************************
793
--echo *** Expect slave to fail with Error 1060 ***
794
--echo ********************************************
796
--let $slave_sql_errno= 1060
797
--let $slave_skip_counter= 1
798
--let $show_slave_sql_error= 1
799
--source include/wait_for_slave_sql_error_and_skip.inc
801
--echo *** Try to insert in master ****
803
INSERT INTO t15 () VALUES(5,2.00,'Replication Testing',@b1,'Buda',2);
804
SELECT * FROM t15 ORDER BY c1;
808
--echo *** Try to select from slave ****
809
sync_slave_with_master;
810
--replace_column 7 CURRENT_TIMESTAMP
811
SELECT * FROM t15 ORDER BY c1;
813
--echo *** DROP TABLE t15 ***
816
sync_slave_with_master;
818
####################################
819
# - Alter Master and ADD PARTITION #
821
####################################
823
--echo *** Create t16 on slave ***
826
eval CREATE TABLE t16 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
829
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
830
)ENGINE=$engine_type;
832
--echo *** Create t16 on Master ***
834
eval CREATE TABLE t16 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
835
c4 BLOB, c5 CHAR(5))ENGINE=$engine_type;
838
--echo *** Start Slave ***
842
--echo *** Master Data Insert ***
844
set @b1 = 'b1b1b1b1';
845
set @b1 = concat(@b1,@b1);
846
INSERT INTO t16 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
847
(2,2.00,'This Test Should work',@b1,'JOE'),
848
(3,3.00,'If is does not, I will open a bug',@b1,'QA');
849
SELECT * FROM t16 ORDER BY c1;
851
--echo *** Select on Slave ****
852
sync_slave_with_master;
853
--replace_column 7 CURRENT_TIMESTAMP
854
SELECT * FROM t16 ORDER BY c1;
856
--echo *** Add Partition on master ***
858
ALTER TABLE t16 PARTITION BY KEY(c1) PARTITIONS 4;
859
INSERT INTO t16 () VALUES(4,1.00,'Replication Rocks',@b1,'Omer');
860
SHOW CREATE TABLE t16;
862
--echo *** Show table on Slave ****
863
sync_slave_with_master;
864
SHOW CREATE TABLE t16;
866
--echo *** DROP TABLE t16 ***
869
sync_slave_with_master;
871
--echo *** Alter Master End ***
873
############################################
874
### Try to replicate BIGINT to SMALLINT ###
875
### Should Stop Slave ###
876
############################################
878
--echo *** Create t17 on slave ***
881
eval CREATE TABLE t17 (a SMALLINT, b INT PRIMARY KEY, c CHAR(5),
882
d FLOAT DEFAULT '2.00',
883
e CHAR(5) DEFAULT 'TEST2')
886
--echo *** Create t17 on Master ***
888
eval CREATE TABLE t17 (a BIGINT PRIMARY KEY, b INT, c CHAR(10)
889
) ENGINE=$engine_type;
892
--echo *** Start Slave ***
896
--echo *** Master Data Insert ***
899
INSERT INTO t17 () VALUES(9223372036854775807,2,'Kyle, TEX');
901
--echo ********************************************
902
--echo *** Expect slave to fail with Error 1535 ***
903
--echo ********************************************
905
--let $slave_sql_errno= 1535
906
--let $slave_skip_counter= 2
907
--let $show_slave_sql_error= 1
908
--source include/wait_for_slave_sql_error_and_skip.inc
910
--echo ** DROP table t17 ***
913
sync_slave_with_master;