2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
a int unsigned not null auto_increment primary key,
13
a int unsigned, # to force INSERT SELECT to have a certain order
16
INSERT INTO t1 VALUES (NULL, 1);
17
INSERT INTO t1 VALUES (NULL, 2);
18
INSERT INTO t1 VALUES (NULL, 3);
19
INSERT INTO t1 VALUES (NULL, 4);
20
INSERT INTO t2 VALUES (1, 1);
21
INSERT INTO t2 VALUES (2, 2);
22
INSERT INTO t2 VALUES (3, 5);
23
INSERT INTO t2 VALUES (4, 3);
24
INSERT INTO t2 VALUES (5, 4);
25
INSERT INTO t2 VALUES (6, 6);
26
INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
27
SELECT * FROM t1 ORDER BY a;
35
SELECT * FROM t1 ORDER BY a;
45
a int unsigned not null auto_increment primary key,
49
INSERT INTO t1 VALUES (1, 1);
50
INSERT INTO t1 VALUES (2, 2);
51
INSERT INTO t1 VALUES (3, 3);
52
INSERT INTO t1 VALUES (4, 4);
53
INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
54
SELECT * FROM t1 ORDER BY a;
62
SELECT * FROM t1 ORDER BY a;
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.]