1include/master-slave.inc
2[connection master]
3DROP TABLE IF EXISTS t1, t2;
4CREATE TABLE t1 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
5CREATE TABLE t2 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
6INSERT INTO t1 VALUES(1, repeat('abc',10));
7INSERT INTO t1 VALUES(2, repeat('def',200));
8INSERT INTO t1 VALUES(3, repeat('ghi',3000));
9INSERT INTO t2 VALUES(1, repeat('abc',10));
10INSERT INTO t2 VALUES(2, repeat('def',200));
11INSERT INTO t2 VALUES(3, repeat('ghi',3000));
12SHOW TABLES;
13Tables_in_test
14t1
15SELECT COUNT(*) FROM t1;
16COUNT(*)
173
18INSERT INTO t1 VALUES (3, repeat('bad',1));
19ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
20INSERT INTO t1 VALUES (3, repeat('bad too',1));
21ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
22DROP TABLE IF EXISTS t1, t2;
23include/rpl_end.inc
24