Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_multi_table.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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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 t1, t2 FROM 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 t1.*, t2.*, t3 FROM 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;