Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
4 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
5 INSERT INTO t2 SELECT * FROM t1;
6 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
7 TRUNCATE TABLE t2;
8 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
9 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
10 TRUNCATE TABLE t2;
11 DROP TABLE t1,t2;
12 CREATE TABLE t1(c1 SMALLINT NOT NULL);
13 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
14 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
15 INSERT INTO t2 SELECT * FROM t1;
16 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
17 TRUNCATE TABLE t2;
18 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
19 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
20 TRUNCATE TABLE t2;
21 DROP TABLE t1,t2;
22 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
23 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
24 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
25 INSERT INTO t2 SELECT * FROM t1;
26 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
27 TRUNCATE TABLE t2;
28 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
29 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
30 TRUNCATE TABLE t2;
31 DROP TABLE t1,t2;
32 CREATE TABLE t1(c1 INT NOT NULL);
33 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
34 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
35 INSERT INTO t2 SELECT * FROM t1;
36 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
37 TRUNCATE TABLE t2;
38 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
39 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
40 TRUNCATE TABLE t2;
41 DROP TABLE t1,t2;
42 CREATE TABLE t1(c1 INTEGER NOT NULL);
43 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
44 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
45 INSERT INTO t2 SELECT * FROM t1;
46 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
47 TRUNCATE TABLE t2;
48 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
49 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
50 TRUNCATE TABLE t2;
51 DROP TABLE t1,t2;
52 CREATE TABLE t1(c1 BIGINT NOT NULL);
53 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
54 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(3),(4),(4),(5);
55 INSERT INTO t2 SELECT * FROM t1;
56 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
57 TRUNCATE TABLE t2;
58 INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
59 ERROR 23000: Duplicate entry '3' for key 't2.PRIMARY'
60 TRUNCATE TABLE t2;
61 DROP TABLE t1,t2;