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 'PRIMARY'
8
INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
9
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
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 'PRIMARY'
18
INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
19
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
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 'PRIMARY'
28
INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
29
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
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 'PRIMARY'
38
INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
39
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
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 'PRIMARY'
48
INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
49
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
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 'PRIMARY'
58
INSERT INTO t2 SELECT * FROM t1 WHERE c1 >= 3;
59
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'