Debian Codegraph @

mysql-test/suite/engines/funcs/r/re_number_select.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
3 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT);
4 INSERT INTO t1 (c1,c2) VALUES(0,0),(1,1),(2,2),(3,3),(8,8);
5 INSERT INTO t2 (c1,c2) VALUES(0,0),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9);
6 REPLACE INTO t1 SELECT * FROM t2;
7 SELECT * FROM t1 ORDER BY c1;
8 c1 c2
9 0 0
10 1 1
11 2 2
12 3 3
13 4 4
14 5 5
15 6 6
16 7 7
17 8 8
18 9 9
19 DROP TABLE t1, t2;