Debian Codegraph @

mysql-test/suite/engines/funcs/t/de_multi_table.test

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