Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL, c3 TINYINT NULL, UNIQUE(c1,c2,c3));
3 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
4 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
5 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
6 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
7 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
8 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
9 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
10 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
11 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
12 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
13 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
14 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
15 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
16 SELECT * FROM t1;
17 c1 c2 c3
18 10 10 10
19 10 10 11
20 10 11 10
21 10 11 11
22 11 10 10
23 11 10 11
24 11 11 10
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL, c3 SMALLINT NULL, UNIQUE(c1,c2,c3));
27 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
28 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
29 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
30 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
31 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
32 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
33 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
34 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
35 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
36 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
37 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
38 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
39 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
40 SELECT * FROM t1;
41 c1 c2 c3
42 10 10 10
43 10 10 11
44 10 11 10
45 10 11 11
46 11 10 10
47 11 10 11
48 11 11 10
49 DROP TABLE t1;
50 CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL, c3 MEDIUMINT NULL, UNIQUE(c1,c2,c3));
51 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
52 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
53 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
54 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
55 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
56 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
57 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
58 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
59 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
60 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
61 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
62 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
63 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
64 SELECT * FROM t1;
65 c1 c2 c3
66 10 10 10
67 10 10 11
68 10 11 10
69 10 11 11
70 11 10 10
71 11 10 11
72 11 11 10
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 INT NULL, c2 INT NULL, c3 INT NULL, UNIQUE(c1,c2,c3));
75 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
76 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
77 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
78 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
79 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
80 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
81 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
82 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
83 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
84 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
85 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
86 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
87 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
88 SELECT * FROM t1;
89 c1 c2 c3
90 10 10 10
91 10 10 11
92 10 11 10
93 10 11 11
94 11 10 10
95 11 10 11
96 11 11 10
97 DROP TABLE t1;
98 CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL, c3 INTEGER NULL, UNIQUE(c1,c2,c3));
99 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
100 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
101 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
102 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
103 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
104 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
105 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
106 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
107 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
108 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
109 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
110 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
111 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
112 SELECT * FROM t1;
113 c1 c2 c3
114 10 10 10
115 10 10 11
116 10 11 10
117 10 11 11
118 11 10 10
119 11 10 11
120 11 11 10
121 DROP TABLE t1;
122 CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL, c3 BIGINT NULL, UNIQUE(c1,c2,c3));
123 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
124 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
125 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
126 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
127 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
128 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
129 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
130 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
131 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
132 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
133 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
134 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
135 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
136 SELECT * FROM t1;
137 c1 c2 c3
138 10 10 10
139 10 10 11
140 10 11 10
141 10 11 11
142 11 10 10
143 11 10 11
144 11 11 10
145 DROP TABLE t1;
146 CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL, c3 DECIMAL NULL, UNIQUE(c1,c2,c3));
147 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
148 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
149 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
150 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
151 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
152 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
153 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
154 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
155 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
156 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
157 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
158 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
159 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
160 SELECT * FROM t1;
161 c1 c2 c3
162 10 10 10
163 10 10 11
164 10 11 10
165 10 11 11
166 11 10 10
167 11 10 11
168 11 11 10
169 DROP TABLE t1;
170 CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL, c3 DEC NULL, UNIQUE(c1,c2,c3));
171 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
172 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
173 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
174 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
175 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
176 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
177 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
178 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
179 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
180 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
181 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
182 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
183 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
184 SELECT * FROM t1;
185 c1 c2 c3
186 10 10 10
187 10 10 11
188 10 11 10
189 10 11 11
190 11 10 10
191 11 10 11
192 11 11 10
193 DROP TABLE t1;
194 CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL, c3 FIXED NULL, UNIQUE(c1,c2,c3));
195 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
196 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
197 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
198 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
199 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
200 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
201 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
202 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
203 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
204 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
205 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
206 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
207 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
208 SELECT * FROM t1;
209 c1 c2 c3
210 10 10 10
211 10 10 11
212 10 11 10
213 10 11 11
214 11 10 10
215 11 10 11
216 11 11 10
217 DROP TABLE t1;
218 CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL, c3 NUMERIC NULL, UNIQUE(c1,c2,c3));
219 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
220 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
221 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
222 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
223 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
224 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
225 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
226 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
227 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
228 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
229 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
230 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
231 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
232 SELECT * FROM t1;
233 c1 c2 c3
234 10 10 10
235 10 10 11
236 10 11 10
237 10 11 11
238 11 10 10
239 11 10 11
240 11 11 10
241 DROP TABLE t1;
242 CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL, c3 DOUBLE NULL, UNIQUE(c1,c2,c3));
243 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
244 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
245 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
246 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
247 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
248 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
249 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
250 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
251 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
252 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
253 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
254 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
255 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
256 SELECT * FROM t1;
257 c1 c2 c3
258 10 10 10
259 10 10 11
260 10 11 10
261 10 11 11
262 11 10 10
263 11 10 11
264 11 11 10
265 DROP TABLE t1;
266 CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL, c3 REAL NULL, UNIQUE(c1,c2,c3));
267 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
268 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
269 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
270 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
271 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
272 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
273 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
274 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
275 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
276 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
277 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
278 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
279 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
280 SELECT * FROM t1;
281 c1 c2 c3
282 10 10 10
283 10 10 11
284 10 11 10
285 10 11 11
286 11 10 10
287 11 10 11
288 11 11 10
289 DROP TABLE t1;
290 CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL, c3 DOUBLE PRECISION NULL, UNIQUE(c1,c2,c3));
291 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
292 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
293 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
294 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
295 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
296 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
297 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
298 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
299 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
300 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
301 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
302 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
303 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
304 SELECT * FROM t1;
305 c1 c2 c3
306 10 10 10
307 10 10 11
308 10 11 10
309 10 11 11
310 11 10 10
311 11 10 11
312 11 11 10
313 DROP TABLE t1;
314 CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL, c3 FLOAT NULL, UNIQUE(c1,c2,c3));
315 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
316 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
317 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
318 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
319 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
320 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
321 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
322 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
323 ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1'
324 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
325 ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1'
326 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
327 ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1'
328 SELECT * FROM t1;
329 c1 c2 c3
330 10 10 10
331 10 10 11
332 10 11 10
333 10 11 11
334 11 10 10
335 11 10 11
336 11 11 10
337 DROP TABLE t1;