1--disable_warnings
2DROP DATABASE IF EXISTS d1;
3DROP DATABASE IF EXISTS d2;
4DROP DATABASE IF EXISTS d3;
5--enable_warnings
6CREATE DATABASE d1;
7CREATE DATABASE d2;
8CREATE DATABASE d3;
9CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
10CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
11CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
12INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
13INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
14INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
15DELETE     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;
16SELECT * FROM d1.t1 ORDER BY c1;
17SELECT * FROM d2.t2 ORDER BY c1;
18SELECT * FROM d3.t3 ORDER BY c1;
19DELETE     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;
20SELECT * FROM d1.t1 ORDER BY c1;
21SELECT * FROM d2.t2 ORDER BY c1;
22SELECT * FROM d3.t3 ORDER BY c1;
23DROP DATABASE d1;
24DROP DATABASE d2;
25DROP DATABASE d3;
26CREATE DATABASE d1;
27CREATE DATABASE d2;
28CREATE DATABASE d3;
29CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
30CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
31CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
32INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
33INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
34INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
35DELETE     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;
36SELECT * FROM d1.t1 ORDER BY c1;
37SELECT * FROM d2.t2 ORDER BY c1;
38SELECT * FROM d3.t3 ORDER BY c1;
39DELETE     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;
40SELECT * FROM d1.t1 ORDER BY c1;
41SELECT * FROM d2.t2 ORDER BY c1;
42SELECT * FROM d3.t3 ORDER BY c1;
43DROP DATABASE d1;
44DROP DATABASE d2;
45DROP DATABASE d3;
46CREATE DATABASE d1;
47CREATE DATABASE d2;
48CREATE DATABASE d3;
49CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
50CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
51CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
52INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
53INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
54INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
55DELETE     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;
56SELECT * FROM d1.t1 ORDER BY c1;
57SELECT * FROM d2.t2 ORDER BY c1;
58SELECT * FROM d3.t3 ORDER BY c1;
59DELETE     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;
60SELECT * FROM d1.t1 ORDER BY c1;
61SELECT * FROM d2.t2 ORDER BY c1;
62SELECT * FROM d3.t3 ORDER BY c1;
63DROP DATABASE d1;
64DROP DATABASE d2;
65DROP DATABASE d3;
66CREATE DATABASE d1;
67CREATE DATABASE d2;
68CREATE DATABASE d3;
69CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
70CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
71CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
72INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
73INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
74INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
75DELETE     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;
76SELECT * FROM d1.t1 ORDER BY c1;
77SELECT * FROM d2.t2 ORDER BY c1;
78SELECT * FROM d3.t3 ORDER BY c1;
79DELETE     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;
80SELECT * FROM d1.t1 ORDER BY c1;
81SELECT * FROM d2.t2 ORDER BY c1;
82SELECT * FROM d3.t3 ORDER BY c1;
83DROP DATABASE d1;
84DROP DATABASE d2;
85DROP DATABASE d3;
86CREATE DATABASE d1;
87CREATE DATABASE d2;
88CREATE DATABASE d3;
89CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
90CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
91CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
92INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
93INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
94INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
95DELETE     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;
96SELECT * FROM d1.t1 ORDER BY c1;
97SELECT * FROM d2.t2 ORDER BY c1;
98SELECT * FROM d3.t3 ORDER BY c1;
99DELETE     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;
100SELECT * FROM d1.t1 ORDER BY c1;
101SELECT * FROM d2.t2 ORDER BY c1;
102SELECT * FROM d3.t3 ORDER BY c1;
103DROP DATABASE d1;
104DROP DATABASE d2;
105DROP DATABASE d3;
106CREATE DATABASE d1;
107CREATE DATABASE d2;
108CREATE DATABASE d3;
109CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
110CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
111CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
112INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
113INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
114INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
115DELETE     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;
116SELECT * FROM d1.t1 ORDER BY c1;
117SELECT * FROM d2.t2 ORDER BY c1;
118SELECT * FROM d3.t3 ORDER BY c1;
119DELETE     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;
120SELECT * FROM d1.t1 ORDER BY c1;
121SELECT * FROM d2.t2 ORDER BY c1;
122SELECT * FROM d3.t3 ORDER BY c1;
123DROP DATABASE d1;
124DROP DATABASE d2;
125DROP DATABASE d3;
126CREATE DATABASE d1;
127CREATE DATABASE d2;
128CREATE DATABASE d3;
129CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
130CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
131CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
132INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
133INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
134INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
135DELETE 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;
136SELECT * FROM d1.t1 ORDER BY c1;
137SELECT * FROM d2.t2 ORDER BY c1;
138SELECT * FROM d3.t3 ORDER BY c1;
139DELETE 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;
140SELECT * FROM d1.t1 ORDER BY c1;
141SELECT * FROM d2.t2 ORDER BY c1;
142SELECT * FROM d3.t3 ORDER BY c1;
143DROP DATABASE d1;
144DROP DATABASE d2;
145DROP DATABASE d3;
146CREATE DATABASE d1;
147CREATE DATABASE d2;
148CREATE DATABASE d3;
149CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
150CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
151CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
152INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
153INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
154INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
155DELETE 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;
156SELECT * FROM d1.t1 ORDER BY c1;
157SELECT * FROM d2.t2 ORDER BY c1;
158SELECT * FROM d3.t3 ORDER BY c1;
159DELETE 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;
160SELECT * FROM d1.t1 ORDER BY c1;
161SELECT * FROM d2.t2 ORDER BY c1;
162SELECT * FROM d3.t3 ORDER BY c1;
163DROP DATABASE d1;
164DROP DATABASE d2;
165DROP DATABASE d3;
166CREATE DATABASE d1;
167CREATE DATABASE d2;
168CREATE DATABASE d3;
169CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
170CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
171CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
172INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
173INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
174INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
175DELETE 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;
176SELECT * FROM d1.t1 ORDER BY c1;
177SELECT * FROM d2.t2 ORDER BY c1;
178SELECT * FROM d3.t3 ORDER BY c1;
179DELETE 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;
180SELECT * FROM d1.t1 ORDER BY c1;
181SELECT * FROM d2.t2 ORDER BY c1;
182SELECT * FROM d3.t3 ORDER BY c1;
183DROP DATABASE d1;
184DROP DATABASE d2;
185DROP DATABASE d3;
186CREATE DATABASE d1;
187CREATE DATABASE d2;
188CREATE DATABASE d3;
189CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
190CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
191CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
192INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
193INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
194INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
195DELETE 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;
196SELECT * FROM d1.t1 ORDER BY c1;
197SELECT * FROM d2.t2 ORDER BY c1;
198SELECT * FROM d3.t3 ORDER BY c1;
199DELETE 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;
200SELECT * FROM d1.t1 ORDER BY c1;
201SELECT * FROM d2.t2 ORDER BY c1;
202SELECT * FROM d3.t3 ORDER BY c1;
203DROP DATABASE d1;
204DROP DATABASE d2;
205DROP DATABASE d3;
206CREATE DATABASE d1;
207CREATE DATABASE d2;
208CREATE DATABASE d3;
209CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
210CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
211CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
212INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
213INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
214INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
215DELETE 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;
216SELECT * FROM d1.t1 ORDER BY c1;
217SELECT * FROM d2.t2 ORDER BY c1;
218SELECT * FROM d3.t3 ORDER BY c1;
219DELETE 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;
220SELECT * FROM d1.t1 ORDER BY c1;
221SELECT * FROM d2.t2 ORDER BY c1;
222SELECT * FROM d3.t3 ORDER BY c1;
223DROP DATABASE d1;
224DROP DATABASE d2;
225DROP DATABASE d3;
226CREATE DATABASE d1;
227CREATE DATABASE d2;
228CREATE DATABASE d3;
229CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
230CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
231CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
232INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
233INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
234INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
235DELETE 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;
236SELECT * FROM d1.t1 ORDER BY c1;
237SELECT * FROM d2.t2 ORDER BY c1;
238SELECT * FROM d3.t3 ORDER BY c1;
239DELETE 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;
240SELECT * FROM d1.t1 ORDER BY c1;
241SELECT * FROM d2.t2 ORDER BY c1;
242SELECT * FROM d3.t3 ORDER BY c1;
243DROP DATABASE d1;
244DROP DATABASE d2;
245DROP DATABASE d3;
246CREATE DATABASE d1;
247CREATE DATABASE d2;
248CREATE DATABASE d3;
249CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
250CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
251CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
252INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
253INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
254INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
255DELETE   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;
256SELECT * FROM d1.t1 ORDER BY c1;
257SELECT * FROM d2.t2 ORDER BY c1;
258SELECT * FROM d3.t3 ORDER BY c1;
259DELETE   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;
260SELECT * FROM d1.t1 ORDER BY c1;
261SELECT * FROM d2.t2 ORDER BY c1;
262SELECT * FROM d3.t3 ORDER BY c1;
263DROP DATABASE d1;
264DROP DATABASE d2;
265DROP DATABASE d3;
266CREATE DATABASE d1;
267CREATE DATABASE d2;
268CREATE DATABASE d3;
269CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
270CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
271CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
272INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
273INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
274INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
275DELETE   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;
276SELECT * FROM d1.t1 ORDER BY c1;
277SELECT * FROM d2.t2 ORDER BY c1;
278SELECT * FROM d3.t3 ORDER BY c1;
279DELETE   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;
280SELECT * FROM d1.t1 ORDER BY c1;
281SELECT * FROM d2.t2 ORDER BY c1;
282SELECT * FROM d3.t3 ORDER BY c1;
283DROP DATABASE d1;
284DROP DATABASE d2;
285DROP DATABASE d3;
286CREATE DATABASE d1;
287CREATE DATABASE d2;
288CREATE DATABASE d3;
289CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
290CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
291CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
292INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
293INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
294INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
295DELETE   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;
296SELECT * FROM d1.t1 ORDER BY c1;
297SELECT * FROM d2.t2 ORDER BY c1;
298SELECT * FROM d3.t3 ORDER BY c1;
299DELETE   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;
300SELECT * FROM d1.t1 ORDER BY c1;
301SELECT * FROM d2.t2 ORDER BY c1;
302SELECT * FROM d3.t3 ORDER BY c1;
303DROP DATABASE d1;
304DROP DATABASE d2;
305DROP DATABASE d3;
306CREATE DATABASE d1;
307CREATE DATABASE d2;
308CREATE DATABASE d3;
309CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
310CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
311CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
312INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
313INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
314INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
315DELETE   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;
316SELECT * FROM d1.t1 ORDER BY c1;
317SELECT * FROM d2.t2 ORDER BY c1;
318SELECT * FROM d3.t3 ORDER BY c1;
319DELETE   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;
320SELECT * FROM d1.t1 ORDER BY c1;
321SELECT * FROM d2.t2 ORDER BY c1;
322SELECT * FROM d3.t3 ORDER BY c1;
323DROP DATABASE d1;
324DROP DATABASE d2;
325DROP DATABASE d3;
326CREATE DATABASE d1;
327CREATE DATABASE d2;
328CREATE DATABASE d3;
329CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
330CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
331CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
332INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
333INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
334INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
335DELETE   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;
336SELECT * FROM d1.t1 ORDER BY c1;
337SELECT * FROM d2.t2 ORDER BY c1;
338SELECT * FROM d3.t3 ORDER BY c1;
339DELETE   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;
340SELECT * FROM d1.t1 ORDER BY c1;
341SELECT * FROM d2.t2 ORDER BY c1;
342SELECT * FROM d3.t3 ORDER BY c1;
343DROP DATABASE d1;
344DROP DATABASE d2;
345DROP DATABASE d3;
346CREATE DATABASE d1;
347CREATE DATABASE d2;
348CREATE DATABASE d3;
349CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
350CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
351CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
352INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
353INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
354INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
355DELETE   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;
356SELECT * FROM d1.t1 ORDER BY c1;
357SELECT * FROM d2.t2 ORDER BY c1;
358SELECT * FROM d3.t3 ORDER BY c1;
359DELETE   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;
360SELECT * FROM d1.t1 ORDER BY c1;
361SELECT * FROM d2.t2 ORDER BY c1;
362SELECT * FROM d3.t3 ORDER BY c1;
363DROP DATABASE d1;
364DROP DATABASE d2;
365DROP DATABASE d3;
366CREATE DATABASE d1;
367CREATE DATABASE d2;
368CREATE DATABASE d3;
369CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
370CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
371CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
372INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
373INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
374INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
375DELETE 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;
376SELECT * FROM d1.t1 ORDER BY c1;
377SELECT * FROM d2.t2 ORDER BY c1;
378SELECT * FROM d3.t3 ORDER BY c1;
379DELETE 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;
380SELECT * FROM d1.t1 ORDER BY c1;
381SELECT * FROM d2.t2 ORDER BY c1;
382SELECT * FROM d3.t3 ORDER BY c1;
383DROP DATABASE d1;
384DROP DATABASE d2;
385DROP DATABASE d3;
386CREATE DATABASE d1;
387CREATE DATABASE d2;
388CREATE DATABASE d3;
389CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
390CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
391CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
392INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
393INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
394INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
395DELETE 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;
396SELECT * FROM d1.t1 ORDER BY c1;
397SELECT * FROM d2.t2 ORDER BY c1;
398SELECT * FROM d3.t3 ORDER BY c1;
399DELETE 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;
400SELECT * FROM d1.t1 ORDER BY c1;
401SELECT * FROM d2.t2 ORDER BY c1;
402SELECT * FROM d3.t3 ORDER BY c1;
403DROP DATABASE d1;
404DROP DATABASE d2;
405DROP DATABASE d3;
406CREATE DATABASE d1;
407CREATE DATABASE d2;
408CREATE DATABASE d3;
409CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
410CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
411CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
412INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
413INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
414INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
415DELETE 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;
416SELECT * FROM d1.t1 ORDER BY c1;
417SELECT * FROM d2.t2 ORDER BY c1;
418SELECT * FROM d3.t3 ORDER BY c1;
419DELETE 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;
420SELECT * FROM d1.t1 ORDER BY c1;
421SELECT * FROM d2.t2 ORDER BY c1;
422SELECT * FROM d3.t3 ORDER BY c1;
423DROP DATABASE d1;
424DROP DATABASE d2;
425DROP DATABASE d3;
426CREATE DATABASE d1;
427CREATE DATABASE d2;
428CREATE DATABASE d3;
429CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
430CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
431CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
432INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
433INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
434INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
435DELETE 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;
436SELECT * FROM d1.t1 ORDER BY c1;
437SELECT * FROM d2.t2 ORDER BY c1;
438SELECT * FROM d3.t3 ORDER BY c1;
439DELETE 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;
440SELECT * FROM d1.t1 ORDER BY c1;
441SELECT * FROM d2.t2 ORDER BY c1;
442SELECT * FROM d3.t3 ORDER BY c1;
443DROP DATABASE d1;
444DROP DATABASE d2;
445DROP DATABASE d3;
446CREATE DATABASE d1;
447CREATE DATABASE d2;
448CREATE DATABASE d3;
449CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
450CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
451CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
452INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
453INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
454INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
455DELETE 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;
456SELECT * FROM d1.t1 ORDER BY c1;
457SELECT * FROM d2.t2 ORDER BY c1;
458SELECT * FROM d3.t3 ORDER BY c1;
459DELETE 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;
460SELECT * FROM d1.t1 ORDER BY c1;
461SELECT * FROM d2.t2 ORDER BY c1;
462SELECT * FROM d3.t3 ORDER BY c1;
463DROP DATABASE d1;
464DROP DATABASE d2;
465DROP DATABASE d3;
466CREATE DATABASE d1;
467CREATE DATABASE d2;
468CREATE DATABASE d3;
469CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
470CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
471CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
472INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
473INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
474INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
475DELETE 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;
476SELECT * FROM d1.t1 ORDER BY c1;
477SELECT * FROM d2.t2 ORDER BY c1;
478SELECT * FROM d3.t3 ORDER BY c1;
479DELETE 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;
480SELECT * FROM d1.t1 ORDER BY c1;
481SELECT * FROM d2.t2 ORDER BY c1;
482SELECT * FROM d3.t3 ORDER BY c1;
483DROP DATABASE d1;
484DROP DATABASE d2;
485DROP DATABASE d3;
486
487