Debian Codegraph @

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