1 include/master-slave.inc
4 a int unsigned not null auto_increment primary key,
9 a int unsigned, # to force INSERT SELECT to have a certain order
12 INSERT INTO t1 VALUES (NULL, 1);
13 INSERT INTO t1 VALUES (NULL, 2);
14 INSERT INTO t1 VALUES (NULL, 3);
15 INSERT INTO t1 VALUES (NULL, 4);
16 INSERT INTO t2 VALUES (1, 1);
17 INSERT INTO t2 VALUES (2, 2);
18 INSERT INTO t2 VALUES (3, 5);
19 INSERT INTO t2 VALUES (4, 3);
20 INSERT INTO t2 VALUES (5, 4);
21 INSERT INTO t2 VALUES (6, 6);
22 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
23 include/assert.inc [Count of elements in t1 should be 6.]
24 include/diff_tables.inc [master:test.t1 , slave:test.t1]
25 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
26 include/assert.inc [Count of elements in t1 should be 6.]
27 include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]
30 a int unsigned not null auto_increment primary key,
35 a int unsigned, # to force INSERT SELECT to have a certain order
38 INSERT INTO t1 VALUES (NULL, 1);
39 INSERT INTO t1 VALUES (NULL, 2);
40 INSERT INTO t1 VALUES (NULL, 3);
41 INSERT INTO t1 VALUES (NULL, 4);
42 INSERT INTO t2 VALUES (1, 1);
43 INSERT INTO t2 VALUES (2, 2);
44 INSERT INTO t2 VALUES (3, 5);
45 INSERT INTO t2 VALUES (4, 3);
46 INSERT INTO t2 VALUES (5, 4);
47 INSERT INTO t2 VALUES (6, 6);
48 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
49 include/assert.inc [Count of elements in t1 should be 6.]
50 include/diff_tables.inc [master:test.t1 , slave:test.t1]
51 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
52 include/assert.inc [Count of elements in t1 should be 6.]
53 include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]