Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
2 CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
3 CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
4 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
5 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
6 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
7 DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
8 SELECT * FROM t1 ORDER BY c1;
9 c1 c2
10 3 3
11 4 4
12 5 5
13 SELECT * FROM t2 ORDER BY c1;
14 c1 c2
15 12 1
16 15 6
17 SELECT * FROM t3 ORDER BY c1;
18 c1 c2
19 21 11
20 22 11
21 23 13
22 24 14
23 25 15
24 DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
25 SELECT * FROM t1 ORDER BY c1;
26 c1 c2
27 3 3
28 4 4
29 5 5
30 SELECT * FROM t2 ORDER BY c1;
31 c1 c2
32 12 1
33 15 6
34 SELECT * FROM t3 ORDER BY c1;
35 c1 c2
36 21 11
37 22 11
38 23 13
39 24 14
40 25 15
41 DROP TABLE t1,t2,t3;
42 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
43 CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
44 CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
45 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
46 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
47 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
48 DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
49 SELECT * FROM t1 ORDER BY c1;
50 c1 c2
51 3 3
52 4 4
53 5 5
54 SELECT * FROM t2 ORDER BY c1;
55 c1 c2
56 12 1
57 15 6
58 SELECT * FROM t3 ORDER BY c1;
59 c1 c2
60 21 11
61 22 11
62 23 13
63 24 14
64 25 15
65 DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
66 SELECT * FROM t1 ORDER BY c1;
67 c1 c2
68 3 3
69 4 4
70 5 5
71 SELECT * FROM t2 ORDER BY c1;
72 c1 c2
73 12 1
74 15 6
75 SELECT * FROM t3 ORDER BY c1;
76 c1 c2
77 21 11
78 22 11
79 23 13
80 24 14
81 25 15
82 DROP TABLE t1,t2,t3;
83 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
84 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
85 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
86 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
87 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
88 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
89 DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
90 SELECT * FROM t1 ORDER BY c1;
91 c1 c2
92 3 3
93 4 4
94 5 5
95 SELECT * FROM t2 ORDER BY c1;
96 c1 c2
97 12 1
98 15 6
99 SELECT * FROM t3 ORDER BY c1;
100 c1 c2
101 21 11
102 22 11
103 23 13
104 24 14
105 25 15
106 DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
107 SELECT * FROM t1 ORDER BY c1;
108 c1 c2
109 3 3
110 4 4
111 5 5
112 SELECT * FROM t2 ORDER BY c1;
113 c1 c2
114 12 1
115 15 6
116 SELECT * FROM t3 ORDER BY c1;
117 c1 c2
118 21 11
119 22 11
120 23 13
121 24 14
122 25 15
123 DROP TABLE t1,t2,t3;
124 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
125 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
126 CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
127 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
128 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
129 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
130 DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
131 SELECT * FROM t1 ORDER BY c1;
132 c1 c2
133 3 3
134 4 4
135 5 5
136 SELECT * FROM t2 ORDER BY c1;
137 c1 c2
138 12 1
139 15 6
140 SELECT * FROM t3 ORDER BY c1;
141 c1 c2
142 21 11
143 22 11
144 23 13
145 24 14
146 25 15
147 DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
148 SELECT * FROM t1 ORDER BY c1;
149 c1 c2
150 3 3
151 4 4
152 5 5
153 SELECT * FROM t2 ORDER BY c1;
154 c1 c2
155 12 1
156 15 6
157 SELECT * FROM t3 ORDER BY c1;
158 c1 c2
159 21 11
160 22 11
161 23 13
162 24 14
163 25 15
164 DROP TABLE t1,t2,t3;
165 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
166 CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
167 CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
168 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
169 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
170 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
171 DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
172 SELECT * FROM t1 ORDER BY c1;
173 c1 c2
174 3 3
175 4 4
176 5 5
177 SELECT * FROM t2 ORDER BY c1;
178 c1 c2
179 12 1
180 15 6
181 SELECT * FROM t3 ORDER BY c1;
182 c1 c2
183 21 11
184 22 11
185 23 13
186 24 14
187 25 15
188 DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
189 SELECT * FROM t1 ORDER BY c1;
190 c1 c2
191 3 3
192 4 4
193 5 5
194 SELECT * FROM t2 ORDER BY c1;
195 c1 c2
196 12 1
197 15 6
198 SELECT * FROM t3 ORDER BY c1;
199 c1 c2
200 21 11
201 22 11
202 23 13
203 24 14
204 25 15
205 DROP TABLE t1,t2,t3;
206 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
207 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
208 CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
209 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
210 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
211 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
212 DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
213 SELECT * FROM t1 ORDER BY c1;
214 c1 c2
215 3 3
216 4 4
217 5 5
218 SELECT * FROM t2 ORDER BY c1;
219 c1 c2
220 12 1
221 15 6
222 SELECT * FROM t3 ORDER BY c1;
223 c1 c2
224 21 11
225 22 11
226 23 13
227 24 14
228 25 15
229 DELETE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
230 SELECT * FROM t1 ORDER BY c1;
231 c1 c2
232 3 3
233 4 4
234 5 5
235 SELECT * FROM t2 ORDER BY c1;
236 c1 c2
237 12 1
238 15 6
239 SELECT * FROM t3 ORDER BY c1;
240 c1 c2
241 21 11
242 22 11
243 23 13
244 24 14
245 25 15
246 DROP TABLE t1,t2,t3;
247 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
248 CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
249 CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
250 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
251 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
252 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
253 DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
254 SELECT * FROM t1 ORDER BY c1;
255 c1 c2
256 3 3
257 4 4
258 5 5
259 SELECT * FROM t2 ORDER BY c1;
260 c1 c2
261 12 1
262 15 6
263 SELECT * FROM t3 ORDER BY c1;
264 c1 c2
265 21 11
266 22 11
267 23 13
268 24 14
269 25 15
270 DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
271 SELECT * FROM t1 ORDER BY c1;
272 c1 c2
273 3 3
274 4 4
275 5 5
276 SELECT * FROM t2 ORDER BY c1;
277 c1 c2
278 12 1
279 15 6
280 SELECT * FROM t3 ORDER BY c1;
281 c1 c2
282 21 11
283 22 11
284 23 13
285 24 14
286 25 15
287 DROP TABLE t1,t2,t3;
288 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
289 CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
290 CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
291 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
292 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
293 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
294 DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
295 SELECT * FROM t1 ORDER BY c1;
296 c1 c2
297 3 3
298 4 4
299 5 5
300 SELECT * FROM t2 ORDER BY c1;
301 c1 c2
302 12 1
303 15 6
304 SELECT * FROM t3 ORDER BY c1;
305 c1 c2
306 21 11
307 22 11
308 23 13
309 24 14
310 25 15
311 DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
312 SELECT * FROM t1 ORDER BY c1;
313 c1 c2
314 3 3
315 4 4
316 5 5
317 SELECT * FROM t2 ORDER BY c1;
318 c1 c2
319 12 1
320 15 6
321 SELECT * FROM t3 ORDER BY c1;
322 c1 c2
323 21 11
324 22 11
325 23 13
326 24 14
327 25 15
328 DROP TABLE t1,t2,t3;
329 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
330 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
331 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
332 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
333 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
334 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
335 DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
336 SELECT * FROM t1 ORDER BY c1;
337 c1 c2
338 3 3
339 4 4
340 5 5
341 SELECT * FROM t2 ORDER BY c1;
342 c1 c2
343 12 1
344 15 6
345 SELECT * FROM t3 ORDER BY c1;
346 c1 c2
347 21 11
348 22 11
349 23 13
350 24 14
351 25 15
352 DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
353 SELECT * FROM t1 ORDER BY c1;
354 c1 c2
355 3 3
356 4 4
357 5 5
358 SELECT * FROM t2 ORDER BY c1;
359 c1 c2
360 12 1
361 15 6
362 SELECT * FROM t3 ORDER BY c1;
363 c1 c2
364 21 11
365 22 11
366 23 13
367 24 14
368 25 15
369 DROP TABLE t1,t2,t3;
370 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
371 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
372 CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
373 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
374 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
375 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
376 DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
377 SELECT * FROM t1 ORDER BY c1;
378 c1 c2
379 3 3
380 4 4
381 5 5
382 SELECT * FROM t2 ORDER BY c1;
383 c1 c2
384 12 1
385 15 6
386 SELECT * FROM t3 ORDER BY c1;
387 c1 c2
388 21 11
389 22 11
390 23 13
391 24 14
392 25 15
393 DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
394 SELECT * FROM t1 ORDER BY c1;
395 c1 c2
396 3 3
397 4 4
398 5 5
399 SELECT * FROM t2 ORDER BY c1;
400 c1 c2
401 12 1
402 15 6
403 SELECT * FROM t3 ORDER BY c1;
404 c1 c2
405 21 11
406 22 11
407 23 13
408 24 14
409 25 15
410 DROP TABLE t1,t2,t3;
411 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
412 CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
413 CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
414 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
415 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
416 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
417 DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
418 SELECT * FROM t1 ORDER BY c1;
419 c1 c2
420 3 3
421 4 4
422 5 5
423 SELECT * FROM t2 ORDER BY c1;
424 c1 c2
425 12 1
426 15 6
427 SELECT * FROM t3 ORDER BY c1;
428 c1 c2
429 21 11
430 22 11
431 23 13
432 24 14
433 25 15
434 DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
435 SELECT * FROM t1 ORDER BY c1;
436 c1 c2
437 3 3
438 4 4
439 5 5
440 SELECT * FROM t2 ORDER BY c1;
441 c1 c2
442 12 1
443 15 6
444 SELECT * FROM t3 ORDER BY c1;
445 c1 c2
446 21 11
447 22 11
448 23 13
449 24 14
450 25 15
451 DROP TABLE t1,t2,t3;
452 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
453 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
454 CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
455 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
456 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
457 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
458 DELETE QUICK FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
459 SELECT * FROM t1 ORDER BY c1;
460 c1 c2
461 3 3
462 4 4
463 5 5
464 SELECT * FROM t2 ORDER BY c1;
465 c1 c2
466 12 1
467 15 6
468 SELECT * FROM t3 ORDER BY c1;
469 c1 c2
470 21 11
471 22 11
472 23 13
473 24 14
474 25 15
475 DELETE QUICK FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
476 SELECT * FROM t1 ORDER BY c1;
477 c1 c2
478 3 3
479 4 4
480 5 5
481 SELECT * FROM t2 ORDER BY c1;
482 c1 c2
483 12 1
484 15 6
485 SELECT * FROM t3 ORDER BY c1;
486 c1 c2
487 21 11
488 22 11
489 23 13
490 24 14
491 25 15
492 DROP TABLE t1,t2,t3;
493 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
494 CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
495 CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
496 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
497 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
498 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
499 DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
500 SELECT * FROM t1 ORDER BY c1;
501 c1 c2
502 3 3
503 4 4
504 5 5
505 SELECT * FROM t2 ORDER BY c1;
506 c1 c2
507 12 1
508 15 6
509 SELECT * FROM t3 ORDER BY c1;
510 c1 c2
511 21 11
512 22 11
513 23 13
514 24 14
515 25 15
516 DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
517 SELECT * FROM t1 ORDER BY c1;
518 c1 c2
519 3 3
520 4 4
521 5 5
522 SELECT * FROM t2 ORDER BY c1;
523 c1 c2
524 12 1
525 15 6
526 SELECT * FROM t3 ORDER BY c1;
527 c1 c2
528 21 11
529 22 11
530 23 13
531 24 14
532 25 15
533 DROP TABLE t1,t2,t3;
534 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
535 CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
536 CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
537 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
538 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
539 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
540 DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
541 SELECT * FROM t1 ORDER BY c1;
542 c1 c2
543 3 3
544 4 4
545 5 5
546 SELECT * FROM t2 ORDER BY c1;
547 c1 c2
548 12 1
549 15 6
550 SELECT * FROM t3 ORDER BY c1;
551 c1 c2
552 21 11
553 22 11
554 23 13
555 24 14
556 25 15
557 DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
558 SELECT * FROM t1 ORDER BY c1;
559 c1 c2
560 3 3
561 4 4
562 5 5
563 SELECT * FROM t2 ORDER BY c1;
564 c1 c2
565 12 1
566 15 6
567 SELECT * FROM t3 ORDER BY c1;
568 c1 c2
569 21 11
570 22 11
571 23 13
572 24 14
573 25 15
574 DROP TABLE t1,t2,t3;
575 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
576 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
577 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
578 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
579 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
580 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
581 DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
582 SELECT * FROM t1 ORDER BY c1;
583 c1 c2
584 3 3
585 4 4
586 5 5
587 SELECT * FROM t2 ORDER BY c1;
588 c1 c2
589 12 1
590 15 6
591 SELECT * FROM t3 ORDER BY c1;
592 c1 c2
593 21 11
594 22 11
595 23 13
596 24 14
597 25 15
598 DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
599 SELECT * FROM t1 ORDER BY c1;
600 c1 c2
601 3 3
602 4 4
603 5 5
604 SELECT * FROM t2 ORDER BY c1;
605 c1 c2
606 12 1
607 15 6
608 SELECT * FROM t3 ORDER BY c1;
609 c1 c2
610 21 11
611 22 11
612 23 13
613 24 14
614 25 15
615 DROP TABLE t1,t2,t3;
616 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
617 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
618 CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
619 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
620 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
621 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
622 DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
623 SELECT * FROM t1 ORDER BY c1;
624 c1 c2
625 3 3
626 4 4
627 5 5
628 SELECT * FROM t2 ORDER BY c1;
629 c1 c2
630 12 1
631 15 6
632 SELECT * FROM t3 ORDER BY c1;
633 c1 c2
634 21 11
635 22 11
636 23 13
637 24 14
638 25 15
639 DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
640 SELECT * FROM t1 ORDER BY c1;
641 c1 c2
642 3 3
643 4 4
644 5 5
645 SELECT * FROM t2 ORDER BY c1;
646 c1 c2
647 12 1
648 15 6
649 SELECT * FROM t3 ORDER BY c1;
650 c1 c2
651 21 11
652 22 11
653 23 13
654 24 14
655 25 15
656 DROP TABLE t1,t2,t3;
657 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
658 CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
659 CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
660 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
661 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
662 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
663 DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
664 SELECT * FROM t1 ORDER BY c1;
665 c1 c2
666 3 3
667 4 4
668 5 5
669 SELECT * FROM t2 ORDER BY c1;
670 c1 c2
671 12 1
672 15 6
673 SELECT * FROM t3 ORDER BY c1;
674 c1 c2
675 21 11
676 22 11
677 23 13
678 24 14
679 25 15
680 DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
681 SELECT * FROM t1 ORDER BY c1;
682 c1 c2
683 3 3
684 4 4
685 5 5
686 SELECT * FROM t2 ORDER BY c1;
687 c1 c2
688 12 1
689 15 6
690 SELECT * FROM t3 ORDER BY c1;
691 c1 c2
692 21 11
693 22 11
694 23 13
695 24 14
696 25 15
697 DROP TABLE t1,t2,t3;
698 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
699 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
700 CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
701 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
702 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
703 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
704 DELETE IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
705 SELECT * FROM t1 ORDER BY c1;
706 c1 c2
707 3 3
708 4 4
709 5 5
710 SELECT * FROM t2 ORDER BY c1;
711 c1 c2
712 12 1
713 15 6
714 SELECT * FROM t3 ORDER BY c1;
715 c1 c2
716 21 11
717 22 11
718 23 13
719 24 14
720 25 15
721 DELETE IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
722 SELECT * FROM t1 ORDER BY c1;
723 c1 c2
724 3 3
725 4 4
726 5 5
727 SELECT * FROM t2 ORDER BY c1;
728 c1 c2
729 12 1
730 15 6
731 SELECT * FROM t3 ORDER BY c1;
732 c1 c2
733 21 11
734 22 11
735 23 13
736 24 14
737 25 15
738 DROP TABLE t1,t2,t3;
739 CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
740 CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
741 CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
742 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
743 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
744 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
745 DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
746 SELECT * FROM t1 ORDER BY c1;
747 c1 c2
748 3 3
749 4 4
750 5 5
751 SELECT * FROM t2 ORDER BY c1;
752 c1 c2
753 12 1
754 15 6
755 SELECT * FROM t3 ORDER BY c1;
756 c1 c2
757 21 11
758 22 11
759 23 13
760 24 14
761 25 15
762 DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
763 SELECT * FROM t1 ORDER BY c1;
764 c1 c2
765 3 3
766 4 4
767 5 5
768 SELECT * FROM t2 ORDER BY c1;
769 c1 c2
770 12 1
771 15 6
772 SELECT * FROM t3 ORDER BY c1;
773 c1 c2
774 21 11
775 22 11
776 23 13
777 24 14
778 25 15
779 DROP TABLE t1,t2,t3;
780 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
781 CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
782 CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
783 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
784 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
785 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
786 DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
787 SELECT * FROM t1 ORDER BY c1;
788 c1 c2
789 3 3
790 4 4
791 5 5
792 SELECT * FROM t2 ORDER BY c1;
793 c1 c2
794 12 1
795 15 6
796 SELECT * FROM t3 ORDER BY c1;
797 c1 c2
798 21 11
799 22 11
800 23 13
801 24 14
802 25 15
803 DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
804 SELECT * FROM t1 ORDER BY c1;
805 c1 c2
806 3 3
807 4 4
808 5 5
809 SELECT * FROM t2 ORDER BY c1;
810 c1 c2
811 12 1
812 15 6
813 SELECT * FROM t3 ORDER BY c1;
814 c1 c2
815 21 11
816 22 11
817 23 13
818 24 14
819 25 15
820 DROP TABLE t1,t2,t3;
821 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
822 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
823 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
824 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
825 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
826 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
827 DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
828 SELECT * FROM t1 ORDER BY c1;
829 c1 c2
830 3 3
831 4 4
832 5 5
833 SELECT * FROM t2 ORDER BY c1;
834 c1 c2
835 12 1
836 15 6
837 SELECT * FROM t3 ORDER BY c1;
838 c1 c2
839 21 11
840 22 11
841 23 13
842 24 14
843 25 15
844 DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
845 SELECT * FROM t1 ORDER BY c1;
846 c1 c2
847 3 3
848 4 4
849 5 5
850 SELECT * FROM t2 ORDER BY c1;
851 c1 c2
852 12 1
853 15 6
854 SELECT * FROM t3 ORDER BY c1;
855 c1 c2
856 21 11
857 22 11
858 23 13
859 24 14
860 25 15
861 DROP TABLE t1,t2,t3;
862 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
863 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
864 CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
865 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
866 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
867 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
868 DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
869 SELECT * FROM t1 ORDER BY c1;
870 c1 c2
871 3 3
872 4 4
873 5 5
874 SELECT * FROM t2 ORDER BY c1;
875 c1 c2
876 12 1
877 15 6
878 SELECT * FROM t3 ORDER BY c1;
879 c1 c2
880 21 11
881 22 11
882 23 13
883 24 14
884 25 15
885 DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
886 SELECT * FROM t1 ORDER BY c1;
887 c1 c2
888 3 3
889 4 4
890 5 5
891 SELECT * FROM t2 ORDER BY c1;
892 c1 c2
893 12 1
894 15 6
895 SELECT * FROM t3 ORDER BY c1;
896 c1 c2
897 21 11
898 22 11
899 23 13
900 24 14
901 25 15
902 DROP TABLE t1,t2,t3;
903 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
904 CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
905 CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
906 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
907 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
908 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
909 DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
910 SELECT * FROM t1 ORDER BY c1;
911 c1 c2
912 3 3
913 4 4
914 5 5
915 SELECT * FROM t2 ORDER BY c1;
916 c1 c2
917 12 1
918 15 6
919 SELECT * FROM t3 ORDER BY c1;
920 c1 c2
921 21 11
922 22 11
923 23 13
924 24 14
925 25 15
926 DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
927 SELECT * FROM t1 ORDER BY c1;
928 c1 c2
929 3 3
930 4 4
931 5 5
932 SELECT * FROM t2 ORDER BY c1;
933 c1 c2
934 12 1
935 15 6
936 SELECT * FROM t3 ORDER BY c1;
937 c1 c2
938 21 11
939 22 11
940 23 13
941 24 14
942 25 15
943 DROP TABLE t1,t2,t3;
944 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
945 CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
946 CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
947 INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
948 INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
949 INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
950 DELETE QUICK IGNORE FROM t1, t2 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
951 SELECT * FROM t1 ORDER BY c1;
952 c1 c2
953 3 3
954 4 4
955 5 5
956 SELECT * FROM t2 ORDER BY c1;
957 c1 c2
958 12 1
959 15 6
960 SELECT * FROM t3 ORDER BY c1;
961 c1 c2
962 21 11
963 22 11
964 23 13
965 24 14
966 25 15
967 DELETE QUICK IGNORE FROM t1, t2, t3 USING t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
968 SELECT * FROM t1 ORDER BY c1;
969 c1 c2
970 3 3
971 4 4
972 5 5
973 SELECT * FROM t2 ORDER BY c1;
974 c1 c2
975 12 1
976 15 6
977 SELECT * FROM t3 ORDER BY c1;
978 c1 c2
979 21 11
980 22 11
981 23 13
982 24 14
983 25 15
984 DROP TABLE t1,t2,t3;