Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
3 INSERT INTO t1 (c1) VALUES(10);
4 INSERT INTO t1 (c1) VALUES(11);
5 INSERT INTO t1 (c1) VALUES(10);
6 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
7 SELECT * FROM t1;
8 c1
9 10
10 11
11 DROP TABLE t1;
12 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
13 INSERT INTO t1 (c1) VALUES(10);
14 INSERT INTO t1 (c1) VALUES(11);
15 INSERT INTO t1 (c1) VALUES(10);
16 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
17 SELECT * FROM t1;
18 c1
19 10
20 11
21 DROP TABLE t1;
22 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
23 INSERT INTO t1 (c1) VALUES(10);
24 INSERT INTO t1 (c1) VALUES(11);
25 INSERT INTO t1 (c1) VALUES(10);
26 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
27 SELECT * FROM t1;
28 c1
29 10
30 11
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
33 INSERT INTO t1 (c1) VALUES(10);
34 INSERT INTO t1 (c1) VALUES(11);
35 INSERT INTO t1 (c1) VALUES(10);
36 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
37 SELECT * FROM t1;
38 c1
39 10
40 11
41 DROP TABLE t1;
42 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
43 INSERT INTO t1 (c1) VALUES(10);
44 INSERT INTO t1 (c1) VALUES(11);
45 INSERT INTO t1 (c1) VALUES(10);
46 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
47 SELECT * FROM t1;
48 c1
49 10
50 11
51 DROP TABLE t1;
52 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
53 INSERT INTO t1 (c1) VALUES(10);
54 INSERT INTO t1 (c1) VALUES(11);
55 INSERT INTO t1 (c1) VALUES(10);
56 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
57 SELECT * FROM t1;
58 c1
59 10
60 11
61 DROP TABLE t1;
62 CREATE TABLE t1(c1 DECIMAL NOT NULL PRIMARY KEY);
63 INSERT INTO t1 (c1) VALUES(10);
64 INSERT INTO t1 (c1) VALUES(11);
65 INSERT INTO t1 (c1) VALUES(10);
66 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
67 SELECT * FROM t1;
68 c1
69 10
70 11
71 DROP TABLE t1;
72 CREATE TABLE t1(c1 DEC NOT NULL PRIMARY KEY);
73 INSERT INTO t1 (c1) VALUES(10);
74 INSERT INTO t1 (c1) VALUES(11);
75 INSERT INTO t1 (c1) VALUES(10);
76 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
77 SELECT * FROM t1;
78 c1
79 10
80 11
81 DROP TABLE t1;
82 CREATE TABLE t1(c1 FIXED NOT NULL PRIMARY KEY);
83 INSERT INTO t1 (c1) VALUES(10);
84 INSERT INTO t1 (c1) VALUES(11);
85 INSERT INTO t1 (c1) VALUES(10);
86 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
87 SELECT * FROM t1;
88 c1
89 10
90 11
91 DROP TABLE t1;
92 CREATE TABLE t1(c1 NUMERIC NOT NULL PRIMARY KEY);
93 INSERT INTO t1 (c1) VALUES(10);
94 INSERT INTO t1 (c1) VALUES(11);
95 INSERT INTO t1 (c1) VALUES(10);
96 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
97 SELECT * FROM t1;
98 c1
99 10
100 11
101 DROP TABLE t1;
102 CREATE TABLE t1(c1 DOUBLE NOT NULL PRIMARY KEY);
103 INSERT INTO t1 (c1) VALUES(10);
104 INSERT INTO t1 (c1) VALUES(11);
105 INSERT INTO t1 (c1) VALUES(10);
106 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
107 SELECT * FROM t1;
108 c1
109 10
110 11
111 DROP TABLE t1;
112 CREATE TABLE t1(c1 REAL NOT NULL PRIMARY KEY);
113 INSERT INTO t1 (c1) VALUES(10);
114 INSERT INTO t1 (c1) VALUES(11);
115 INSERT INTO t1 (c1) VALUES(10);
116 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
117 SELECT * FROM t1;
118 c1
119 10
120 11
121 DROP TABLE t1;
122 CREATE TABLE t1(c1 DOUBLE PRECISION NOT NULL PRIMARY KEY);
123 INSERT INTO t1 (c1) VALUES(10);
124 INSERT INTO t1 (c1) VALUES(11);
125 INSERT INTO t1 (c1) VALUES(10);
126 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
127 SELECT * FROM t1;
128 c1
129 10
130 11
131 DROP TABLE t1;
132 CREATE TABLE t1(c1 FLOAT NOT NULL PRIMARY KEY);
133 INSERT INTO t1 (c1) VALUES(10);
134 INSERT INTO t1 (c1) VALUES(11);
135 INSERT INTO t1 (c1) VALUES(10);
136 ERROR 23000: Duplicate entry '10' for key 't1.PRIMARY'
137 SELECT * FROM t1;
138 c1
139 10
140 11
141 DROP TABLE t1;