Debian Codegraph @

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