Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
3 CREATE TABLE t2(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
4 INSERT INTO t1 (c1) VALUES(1),(2),(3),(4),(5);
5 INSERT INTO t2 SELECT * FROM t1;
6 SELECT * FROM t2 ORDER BY c1;
7 c1
8 1
9 2
10 3
11 4
12 5
13 TRUNCATE TABLE t2;
14 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
15 SELECT * FROM t2 ORDER BY c1;
16 c1
17 3
18 4
19 5
20 TRUNCATE TABLE t2;
21 DROP TABLE t1,t2;
22 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
23 CREATE TABLE t2(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
24 INSERT INTO t1 (c1) VALUES(1),(2),(3),(4),(5);
25 INSERT INTO t2 SELECT * FROM t1;
26 SELECT * FROM t2 ORDER BY c1;
27 c1
28 1
29 2
30 3
31 4
32 5
33 TRUNCATE TABLE t2;
34 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
35 SELECT * FROM t2 ORDER BY c1;
36 c1
37 3
38 4
39 5
40 TRUNCATE TABLE t2;
41 DROP TABLE t1,t2;
42 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
43 CREATE TABLE t2(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
44 INSERT INTO t1 (c1) VALUES(1),(2),(3),(4),(5);
45 INSERT INTO t2 SELECT * FROM t1;
46 SELECT * FROM t2 ORDER BY c1;
47 c1
48 1
49 2
50 3
51 4
52 5
53 TRUNCATE TABLE t2;
54 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
55 SELECT * FROM t2 ORDER BY c1;
56 c1
57 3
58 4
59 5
60 TRUNCATE TABLE t2;
61 DROP TABLE t1,t2;
62 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
63 CREATE TABLE t2(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
64 INSERT INTO t1 (c1) VALUES(1),(2),(3),(4),(5);
65 INSERT INTO t2 SELECT * FROM t1;
66 SELECT * FROM t2 ORDER BY c1;
67 c1
68 1
69 2
70 3
71 4
72 5
73 TRUNCATE TABLE t2;
74 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
75 SELECT * FROM t2 ORDER BY c1;
76 c1
77 3
78 4
79 5
80 TRUNCATE TABLE t2;
81 DROP TABLE t1,t2;
82 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
83 CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
84 INSERT INTO t1 (c1) VALUES(1),(2),(3),(4),(5);
85 INSERT INTO t2 SELECT * FROM t1;
86 SELECT * FROM t2 ORDER BY c1;
87 c1
88 1
89 2
90 3
91 4
92 5
93 TRUNCATE TABLE t2;
94 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
95 SELECT * FROM t2 ORDER BY c1;
96 c1
97 3
98 4
99 5
100 TRUNCATE TABLE t2;
101 DROP TABLE t1,t2;
102 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
103 CREATE TABLE t2(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
104 INSERT INTO t1 (c1) VALUES(1),(2),(3),(4),(5);
105 INSERT INTO t2 SELECT * FROM t1;
106 SELECT * FROM t2 ORDER BY c1;
107 c1
108 1
109 2
110 3
111 4
112 5
113 TRUNCATE TABLE t2;
114 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
115 SELECT * FROM t2 ORDER BY c1;
116 c1
117 3
118 4
119 5
120 TRUNCATE TABLE t2;
121 DROP TABLE t1,t2;