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
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
494
484
[expecting slave to replicate correctly]
495
485
INSERT INTO t4 VALUES (1, "", 1);
496
486
INSERT INTO t4 VALUES (2, repeat(_utf8'a', 128), 2);
497
Comparing tables master:test.t4 and slave:test.t4
487
include/diff_tables.inc [master:t4, slave:t4]
498
488
[expecting slave to stop]
499
489
INSERT INTO t5 VALUES (1, "", 1);
500
490
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.
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
506
494
[expecting slave to stop]
507
495
INSERT INTO t6 VALUES (1, "", 1);
508
496
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.
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
514
500
[expecting slave to replicate correctly]
515
501
INSERT INTO t7 VALUES (1, "", 1);
516
502
INSERT INTO t7 VALUES (2, repeat(_utf8'a', 255), 2);
517
Comparing tables master:test.t7 and slave:test.t7
503
include/diff_tables.inc [master:t7, slave:t7]
518
504
drop table t1, t2, t3, t4, t5, t6, t7;
519
505
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE='NDB' ;
520
506
INSERT INTO t1 VALUES (1), (2), (3);
521
507
UPDATE t1 SET a = 10;
522
508
ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
523
509
INSERT INTO t1 VALUES (4);
524
Comparing tables master:test.t1 and slave:test.t1
510
include/diff_tables.inc [master:t1, slave:t1]
526
512
DROP TABLE IF EXISTS t1, t2;
527
513
CREATE TABLE t1 (