2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP TABLE IF EXISTS t1;
8
**** Testing WL#3228 changes. ****
9
*** Create "wider" table on slave ***
10
Checking MYSQL_TYPE_NEWDECIMAL fields
11
DROP TABLE IF EXISTS t1;
13
Note 1051 Unknown table 't1'
16
CREATE TABLE t1 (a DECIMAL(5,2));
17
CREATE TABLE t1 (a DECIMAL(20, 10));
19
INSERT INTO t1 VALUES (901251.90125);
27
Master_Log_File master-bin.000001
31
Relay_Master_Log_File master-bin.000001
37
Replicate_Ignore_Table #
38
Replicate_Wild_Do_Table
39
Replicate_Wild_Ignore_Table
41
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 10, test.t1 on slave has size 3. Master's column size should be <= the slave's column size.
54
Seconds_Behind_Master #
55
Master_SSL_Verify_Server_Cert No
59
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 10, test.t1 on slave has size 3. Master's column size should be <= the slave's column size.
60
SELECT COUNT(*) FROM t1;
67
DROP TABLE IF EXISTS t1;
70
CREATE TABLE t1 (a DECIMAL(27, 9));
71
CREATE TABLE t1 (a DECIMAL(27, 18));
73
INSERT INTO t1 VALUES (901251.90125);
81
Master_Log_File master-bin.000001
85
Relay_Master_Log_File master-bin.000001
91
Replicate_Ignore_Table #
92
Replicate_Wild_Do_Table
93
Replicate_Wild_Ignore_Table
95
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 12, test.t1 on slave has size 12. Master's column size should be <= the slave's column size.
102
Master_SSL_Allowed No
108
Seconds_Behind_Master #
109
Master_SSL_Verify_Server_Cert No
113
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 12, test.t1 on slave has size 12. Master's column size should be <= the slave's column size.
114
SELECT COUNT(*) FROM t1;
121
DROP TABLE IF EXISTS t1;
124
CREATE TABLE t1 (a NUMERIC(5,2));
125
CREATE TABLE t1 (a NUMERIC(20, 10));
127
INSERT INTO t1 VALUES (901251.90125);
131
Master_Host 127.0.0.1
135
Master_Log_File master-bin.000001
136
Read_Master_Log_Pos #
139
Relay_Master_Log_File master-bin.000001
145
Replicate_Ignore_Table #
146
Replicate_Wild_Do_Table
147
Replicate_Wild_Ignore_Table
149
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 10, test.t1 on slave has size 3. Master's column size should be <= the slave's column size.
151
Exec_Master_Log_Pos #
156
Master_SSL_Allowed No
162
Seconds_Behind_Master #
163
Master_SSL_Verify_Server_Cert No
167
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 10, test.t1 on slave has size 3. Master's column size should be <= the slave's column size.
168
SELECT COUNT(*) FROM t1;
175
Checking MYSQL_TYPE_FLOAT fields
176
DROP TABLE IF EXISTS t1;
179
CREATE TABLE t1 (a FLOAT(20));
180
CREATE TABLE t1 (a FLOAT(47));
182
INSERT INTO t1 VALUES (901251.90125);
186
Master_Host 127.0.0.1
190
Master_Log_File master-bin.000001
191
Read_Master_Log_Pos #
194
Relay_Master_Log_File master-bin.000001
200
Replicate_Ignore_Table #
201
Replicate_Wild_Do_Table
202
Replicate_Wild_Ignore_Table
204
Last_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 5, test.t1 has type 4
206
Exec_Master_Log_Pos #
211
Master_SSL_Allowed No
217
Seconds_Behind_Master #
218
Master_SSL_Verify_Server_Cert No
222
Last_SQL_Error Table definition on master and slave does not match: Column 0 type mismatch - received type 5, test.t1 has type 4
223
SELECT COUNT(*) FROM t1;
230
Checking MYSQL_TYPE_BIT fields
231
DROP TABLE IF EXISTS t1;
234
CREATE TABLE t1 (a BIT(5));
235
CREATE TABLE t1 (a BIT(64));
237
INSERT INTO t1 VALUES (B'10101');
241
Master_Host 127.0.0.1
245
Master_Log_File master-bin.000001
246
Read_Master_Log_Pos #
249
Relay_Master_Log_File master-bin.000001
255
Replicate_Ignore_Table #
256
Replicate_Wild_Do_Table
257
Replicate_Wild_Ignore_Table
259
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 8, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
261
Exec_Master_Log_Pos #
266
Master_SSL_Allowed No
272
Seconds_Behind_Master #
273
Master_SSL_Verify_Server_Cert No
277
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 8, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
278
SELECT COUNT(*) FROM t1;
285
DROP TABLE IF EXISTS t1;
288
CREATE TABLE t1 (a BIT(11));
289
CREATE TABLE t1 (a BIT(12));
291
INSERT INTO t1 VALUES (B'10101');
295
Master_Host 127.0.0.1
299
Master_Log_File master-bin.000001
300
Read_Master_Log_Pos #
303
Relay_Master_Log_File master-bin.000001
309
Replicate_Ignore_Table #
310
Replicate_Wild_Do_Table
311
Replicate_Wild_Ignore_Table
313
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2, test.t1 on slave has size 2. Master's column size should be <= the slave's column size.
315
Exec_Master_Log_Pos #
320
Master_SSL_Allowed No
326
Seconds_Behind_Master #
327
Master_SSL_Verify_Server_Cert No
331
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2, test.t1 on slave has size 2. Master's column size should be <= the slave's column size.
332
SELECT COUNT(*) FROM t1;
339
Checking MYSQL_TYPE_SET fields
340
DROP TABLE IF EXISTS t1;
343
CREATE TABLE t1 (a SET('4'));
344
CREATE TABLE t1 (a SET('1','2','3','4','5','6','7','8','9'));
346
INSERT INTO t1 VALUES ('4');
350
Master_Host 127.0.0.1
354
Master_Log_File master-bin.000001
355
Read_Master_Log_Pos #
358
Relay_Master_Log_File master-bin.000001
364
Replicate_Ignore_Table #
365
Replicate_Wild_Do_Table
366
Replicate_Wild_Ignore_Table
368
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
370
Exec_Master_Log_Pos #
375
Master_SSL_Allowed No
381
Seconds_Behind_Master #
382
Master_SSL_Verify_Server_Cert No
386
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
387
SELECT COUNT(*) FROM t1;
394
Checking MYSQL_TYPE_STRING fields
395
DROP TABLE IF EXISTS t1;
398
CREATE TABLE t1 (a CHAR(10));
399
CREATE TABLE t1 (a CHAR(20));
401
INSERT INTO t1 VALUES ('This is a test.');
405
Master_Host 127.0.0.1
409
Master_Log_File master-bin.000001
410
Read_Master_Log_Pos #
413
Relay_Master_Log_File master-bin.000001
419
Replicate_Ignore_Table #
420
Replicate_Wild_Do_Table
421
Replicate_Wild_Ignore_Table
423
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 20, test.t1 on slave has size 11. Master's column size should be <= the slave's column size.
425
Exec_Master_Log_Pos #
430
Master_SSL_Allowed No
436
Seconds_Behind_Master #
437
Master_SSL_Verify_Server_Cert No
441
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 20, test.t1 on slave has size 11. Master's column size should be <= the slave's column size.
442
SELECT COUNT(*) FROM t1;
449
Checking MYSQL_TYPE_ENUM fields
450
DROP TABLE IF EXISTS t1;
453
CREATE TABLE t1 (a ENUM('44','54'));
454
CREATE TABLE t1 (a ENUM(
455
'01','02','03','04','05','06','07','08','09',
456
'11','12','13','14','15','16','17','18','19',
457
'21','22','23','24','25','26','27','28','29',
458
'31','32','33','34','35','36','37','38','39',
459
'41','42','43','44','45','46','47','48','49',
460
'51','52','53','54','55','56','57','58','59',
461
'61','62','63','64','65','66','67','68','69',
462
'71','72','73','74','75','76','77','78','79',
463
'81','82','83','84','85','86','87','88','89',
464
'91','92','93','94','95','96','97','98','99',
465
'101','102','103','104','105','106','107','108','109',
466
'111','112','113','114','115','116','117','118','119',
467
'121','122','123','124','125','126','127','128','129',
468
'131','132','133','134','135','136','137','138','139',
469
'141','142','143','144','145','146','147','148','149',
470
'151','152','153','154','155','156','157','158','159',
471
'161','162','163','164','165','166','167','168','169',
472
'171','172','173','174','175','176','177','178','179',
473
'181','182','183','184','185','186','187','188','189',
474
'191','192','193','194','195','196','197','198','199',
475
'201','202','203','204','205','206','207','208','209',
476
'211','212','213','214','215','216','217','218','219',
477
'221','222','223','224','225','226','227','228','229',
478
'231','232','233','234','235','236','237','238','239',
479
'241','242','243','244','245','246','247','248','249',
480
'251','252','253','254','255','256','257','258','259',
481
'261','262','263','264','265','266','267','268','269',
482
'271','272','273','274','275','276','277','278','279',
483
'281','282','283','284','285','286','287','288','289',
484
'291','292','293','294','295','296','297','298','299'
487
INSERT INTO t1 VALUES ('44');
491
Master_Host 127.0.0.1
495
Master_Log_File master-bin.000001
496
Read_Master_Log_Pos #
499
Relay_Master_Log_File master-bin.000001
505
Replicate_Ignore_Table #
506
Replicate_Wild_Do_Table
507
Replicate_Wild_Ignore_Table
509
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
511
Exec_Master_Log_Pos #
516
Master_SSL_Allowed No
522
Seconds_Behind_Master #
523
Master_SSL_Verify_Server_Cert No
527
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
528
SELECT COUNT(*) FROM t1;
535
Checking MYSQL_TYPE_VARCHAR fields
536
DROP TABLE IF EXISTS t1;
539
CREATE TABLE t1 (a VARCHAR(100));
540
CREATE TABLE t1 (a VARCHAR(2000));
542
INSERT INTO t1 VALUES ('This is a test.');
546
Master_Host 127.0.0.1
550
Master_Log_File master-bin.000001
551
Read_Master_Log_Pos #
554
Relay_Master_Log_File master-bin.000001
560
Replicate_Ignore_Table #
561
Replicate_Wild_Do_Table
562
Replicate_Wild_Ignore_Table
564
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2000, test.t1 on slave has size 100. Master's column size should be <= the slave's column size.
566
Exec_Master_Log_Pos #
571
Master_SSL_Allowed No
577
Seconds_Behind_Master #
578
Master_SSL_Verify_Server_Cert No
582
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2000, test.t1 on slave has size 100. Master's column size should be <= the slave's column size.
583
SELECT COUNT(*) FROM t1;
590
DROP TABLE IF EXISTS t1;
593
CREATE TABLE t1 (a VARCHAR(10));
594
CREATE TABLE t1 (a VARCHAR(200));
596
INSERT INTO t1 VALUES ('This is a test.');
600
Master_Host 127.0.0.1
604
Master_Log_File master-bin.000001
605
Read_Master_Log_Pos #
608
Relay_Master_Log_File master-bin.000001
614
Replicate_Ignore_Table #
615
Replicate_Wild_Do_Table
616
Replicate_Wild_Ignore_Table
618
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 200, test.t1 on slave has size 10. Master's column size should be <= the slave's column size.
620
Exec_Master_Log_Pos #
625
Master_SSL_Allowed No
631
Seconds_Behind_Master #
632
Master_SSL_Verify_Server_Cert No
636
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 200, test.t1 on slave has size 10. Master's column size should be <= the slave's column size.
637
SELECT COUNT(*) FROM t1;
644
DROP TABLE IF EXISTS t1;
647
CREATE TABLE t1 (a VARCHAR(1000));
648
CREATE TABLE t1 (a VARCHAR(2000));
650
INSERT INTO t1 VALUES ('This is a test.');
654
Master_Host 127.0.0.1
658
Master_Log_File master-bin.000001
659
Read_Master_Log_Pos #
662
Relay_Master_Log_File master-bin.000001
668
Replicate_Ignore_Table #
669
Replicate_Wild_Do_Table
670
Replicate_Wild_Ignore_Table
672
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2000, test.t1 on slave has size 1000. Master's column size should be <= the slave's column size.
674
Exec_Master_Log_Pos #
679
Master_SSL_Allowed No
685
Seconds_Behind_Master #
686
Master_SSL_Verify_Server_Cert No
690
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 2000, test.t1 on slave has size 1000. Master's column size should be <= the slave's column size.
691
SELECT COUNT(*) FROM t1;
698
Checking MYSQL_TYPE_BLOB fields
699
DROP TABLE IF EXISTS t1;
702
CREATE TABLE t1 (a TINYBLOB);
703
CREATE TABLE t1 (a LONGBLOB);
705
INSERT INTO t1 VALUES ('This is a test.');
709
Master_Host 127.0.0.1
713
Master_Log_File master-bin.000001
714
Read_Master_Log_Pos #
717
Relay_Master_Log_File master-bin.000001
723
Replicate_Ignore_Table #
724
Replicate_Wild_Do_Table
725
Replicate_Wild_Ignore_Table
727
Last_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 4, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
729
Exec_Master_Log_Pos #
734
Master_SSL_Allowed No
740
Seconds_Behind_Master #
741
Master_SSL_Verify_Server_Cert No
745
Last_SQL_Error Table definition on master and slave does not match: Column 0 size mismatch - master has size 4, test.t1 on slave has size 1. Master's column size should be <= the slave's column size.
746
SELECT COUNT(*) FROM t1;
754
DROP TABLE IF EXISTS t1;