1
#################################################
4
# Purpose: To test having extra columns on the slave.
5
##################################################
7
# Some tests in here requre partitioning
9
########### Clean up ################
12
DROP TABLE IF EXISTS t1, t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t14a,t15,t16,t17;
16
#################################################
17
############ Different Table Def Test ###########
18
#################################################
19
# Purpose: To have different table def on the #
20
# master and slave. Most of these tests#
21
# should stop the slave. #
22
#################################################
24
call mtr.add_suppression("Slave: Unknown table 't6' Error_code: 1051");
26
--echo **** Diff Table Def Start ****
28
##############################################
29
### Try to replicate w/ PK on diff columns ###
30
### Should Stop Slave ###
31
##############################################
33
--echo *** On Slave ***
34
sync_slave_with_master;
38
eval CREATE TABLE t1 (a INT, b INT PRIMARY KEY, c CHAR(20),
39
d FLOAT DEFAULT '2.00',
40
e CHAR(4) DEFAULT 'TEST')
43
--echo *** Create t1 on Master ***
45
eval CREATE TABLE t1 (a INT PRIMARY KEY, b INT, c CHAR(10)
46
) ENGINE=$engine_type;
50
--echo *** Start Slave ***
54
--echo *** Master Data Insert ***
57
INSERT INTO t1 () VALUES(1,2,'TEXAS'),(2,1,'AUSTIN'),(3,4,'QA');
58
SELECT * FROM t1 ORDER BY a;
60
--echo *** Select from slave ***
61
sync_slave_with_master;
62
SELECT * FROM t1 ORDER BY a;
64
--echo *** Drop t1 ***
67
sync_slave_with_master;
69
############################################
70
### Try to replicate CHAR(10) to CHAR(5) ###
71
### Should Stop Slave or truncate value ###
72
############################################
75
--echo *** Create t2 on slave ***
78
eval CREATE TABLE t2 (a INT, b INT PRIMARY KEY, c CHAR(5),
79
d FLOAT DEFAULT '2.00',
80
e CHAR(5) DEFAULT 'TEST2')
83
--echo *** Create t2 on Master ***
85
eval CREATE TABLE t2 (a INT PRIMARY KEY, b INT, c CHAR(10)
86
) ENGINE=$engine_type;
89
--echo *** Master Data Insert ***
92
INSERT INTO t2 () VALUES(1,2,'Kyle, TEX'),(2,1,'JOE AUSTIN'),(3,4,'QA TESTING');
93
SELECT * FROM t2 ORDER BY a;
95
--echo *** Start Slave ***
98
--let $slave_sql_errno= 1535
99
--let $show_slave_sql_error= 1
100
--source include/wait_for_slave_sql_error.inc
103
SELECT * FROM t2 ORDER BY a;
111
--echo *** Drop t2 ***
114
sync_slave_with_master;
116
####################################
117
### Try to replicate BLOB to INT ###
118
### Should Stop Slave ###
119
####################################
120
--echo *** Create t3 on slave ***
123
eval CREATE TABLE t3 (a INT, b INT PRIMARY KEY, c CHAR(20),
124
d FLOAT DEFAULT '2.00',
125
e CHAR(5) DEFAULT 'TEST2')
128
--echo *** Create t3 on Master ***
130
eval CREATE TABLE t3 (a BLOB, b INT PRIMARY KEY, c CHAR(20)
131
) ENGINE=$engine_type;
134
--echo *** Start Slave ***
138
--echo *** Master Data Insert ***
142
set @b1 = concat(@b1,@b1);
144
INSERT INTO t3 () VALUES(@b1,2,'Kyle, TEX'),(@b1,1,'JOE AUSTIN'),(@b1,4,'QA TESTING');
146
--echo ********************************************
147
--echo *** Expect slave to fail with Error 1535 ***
148
--echo ********************************************
150
--let $slave_sql_errno= 1535
151
--let $slave_skip_counter= 2
152
--let $show_slave_sql_error= 1
153
--source include/wait_for_slave_sql_error_and_skip.inc
155
--echo *** Drop t3 ***
158
sync_slave_with_master;
160
#####################################################
161
# Columns with different types, more columns at end #
162
# Expect: proper error message (wrong types) #
163
#####################################################
165
--echo *** Create t4 on slave ***
168
eval CREATE TABLE t4 (a INT, b INT PRIMARY KEY, c CHAR(20),
169
d FLOAT DEFAULT '2.00',
170
e CHAR(5) DEFAULT 'TEST2')
173
--echo *** Create t4 on Master ***
175
eval CREATE TABLE t4 (a DECIMAL(8,2), b INT PRIMARY KEY, c CHAR(20)
176
) ENGINE=$engine_type;
179
--echo *** Start Slave ***
183
--echo *** Master Data Insert ***
186
INSERT INTO t4 () VALUES(100.22,2,'Kyle, TEX'),(200.26,1,'JOE AUSTIN'),
187
(30000.22,4,'QA TESTING');
189
--echo ********************************************
190
--echo *** Expect slave to fail with Error 1535 ***
191
--echo ********************************************
193
--let $slave_sql_errno= 1535
194
--let $slave_skip_counter= 2
195
--let $show_slave_sql_error= 1
196
--source include/wait_for_slave_sql_error_and_skip.inc
198
--echo *** Drop t4 ***
201
sync_slave_with_master;
203
#######################################################
204
# Columns with different types, same number of colums #
205
# Expect: Proper error message #
206
#######################################################
208
--echo *** Create t5 on slave ***
211
eval CREATE TABLE t5 (a INT PRIMARY KEY, b CHAR(5),
212
c FLOAT, d INT, e DOUBLE,
213
f DECIMAL(8,2))ENGINE=$engine_type;
215
--echo *** Create t5 on Master ***
217
eval CREATE TABLE t5 (a INT PRIMARY KEY, b VARCHAR(6),
218
c DECIMAL(8,2), d BIT, e BLOB,
219
f FLOAT) ENGINE=$engine_type;
222
--echo *** Start Slave ***
226
--echo *** Master Data Insert ***
229
INSERT INTO t5 () VALUES(1,'Kyle',200.23,1,'b1b1',23.00098),
230
(2,'JOE',300.01,0,'b2b2',1.0000009);
232
--echo ********************************************
233
--echo *** Expect slave to fail with Error 1535 ***
234
--echo ********************************************
236
--let $slave_sql_errno= 1535
237
--let $slave_skip_counter= 2
238
--let $show_slave_sql_error= 1
239
--source include/wait_for_slave_sql_error_and_skip.inc
241
--echo *** Drop t5 ***
244
sync_slave_with_master;
246
#######################################################
247
################## Continued ##########################
248
#######################################################
249
# Columns with different types, same number of colums #
250
# Expect: Proper error message #
251
#######################################################
253
--echo *** Create t6 on slave ***
256
eval CREATE TABLE t6 (a INT PRIMARY KEY, b CHAR(5),
257
c FLOAT, d INT)ENGINE=$engine_type;
259
--echo *** Create t6 on Master ***
261
eval CREATE TABLE t6 (a INT PRIMARY KEY, b VARCHAR(6),
262
c DECIMAL(8,2), d BIT
263
) ENGINE=$engine_type;
266
--echo *** Start Slave ***
270
--echo *** Master Data Insert ***
273
INSERT INTO t6 () VALUES(1,'Kyle',200.23,1),
276
--echo ********************************************
277
--echo *** Expect slave to fail with Error 1535 ***
278
--echo ********************************************
280
--let $slave_sql_errno= 1535
281
--let $show_slave_sql_error= 1
282
--source include/wait_for_slave_sql_error.inc
283
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=3;
286
--echo *** Drop t6 ***
292
#sync_slave_with_master;
295
--echo **** Diff Table Def End ****
297
#######################################
298
#### Extra Column on Slave Testing ####
299
#######################################
300
# Purpose: To test extra colums on the#
302
#######################################
304
--echo **** Extra Colums Start ****
306
##########################################
307
# More columns in slave at end of table, #
308
# added columns have default values #
309
# Expect: it should work, default values #
311
##########################################
313
--echo *** Create t7 on slave ***
316
eval CREATE TABLE t7 (a INT KEY, b BLOB, c CHAR(5),
317
d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
318
e CHAR(20) DEFAULT 'Extra Column Testing')
321
--echo *** Create t7 on Master ***
323
eval CREATE TABLE t7 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
324
) ENGINE=$engine_type;
327
--echo *** Start Slave ***
331
--echo *** Master Data Insert ***
334
set @b1 = concat(@b1,@b1);
335
INSERT INTO t7 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
336
SELECT * FROM t7 ORDER BY a;
338
--echo *** Select from slave ***
339
sync_slave_with_master;
340
SELECT * FROM t7 ORDER BY a;
342
--echo *** Drop t7 ***
345
sync_slave_with_master;
347
###########################################
348
# More columns in slave at end of table, #
349
# added columns do not have default values#
350
# Expect: Proper error message #
351
###########################################
352
# NOTE: This should fail but currently #
354
###########################################
355
--echo *** Create t8 on slave ***
358
eval CREATE TABLE t8 (a INT KEY, b BLOB, c CHAR(5),
359
d TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
360
e INT)ENGINE=$engine_type;
362
--echo *** Create t8 on Master ***
364
eval CREATE TABLE t8 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
365
) ENGINE=$engine_type;
368
--echo *** Start Slave ***
372
--echo *** Master Data Insert ***
374
set @b1 = 'b1b1b1b1';
375
set @b1 = concat(@b1,@b1);
376
INSERT INTO t8 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
378
### Uncomment once bug is fixed
381
#--let $slave_sql_errno= SOMETHING
382
#--let $slave_skip_counter= 2
383
#--let $show_slave_sql_error= 1
384
#--source include/wait_for_slave_sql_error_and_skip.inc
386
--echo *** Drop t8 ***
389
sync_slave_with_master;
391
###########################################
392
############# Continued ###################
393
# More columns in slave at end of table, #
394
# added columns do not have default values#
395
# Expect: Proper error message #
396
###########################################
397
# Bug#22234, Bug#23907 Extra Slave Col is not
398
# erroring on extra col with no default values.
399
###############################################################
400
# Error reaction is up to sql_mode of the slave sql (bug#38173)
401
#--echo *** Create t9 on slave ***
402
# Please, check BUG#47741 to see why you are not testing NDB.
403
if (`SELECT $engine_type != 'NDB'`)
407
eval CREATE TABLE t9 (a INT KEY, b BLOB, c CHAR(5),
413
i blob) ENGINE=$engine_type;
415
--echo *** Create t9 on Master ***
417
eval CREATE TABLE t9 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
418
) ENGINE=$engine_type;
421
--echo *** Start Slave ***
425
--echo *** Master Data Insert ***
427
set @b1 = 'b1b1b1b1';
429
set @b1 = concat(@b1,@b1);
430
INSERT INTO t9 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
432
# the test would stop slave if @@sql_mode for the sql thread
433
# was set to strict. Otherwise, as with this tests setup,
434
# the implicit defaults will be inserted into fields even though
435
# they are declared without DEFAULT clause.
437
sync_slave_with_master;
440
# todo: fix Bug #43992 slave sql thread can't tune own sql_mode ...
441
# and add/restore waiting for stop test
443
#--let $slave_sql_errno= SOMETHING
444
#--let $slave_skip_counter= 2
445
#--let $show_slave_sql_error= 1
446
#--source include/wait_for_slave_sql_error_and_skip.inc
449
#--echo *** Drop t9 ***
452
#sync_slave_with_master;
454
############################################
455
# More columns in slave at middle of table #
456
# Expect: Proper error message #
457
############################################
458
--echo *** Create t10 on slave ***
461
eval CREATE TABLE t10 (a INT KEY, b BLOB, f DOUBLE DEFAULT '233',
462
c CHAR(5), e INT DEFAULT '1')ENGINE=$engine_type;
464
--echo *** Create t10 on Master ***
466
eval CREATE TABLE t10 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
467
) ENGINE=$engine_type;
470
--echo *** Start Slave ***
474
--echo *** Master Data Insert ***
476
set @b1 = 'b1b1b1b1';
477
set @b1 = concat(@b1,@b1);
478
INSERT INTO t10 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
480
--echo ********************************************
481
--echo *** Expect slave to fail with Error 1535 ***
482
--echo ********************************************
484
--let $slave_sql_errno= 1535
485
--let $slave_skip_counter= 2
486
--let $show_slave_sql_error= 1
487
--source include/wait_for_slave_sql_error_and_skip.inc
489
--echo *** Drop t10 ***
492
sync_slave_with_master;
494
############################################
495
############## Continued ###################
496
############################################
497
# More columns in slave at middle of table #
498
# Expect: Proper error message #
499
############################################
500
--echo *** Create t11 on slave ***
503
eval CREATE TABLE t11 (a INT KEY, b BLOB, f TEXT,
504
c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE=$engine_type;
506
--echo *** Create t11 on Master ***
508
eval CREATE TABLE t11 (a INT PRIMARY KEY, b BLOB, c VARCHAR(254)
509
) ENGINE=$engine_type;
512
--echo *** Start Slave ***
516
--echo *** Master Data Insert ***
518
set @b1 = 'b1b1b1b1';
519
set @b1 = concat(@b1,@b1);
520
INSERT INTO t11 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
522
--echo ********************************************
523
--echo *** Expect slave to fail with Error 1535 ***
524
--echo ********************************************
526
--let $slave_sql_errno= 1535
527
--let $slave_skip_counter= 2
528
--let $show_slave_sql_error= 1
529
--source include/wait_for_slave_sql_error_and_skip.inc
531
--echo *** Drop t11 ***
534
sync_slave_with_master;
536
############################################
537
############## Continued ###################
538
############################################
539
# More columns in slave at middle of table #
540
# Expect: This one should pass blob-text #
541
############################################
542
--echo *** Create t12 on slave ***
545
eval CREATE TABLE t12 (a INT KEY, b BLOB, f TEXT,
546
c CHAR(5) DEFAULT 'test', e INT DEFAULT '1')ENGINE=$engine_type;
548
--echo *** Create t12 on Master ***
550
eval CREATE TABLE t12 (a INT PRIMARY KEY, b BLOB, c BLOB
551
) ENGINE=$engine_type;
554
--echo *** Start Slave ***
558
--echo *** Master Data Insert ***
560
set @b1 = 'b1b1b1b1';
561
set @b1 = concat(@b1,@b1);
562
INSERT INTO t12 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
563
SELECT * FROM t12 ORDER BY a;
565
--echo *** Select on Slave ***
566
sync_slave_with_master;
567
SELECT * FROM t12 ORDER BY a;
569
--echo *** Drop t12 ***
572
sync_slave_with_master;
574
--echo **** Extra Colums End ****
576
###############################
577
# BUG#22177 CURRENT_TIMESTAMP #
578
# Sould work with ^ #
579
###############################
580
--echo *** BUG 22177 Start ***
581
--echo *** Create t13 on slave ***
584
eval CREATE TABLE t13 (a INT KEY, b BLOB, c CHAR(5),
586
e TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
587
)ENGINE=$engine_type;
589
--echo *** Create t13 on Master ***
591
eval CREATE TABLE t13 (a INT PRIMARY KEY, b BLOB, c CHAR(5)
592
) ENGINE=$engine_type;
595
--echo *** Start Slave ***
599
--echo *** Master Data Insert ***
601
set @b1 = 'b1b1b1b1';
602
set @b1 = concat(@b1,@b1);
603
INSERT INTO t13 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA');
604
SELECT * FROM t13 ORDER BY a;
606
--echo *** Select on Slave ****
607
sync_slave_with_master;
608
--replace_column 5 CURRENT_TIMESTAMP
609
SELECT * FROM t13 ORDER BY a;
611
--echo *** Drop t13 ***
614
sync_slave_with_master;
616
--echo *** 22117 END ***
618
##############################
619
# ALTER MASTER TABLE TESTING #
620
##############################
622
--echo *** Alter Master Table Testing Start ***
624
####################################################
625
# - Alter Master adding columns at middle of table #
626
# Expect: columns added #
627
####################################################
629
--echo *** Create t14 on slave ***
632
eval CREATE TABLE t14 (c1 INT KEY, c4 BLOB, c5 CHAR(5),
634
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
635
)ENGINE=$engine_type;
637
--echo *** Create t14 on Master ***
639
eval CREATE TABLE t14 (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
640
) ENGINE=$engine_type;
643
--echo *** Start Slave ***
647
--echo *** Master Data Insert ***
649
ALTER TABLE t14 ADD COLUMN c2 DECIMAL(8,2) AFTER c1;
650
ALTER TABLE t14 ADD COLUMN c3 TEXT AFTER c2;
651
set @b1 = 'b1b1b1b1';
652
set @b1 = concat(@b1,@b1);
653
INSERT INTO t14 () VALUES(1,1.00,'Replication Testing Extra Col',@b1,'Kyle'),
654
(2,2.00,'This Test Should work',@b1,'JOE'),
655
(3,3.00,'If is does not, I will open a bug',@b1,'QA');
656
SELECT * FROM t14 ORDER BY c1;
659
--echo *** Select on Slave ****
660
sync_slave_with_master;
661
--replace_column 7 CURRENT_TIMESTAMP
662
SELECT * FROM t14 ORDER BY c1;
664
####################################################
665
# - Alter Master drop column at end of table #
666
# Expect: column dropped #
667
####################################################
669
--echo *** Create t14a on slave ***
672
eval CREATE TABLE t14a (c1 INT KEY, c4 BLOB, c5 CHAR(5),
674
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
675
)ENGINE=$engine_type;
677
--echo *** Create t14a on Master ***
679
eval CREATE TABLE t14a (c1 INT PRIMARY KEY, c4 BLOB, c5 CHAR(5)
680
) ENGINE=$engine_type;
683
--echo *** Start Slave ***
687
--echo *** Master Data Insert ***
689
set @b1 = 'b1b1b1b1';
690
set @b1 = concat(@b1,@b1);
691
INSERT INTO t14a () VALUES(1,@b1,'Kyle'),
695
SELECT * FROM t14a ORDER BY c1;
696
--echo *** Select on Slave ****
697
sync_slave_with_master;
698
--replace_column 5 CURRENT_TIMESTAMP
699
SELECT * FROM t14a ORDER BY c1;
703
--echo *** Master Drop c5 ***
705
ALTER TABLE t14a DROP COLUMN c5;
708
--echo *** Start Slave ***
712
--echo *** Master Data Insert ***
714
set @b1 = 'b1b1b1b1';
715
set @b1 = concat(@b1,@b1);
717
INSERT INTO t14a () VALUES(4,@b1),
720
SELECT * FROM t14a ORDER BY c1;
722
--echo *** Select on Slave ****
723
sync_slave_with_master;
724
--replace_column 5 CURRENT_TIMESTAMP
725
SELECT * FROM t14a ORDER BY c1;
727
####################################################
728
# - Alter Master Dropping columns from the middle. #
729
# Expect: columns dropped #
730
####################################################
732
--echo *** connect to master and drop columns ***
734
ALTER TABLE t14 DROP COLUMN c2;
735
ALTER TABLE t14 DROP COLUMN c4;
736
--echo *** Select from Master ***
737
SELECT * FROM t14 ORDER BY c1;
739
--echo *** Select from Slave ***
740
sync_slave_with_master;
741
--replace_column 5 CURRENT_TIMESTAMP
742
SELECT * FROM t14 ORDER BY c1;
744
--echo *** Drop t14 ***
747
sync_slave_with_master;
749
##############################################################
750
# - Alter Master adding columns that already exist on slave. #
751
# Expect: proper error message #
752
##############################################################
754
--echo *** Create t15 on slave ***
757
eval CREATE TABLE t15 (c1 INT KEY, c2 DECIMAL(8,2), c3 TEXT,
760
c7 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
761
)ENGINE=$engine_type;
763
--echo *** Create t15 on Master ***
765
eval CREATE TABLE t15 (c1 INT PRIMARY KEY, c2 DECIMAL(8,2), c3 TEXT,
766
c4 BLOB, c5 CHAR(5)) ENGINE=$engine_type;
769
--echo *** Start Slave ***
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;
919
DROP TABLE IF EXISTS t1, t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t14a,t15,t16,t17;
920
sync_slave_with_master;