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;