Debian Codegraph @

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

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