Debian Codegraph @

mysql-test/suite/optimizer_unfixed_bugs/r/bug41996-extra1.result

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