Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_number_unique_constraint_ignore.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 IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
11 Warnings:
12 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
13 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
14 Warnings:
15 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
16 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
17 Warnings:
18 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
19 SELECT * FROM t1;
20 c1 c2 c3
21 10 10 10
22 10 10 11
23 10 11 10
24 10 11 11
25 11 10 10
26 11 10 11
27 11 11 10
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL, c3 SMALLINT NULL, UNIQUE(c1,c2,c3));
30 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
31 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
32 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
33 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
34 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
35 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
36 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
37 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
38 Warnings:
39 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
40 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
41 Warnings:
42 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
43 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
44 Warnings:
45 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
46 SELECT * FROM t1;
47 c1 c2 c3
48 10 10 10
49 10 10 11
50 10 11 10
51 10 11 11
52 11 10 10
53 11 10 11
54 11 11 10
55 DROP TABLE t1;
56 CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL, c3 MEDIUMINT NULL, UNIQUE(c1,c2,c3));
57 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
58 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
59 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
60 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
61 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
62 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
63 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
64 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
65 Warnings:
66 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
67 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
68 Warnings:
69 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
70 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
71 Warnings:
72 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
73 SELECT * FROM t1;
74 c1 c2 c3
75 10 10 10
76 10 10 11
77 10 11 10
78 10 11 11
79 11 10 10
80 11 10 11
81 11 11 10
82 DROP TABLE t1;
83 CREATE TABLE t1(c1 INT NULL, c2 INT NULL, c3 INT NULL, UNIQUE(c1,c2,c3));
84 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
85 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
86 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
87 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
88 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
89 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
90 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
91 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
92 Warnings:
93 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
94 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
95 Warnings:
96 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
97 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
98 Warnings:
99 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
100 SELECT * FROM t1;
101 c1 c2 c3
102 10 10 10
103 10 10 11
104 10 11 10
105 10 11 11
106 11 10 10
107 11 10 11
108 11 11 10
109 DROP TABLE t1;
110 CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL, c3 INTEGER NULL, UNIQUE(c1,c2,c3));
111 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
112 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
113 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
114 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
115 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
116 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
117 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
118 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
119 Warnings:
120 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
121 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
122 Warnings:
123 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
124 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
125 Warnings:
126 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
127 SELECT * FROM t1;
128 c1 c2 c3
129 10 10 10
130 10 10 11
131 10 11 10
132 10 11 11
133 11 10 10
134 11 10 11
135 11 11 10
136 DROP TABLE t1;
137 CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL, c3 BIGINT NULL, UNIQUE(c1,c2,c3));
138 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
139 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
140 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
141 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
142 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
143 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
144 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
145 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
146 Warnings:
147 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
148 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
149 Warnings:
150 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
151 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
152 Warnings:
153 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
154 SELECT * FROM t1;
155 c1 c2 c3
156 10 10 10
157 10 10 11
158 10 11 10
159 10 11 11
160 11 10 10
161 11 10 11
162 11 11 10
163 DROP TABLE t1;
164 CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL, c3 DECIMAL NULL, UNIQUE(c1,c2,c3));
165 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
166 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
167 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
168 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
169 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
170 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
171 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
172 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
173 Warnings:
174 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
175 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
176 Warnings:
177 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
178 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
179 Warnings:
180 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
181 SELECT * FROM t1;
182 c1 c2 c3
183 10 10 10
184 10 10 11
185 10 11 10
186 10 11 11
187 11 10 10
188 11 10 11
189 11 11 10
190 DROP TABLE t1;
191 CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL, c3 DEC NULL, UNIQUE(c1,c2,c3));
192 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
193 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
194 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
195 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
196 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
197 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
198 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
199 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
200 Warnings:
201 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
202 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
203 Warnings:
204 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
205 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
206 Warnings:
207 Warning 1062 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 FIXED NULL, c2 FIXED NULL, c3 FIXED 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 IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
227 Warnings:
228 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
229 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
230 Warnings:
231 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
232 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
233 Warnings:
234 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
235 SELECT * FROM t1;
236 c1 c2 c3
237 10 10 10
238 10 10 11
239 10 11 10
240 10 11 11
241 11 10 10
242 11 10 11
243 11 11 10
244 DROP TABLE t1;
245 CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL, c3 NUMERIC NULL, UNIQUE(c1,c2,c3));
246 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
247 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
248 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
249 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
250 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
251 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
252 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
253 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
254 Warnings:
255 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
256 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
257 Warnings:
258 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
259 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
260 Warnings:
261 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
262 SELECT * FROM t1;
263 c1 c2 c3
264 10 10 10
265 10 10 11
266 10 11 10
267 10 11 11
268 11 10 10
269 11 10 11
270 11 11 10
271 DROP TABLE t1;
272 CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL, c3 DOUBLE NULL, UNIQUE(c1,c2,c3));
273 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
274 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
275 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
276 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
277 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
278 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
279 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
280 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
281 Warnings:
282 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
283 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
284 Warnings:
285 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
286 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
287 Warnings:
288 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
289 SELECT * FROM t1;
290 c1 c2 c3
291 10 10 10
292 10 10 11
293 10 11 10
294 10 11 11
295 11 10 10
296 11 10 11
297 11 11 10
298 DROP TABLE t1;
299 CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL, c3 REAL NULL, UNIQUE(c1,c2,c3));
300 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
301 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
302 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
303 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
304 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
305 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
306 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
307 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
308 Warnings:
309 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
310 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
311 Warnings:
312 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
313 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
314 Warnings:
315 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
316 SELECT * FROM t1;
317 c1 c2 c3
318 10 10 10
319 10 10 11
320 10 11 10
321 10 11 11
322 11 10 10
323 11 10 11
324 11 11 10
325 DROP TABLE t1;
326 CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL, c3 DOUBLE PRECISION NULL, UNIQUE(c1,c2,c3));
327 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
328 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
329 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
330 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
331 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
332 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
333 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
334 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
335 Warnings:
336 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
337 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
338 Warnings:
339 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
340 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
341 Warnings:
342 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
343 SELECT * FROM t1;
344 c1 c2 c3
345 10 10 10
346 10 10 11
347 10 11 10
348 10 11 11
349 11 10 10
350 11 10 11
351 11 11 10
352 DROP TABLE t1;
353 CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL, c3 FLOAT NULL, UNIQUE(c1,c2,c3));
354 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
355 INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
356 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
357 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
358 INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
359 INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
360 INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
361 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,10);
362 Warnings:
363 Warning 1062 Duplicate entry '10-10-10' for key 't1.c1'
364 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,10,11);
365 Warnings:
366 Warning 1062 Duplicate entry '10-10-11' for key 't1.c1'
367 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(10,11,11);
368 Warnings:
369 Warning 1062 Duplicate entry '10-11-11' for key 't1.c1'
370 SELECT * FROM t1;
371 c1 c2 c3
372 10 10 10
373 10 10 11
374 10 11 10
375 10 11 11
376 11 10 10
377 11 10 11
378 11 11 10
379 DROP TABLE t1;