1--disable_warnings
2--enable_warnings
3CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
4CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
5CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
6INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
7INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
8INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
9DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
10SELECT * FROM t1 ORDER BY c1;
11SELECT * FROM t2 ORDER BY c1;
12SELECT * FROM t3 ORDER BY c1;
13DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
14SELECT * FROM t1 ORDER BY c1;
15SELECT * FROM t2 ORDER BY c1;
16SELECT * FROM t3 ORDER BY c1;
17DROP TABLE t1,t2,t3;
18CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
19CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
20CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
21INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
22INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
23INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
24DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
25SELECT * FROM t1 ORDER BY c1;
26SELECT * FROM t2 ORDER BY c1;
27SELECT * FROM t3 ORDER BY c1;
28DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
29SELECT * FROM t1 ORDER BY c1;
30SELECT * FROM t2 ORDER BY c1;
31SELECT * FROM t3 ORDER BY c1;
32DROP TABLE t1,t2,t3;
33CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
34CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
35CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
36INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
37INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
38INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
39DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
40SELECT * FROM t1 ORDER BY c1;
41SELECT * FROM t2 ORDER BY c1;
42SELECT * FROM t3 ORDER BY c1;
43DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
44SELECT * FROM t1 ORDER BY c1;
45SELECT * FROM t2 ORDER BY c1;
46SELECT * FROM t3 ORDER BY c1;
47DROP TABLE t1,t2,t3;
48CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
49CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
50CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
51INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
52INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
53INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
54DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
55SELECT * FROM t1 ORDER BY c1;
56SELECT * FROM t2 ORDER BY c1;
57SELECT * FROM t3 ORDER BY c1;
58DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
59SELECT * FROM t1 ORDER BY c1;
60SELECT * FROM t2 ORDER BY c1;
61SELECT * FROM t3 ORDER BY c1;
62DROP TABLE t1,t2,t3;
63CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
64CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
65CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
66INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
67INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
68INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
69DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
70SELECT * FROM t1 ORDER BY c1;
71SELECT * FROM t2 ORDER BY c1;
72SELECT * FROM t3 ORDER BY c1;
73DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
74SELECT * FROM t1 ORDER BY c1;
75SELECT * FROM t2 ORDER BY c1;
76SELECT * FROM t3 ORDER BY c1;
77DROP TABLE t1,t2,t3;
78CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
79CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
80CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
81INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
82INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
83INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
84DELETE     t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
85SELECT * FROM t1 ORDER BY c1;
86SELECT * FROM t2 ORDER BY c1;
87SELECT * FROM t3 ORDER BY c1;
88DELETE     t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
89SELECT * FROM t1 ORDER BY c1;
90SELECT * FROM t2 ORDER BY c1;
91SELECT * FROM t3 ORDER BY c1;
92DROP TABLE t1,t2,t3;
93CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
94CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
95CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
96INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
97INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
98INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
99DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
100SELECT * FROM t1 ORDER BY c1;
101SELECT * FROM t2 ORDER BY c1;
102SELECT * FROM t3 ORDER BY c1;
103DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
104SELECT * FROM t1 ORDER BY c1;
105SELECT * FROM t2 ORDER BY c1;
106SELECT * FROM t3 ORDER BY c1;
107DROP TABLE t1,t2,t3;
108CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
109CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
110CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
111INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
112INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
113INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
114DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
115SELECT * FROM t1 ORDER BY c1;
116SELECT * FROM t2 ORDER BY c1;
117SELECT * FROM t3 ORDER BY c1;
118DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
119SELECT * FROM t1 ORDER BY c1;
120SELECT * FROM t2 ORDER BY c1;
121SELECT * FROM t3 ORDER BY c1;
122DROP TABLE t1,t2,t3;
123CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
124CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
125CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
126INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
127INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
128INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
129DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
130SELECT * FROM t1 ORDER BY c1;
131SELECT * FROM t2 ORDER BY c1;
132SELECT * FROM t3 ORDER BY c1;
133DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
134SELECT * FROM t1 ORDER BY c1;
135SELECT * FROM t2 ORDER BY c1;
136SELECT * FROM t3 ORDER BY c1;
137DROP TABLE t1,t2,t3;
138CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
139CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
140CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
141INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
142INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
143INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
144DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
145SELECT * FROM t1 ORDER BY c1;
146SELECT * FROM t2 ORDER BY c1;
147SELECT * FROM t3 ORDER BY c1;
148DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
149SELECT * FROM t1 ORDER BY c1;
150SELECT * FROM t2 ORDER BY c1;
151SELECT * FROM t3 ORDER BY c1;
152DROP TABLE t1,t2,t3;
153CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
154CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
155CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
156INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
157INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
158INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
159DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
160SELECT * FROM t1 ORDER BY c1;
161SELECT * FROM t2 ORDER BY c1;
162SELECT * FROM t3 ORDER BY c1;
163DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
164SELECT * FROM t1 ORDER BY c1;
165SELECT * FROM t2 ORDER BY c1;
166SELECT * FROM t3 ORDER BY c1;
167DROP TABLE t1,t2,t3;
168CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
169CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
170CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
171INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
172INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
173INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
174DELETE QUICK   t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
175SELECT * FROM t1 ORDER BY c1;
176SELECT * FROM t2 ORDER BY c1;
177SELECT * FROM t3 ORDER BY c1;
178DELETE QUICK   t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
179SELECT * FROM t1 ORDER BY c1;
180SELECT * FROM t2 ORDER BY c1;
181SELECT * FROM t3 ORDER BY c1;
182DROP TABLE t1,t2,t3;
183CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
184CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
185CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
186INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
187INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
188INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
189DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
190SELECT * FROM t1 ORDER BY c1;
191SELECT * FROM t2 ORDER BY c1;
192SELECT * FROM t3 ORDER BY c1;
193DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
194SELECT * FROM t1 ORDER BY c1;
195SELECT * FROM t2 ORDER BY c1;
196SELECT * FROM t3 ORDER BY c1;
197DROP TABLE t1,t2,t3;
198CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
199CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
200CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
201INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
202INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
203INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
204DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
205SELECT * FROM t1 ORDER BY c1;
206SELECT * FROM t2 ORDER BY c1;
207SELECT * FROM t3 ORDER BY c1;
208DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
209SELECT * FROM t1 ORDER BY c1;
210SELECT * FROM t2 ORDER BY c1;
211SELECT * FROM t3 ORDER BY c1;
212DROP TABLE t1,t2,t3;
213CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
214CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
215CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
216INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
217INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
218INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
219DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
220SELECT * FROM t1 ORDER BY c1;
221SELECT * FROM t2 ORDER BY c1;
222SELECT * FROM t3 ORDER BY c1;
223DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
224SELECT * FROM t1 ORDER BY c1;
225SELECT * FROM t2 ORDER BY c1;
226SELECT * FROM t3 ORDER BY c1;
227DROP TABLE t1,t2,t3;
228CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
229CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
230CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
231INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
232INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
233INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
234DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
235SELECT * FROM t1 ORDER BY c1;
236SELECT * FROM t2 ORDER BY c1;
237SELECT * FROM t3 ORDER BY c1;
238DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
239SELECT * FROM t1 ORDER BY c1;
240SELECT * FROM t2 ORDER BY c1;
241SELECT * FROM t3 ORDER BY c1;
242DROP TABLE t1,t2,t3;
243CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
244CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
245CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
246INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
247INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
248INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
249DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
250SELECT * FROM t1 ORDER BY c1;
251SELECT * FROM t2 ORDER BY c1;
252SELECT * FROM t3 ORDER BY c1;
253DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
254SELECT * FROM t1 ORDER BY c1;
255SELECT * FROM t2 ORDER BY c1;
256SELECT * FROM t3 ORDER BY c1;
257DROP TABLE t1,t2,t3;
258CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
259CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
260CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
261INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
262INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
263INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
264DELETE   IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
265SELECT * FROM t1 ORDER BY c1;
266SELECT * FROM t2 ORDER BY c1;
267SELECT * FROM t3 ORDER BY c1;
268DELETE   IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
269SELECT * FROM t1 ORDER BY c1;
270SELECT * FROM t2 ORDER BY c1;
271SELECT * FROM t3 ORDER BY c1;
272DROP TABLE t1,t2,t3;
273CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
274CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
275CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
276INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
277INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
278INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
279DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
280SELECT * FROM t1 ORDER BY c1;
281SELECT * FROM t2 ORDER BY c1;
282SELECT * FROM t3 ORDER BY c1;
283DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
284SELECT * FROM t1 ORDER BY c1;
285SELECT * FROM t2 ORDER BY c1;
286SELECT * FROM t3 ORDER BY c1;
287DROP TABLE t1,t2,t3;
288CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
289CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
290CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
291INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
292INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
293INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
294DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
295SELECT * FROM t1 ORDER BY c1;
296SELECT * FROM t2 ORDER BY c1;
297SELECT * FROM t3 ORDER BY c1;
298DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
299SELECT * FROM t1 ORDER BY c1;
300SELECT * FROM t2 ORDER BY c1;
301SELECT * FROM t3 ORDER BY c1;
302DROP TABLE t1,t2,t3;
303CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
304CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
305CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
306INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
307INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
308INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
309DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
310SELECT * FROM t1 ORDER BY c1;
311SELECT * FROM t2 ORDER BY c1;
312SELECT * FROM t3 ORDER BY c1;
313DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
314SELECT * FROM t1 ORDER BY c1;
315SELECT * FROM t2 ORDER BY c1;
316SELECT * FROM t3 ORDER BY c1;
317DROP TABLE t1,t2,t3;
318CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
319CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
320CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
321INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
322INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
323INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
324DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
325SELECT * FROM t1 ORDER BY c1;
326SELECT * FROM t2 ORDER BY c1;
327SELECT * FROM t3 ORDER BY c1;
328DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
329SELECT * FROM t1 ORDER BY c1;
330SELECT * FROM t2 ORDER BY c1;
331SELECT * FROM t3 ORDER BY c1;
332DROP TABLE t1,t2,t3;
333CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
334CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
335CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
336INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
337INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
338INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
339DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
340SELECT * FROM t1 ORDER BY c1;
341SELECT * FROM t2 ORDER BY c1;
342SELECT * FROM t3 ORDER BY c1;
343DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
344SELECT * FROM t1 ORDER BY c1;
345SELECT * FROM t2 ORDER BY c1;
346SELECT * FROM t3 ORDER BY c1;
347DROP TABLE t1,t2,t3;
348CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
349CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
350CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
351INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
352INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
353INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
354DELETE QUICK IGNORE t1, t2 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
355SELECT * FROM t1 ORDER BY c1;
356SELECT * FROM t2 ORDER BY c1;
357SELECT * FROM t3 ORDER BY c1;
358DELETE QUICK IGNORE t1.*, t2.*, t3 FROM t1, t2, t3 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
359SELECT * FROM t1 ORDER BY c1;
360SELECT * FROM t2 ORDER BY c1;
361SELECT * FROM t3 ORDER BY c1;
362DROP TABLE t1,t2,t3;
363
364