479
470
[expecting slave to replicate correctly]
480
471
INSERT INTO t1 VALUES (1, "", 1);
481
472
INSERT INTO t1 VALUES (2, repeat(_utf8'a', 16), 2);
482
Comparing tables master:test.t1 and slave:test.t1
473
include/diff_tables.inc [master:t1, slave:t1]
483
474
[expecting slave to replicate correctly]
484
475
INSERT INTO t2 VALUES (1, "", 1);
485
476
INSERT INTO t2 VALUES (2, repeat(_utf8'a', 16), 2);
486
Comparing tables master:test.t2 and slave:test.t2
477
include/diff_tables.inc [master:t2, slave:t2]
487
478
[expecting slave to stop]
488
479
INSERT INTO t3 VALUES (1, "", 1);
489
480
INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2);
491
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
include/wait_for_slave_sql_error.inc [errno=1535]
482
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.'
483
include/rpl_reset.inc
496
484
[expecting slave to replicate correctly]
497
485
INSERT INTO t4 VALUES (1, "", 1);
498
486
INSERT INTO t4 VALUES (2, repeat(_utf8'a', 128), 2);
499
Comparing tables master:test.t4 and slave:test.t4
487
include/diff_tables.inc [master:t4, slave:t4]
500
488
[expecting slave to stop]
501
489
INSERT INTO t5 VALUES (1, "", 1);
502
490
INSERT INTO t5 VALUES (2, repeat(_utf8'a', 255), 2);
504
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.
491
include/wait_for_slave_sql_error.inc [errno=1535]
492
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/rpl_reset.inc
509
494
[expecting slave to stop]
510
495
INSERT INTO t6 VALUES (1, "", 1);
511
496
INSERT INTO t6 VALUES (2, repeat(_utf8'a', 255), 2);
513
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.
497
include/wait_for_slave_sql_error.inc [errno=1535]
498
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/rpl_reset.inc
518
500
[expecting slave to replicate correctly]
519
501
INSERT INTO t7 VALUES (1, "", 1);
520
502
INSERT INTO t7 VALUES (2, repeat(_utf8'a', 255), 2);
521
Comparing tables master:test.t7 and slave:test.t7
503
include/diff_tables.inc [master:t7, slave:t7]
522
504
drop table t1, t2, t3, t4, t5, t6, t7;
523
505
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE='NDB' ;
524
506
INSERT INTO t1 VALUES (1), (2), (3);
525
507
UPDATE t1 SET a = 10;
526
508
ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
527
509
INSERT INTO t1 VALUES (4);
528
Comparing tables master:test.t1 and slave:test.t1
510
include/diff_tables.inc [master:t1, slave:t1]
530
512
DROP TABLE IF EXISTS t1, t2;
531
513
CREATE TABLE t1 (