Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NOT NULL);
5 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
6 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
7 --error ER_DUP_ENTRY
8
9 INSERT INTO t2 SELECT * FROM t1;
10
11 TRUNCATE TABLE t2;
12 --error ER_DUP_ENTRY
13
14 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
15
16 TRUNCATE TABLE t2;
17 DROP TABLE t1,t2;
18 CREATE TABLE t1(c1 SMALLINT NOT NULL);
19 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
20 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
21 --error ER_DUP_ENTRY
22
23 INSERT INTO t2 SELECT * FROM t1;
24
25 TRUNCATE TABLE t2;
26 --error ER_DUP_ENTRY
27
28 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
29
30 TRUNCATE TABLE t2;
31 DROP TABLE t1,t2;
32 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
33 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
34 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
35 --error ER_DUP_ENTRY
36
37 INSERT INTO t2 SELECT * FROM t1;
38
39 TRUNCATE TABLE t2;
40 --error ER_DUP_ENTRY
41
42 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
43
44 TRUNCATE TABLE t2;
45 DROP TABLE t1,t2;
46 CREATE TABLE t1(c1 INT NOT NULL);
47 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
48 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
49 --error ER_DUP_ENTRY
50
51 INSERT INTO t2 SELECT * FROM t1;
52
53 TRUNCATE TABLE t2;
54 --error ER_DUP_ENTRY
55
56 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
57
58 TRUNCATE TABLE t2;
59 DROP TABLE t1,t2;
60 CREATE TABLE t1(c1 INTEGER NOT NULL);
61 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
62 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
63 --error ER_DUP_ENTRY
64
65 INSERT INTO t2 SELECT * FROM t1;
66
67 TRUNCATE TABLE t2;
68 --error ER_DUP_ENTRY
69
70 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
71
72 TRUNCATE TABLE t2;
73 DROP TABLE t1,t2;
74 CREATE TABLE t1(c1 BIGINT NOT NULL);
75 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
76 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
77 --error ER_DUP_ENTRY
78
79 INSERT INTO t2 SELECT * FROM t1;
80
81 TRUNCATE TABLE t2;
82 --error ER_DUP_ENTRY
83
84 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
85
86 TRUNCATE TABLE t2;
87 DROP TABLE t1,t2;
88