478
470
[expecting slave to replicate correctly]
479
471
INSERT INTO t1 VALUES (1, "", 1);
480
472
INSERT INTO t1 VALUES (2, repeat(_utf8'a', 16), 2);
481
Comparing tables master:test.t1 and slave:test.t1
473
include/diff_tables.inc [master:t1, slave:t1]
482
474
[expecting slave to replicate correctly]
483
475
INSERT INTO t2 VALUES (1, "", 1);
484
476
INSERT INTO t2 VALUES (2, repeat(_utf8'a', 16), 2);
485
Comparing tables master:test.t2 and slave:test.t2
477
include/diff_tables.inc [master:t2, slave:t2]
486
478
[expecting slave to stop]
487
479
INSERT INTO t3 VALUES (1, "", 1);
488
480
INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2);
489
Last_SQL_Error = Table definition on master and slave does not match: Column 1 size mismatch - master has size 384, test.t3 on slave has size 49. Master's column size should be <= the slave's column size.
481
call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535");
482
call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table test.t1.* Error_code: 1032");
483
include/wait_for_slave_sql_error.inc [errno=1535]
484
Last_SQL_Error = 'Table definition on master and slave does not match: Column 1 size mismatch - master has size 384, test.t3 on slave has size 49. Master's column size should be <= the slave's column size.'
485
include/rpl_reset.inc
494
486
[expecting slave to replicate correctly]
495
487
INSERT INTO t4 VALUES (1, "", 1);
496
488
INSERT INTO t4 VALUES (2, repeat(_utf8'a', 128), 2);
497
Comparing tables master:test.t4 and slave:test.t4
489
include/diff_tables.inc [master:t4, slave:t4]
498
490
[expecting slave to stop]
499
491
INSERT INTO t5 VALUES (1, "", 1);
500
492
INSERT INTO t5 VALUES (2, repeat(_utf8'a', 255), 2);
501
Last_SQL_Error = Table definition on master and slave does not match: Column 1 size mismatch - master has size 765, test.t5 on slave has size 49. Master's column size should be <= the slave's column size.
493
include/wait_for_slave_sql_error.inc [errno=1535]
494
Last_SQL_Error = 'Table definition on master and slave does not match: Column 1 size mismatch - master has size 765, test.t5 on slave has size 49. Master's column size should be <= the slave's column size.'
495
include/rpl_reset.inc
506
496
[expecting slave to stop]
507
497
INSERT INTO t6 VALUES (1, "", 1);
508
498
INSERT INTO t6 VALUES (2, repeat(_utf8'a', 255), 2);
509
Last_SQL_Error = Table definition on master and slave does not match: Column 1 size mismatch - master has size 765, test.t6 on slave has size 385. Master's column size should be <= the slave's column size.
499
include/wait_for_slave_sql_error.inc [errno=1535]
500
Last_SQL_Error = 'Table definition on master and slave does not match: Column 1 size mismatch - master has size 765, test.t6 on slave has size 385. Master's column size should be <= the slave's column size.'
501
include/rpl_reset.inc
514
502
[expecting slave to replicate correctly]
515
503
INSERT INTO t7 VALUES (1, "", 1);
516
504
INSERT INTO t7 VALUES (2, repeat(_utf8'a', 255), 2);
517
Comparing tables master:test.t7 and slave:test.t7
505
include/diff_tables.inc [master:t7, slave:t7]
518
506
drop table t1, t2, t3, t4, t5, t6, t7;
519
507
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE='INNODB' ;
520
508
INSERT INTO t1 VALUES (1), (2), (3);
521
509
UPDATE t1 SET a = 10;
522
510
ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
523
511
INSERT INTO t1 VALUES (4);
524
Comparing tables master:test.t1 and slave:test.t1
512
include/diff_tables.inc [master:t1, slave:t1]
526
514
DROP TABLE IF EXISTS t1, t2;
527
515
CREATE TABLE t1 (