Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_insert_select.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
5 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
6 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5);
7 INSERT INTO t2 SELECT * FROM t1;
8 SELECT * FROM t2 ORDER BY c1;
9 TRUNCATE TABLE t2;
10 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
11 SELECT * FROM t2 ORDER BY c1;
12 TRUNCATE TABLE t2;
13 DROP TABLE t1,t2;
14 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
15 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
16 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5);
17 INSERT INTO t2 SELECT * FROM t1;
18 SELECT * FROM t2 ORDER BY c1;
19 TRUNCATE TABLE t2;
20 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
21 SELECT * FROM t2 ORDER BY c1;
22 TRUNCATE TABLE t2;
23 DROP TABLE t1,t2;
24 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
25 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
26 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5);
27 INSERT INTO t2 SELECT * FROM t1;
28 SELECT * FROM t2 ORDER BY c1;
29 TRUNCATE TABLE t2;
30 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
31 SELECT * FROM t2 ORDER BY c1;
32 TRUNCATE TABLE t2;
33 DROP TABLE t1,t2;
34 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
35 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
36 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5);
37 INSERT INTO t2 SELECT * FROM t1;
38 SELECT * FROM t2 ORDER BY c1;
39 TRUNCATE TABLE t2;
40 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
41 SELECT * FROM t2 ORDER BY c1;
42 TRUNCATE TABLE t2;
43 DROP TABLE t1,t2;
44 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
45 CREATE TABLE t2(c1 INTEGER 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 TRUNCATE TABLE t2;
50 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
51 SELECT * FROM t2 ORDER BY c1;
52 TRUNCATE TABLE t2;
53 DROP TABLE t1,t2;
54 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
55 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
56 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5);
57 INSERT INTO t2 SELECT * FROM t1;
58 SELECT * FROM t2 ORDER BY c1;
59 TRUNCATE TABLE t2;
60 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
61 SELECT * FROM t2 ORDER BY c1;
62 TRUNCATE TABLE t2;
63 DROP TABLE t1,t2;
64