Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6;
3 --enable_warnings
4 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5 CREATE TABLE t2 (c1 TINYINT NOT NULL);
6 CREATE TABLE t3 (c1 TINYINT NOT NULL);
7 CREATE TABLE t4 (c1 TINYINT NOT NULL);
8 CREATE TABLE t5 (c1 TINYINT NOT NULL);
9 CREATE TABLE t6 (c1 TINYINT NOT NULL);
10 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
11 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
12 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
13 INSERT INTO t4 (c1) VALUES(10);
14 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
15 --sorted_result
16 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
17 --sorted_result
18 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
19 --sorted_result
20 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
21 DROP TABLE t1,t2,t3,t4,t5,t6;
22 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
23 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
24 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
25 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
26 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
27 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
28 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
29 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
30 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
31 INSERT INTO t4 (c1) VALUES(10);
32 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
33 --sorted_result
34 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
35 --sorted_result
36 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
37 --sorted_result
38 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
39 DROP TABLE t1,t2,t3,t4,t5,t6;
40 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
41 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
42 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
43 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
44 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
45 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
46 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
47 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
48 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
49 INSERT INTO t4 (c1) VALUES(10);
50 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
51 --sorted_result
52 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
53 --sorted_result
54 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
55 --sorted_result
56 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
57 DROP TABLE t1,t2,t3,t4,t5,t6;
58 CREATE TABLE t1 (c1 INT NOT NULL);
59 CREATE TABLE t2 (c1 INT NOT NULL);
60 CREATE TABLE t3 (c1 INT NOT NULL);
61 CREATE TABLE t4 (c1 INT NOT NULL);
62 CREATE TABLE t5 (c1 INT NOT NULL);
63 CREATE TABLE t6 (c1 INT NOT NULL);
64 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
65 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
66 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
67 INSERT INTO t4 (c1) VALUES(10);
68 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
69 --sorted_result
70 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
71 --sorted_result
72 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
73 --sorted_result
74 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
75 DROP TABLE t1,t2,t3,t4,t5,t6;
76 CREATE TABLE t1 (c1 INTEGER NOT NULL);
77 CREATE TABLE t2 (c1 INTEGER NOT NULL);
78 CREATE TABLE t3 (c1 INTEGER NOT NULL);
79 CREATE TABLE t4 (c1 INTEGER NOT NULL);
80 CREATE TABLE t5 (c1 INTEGER NOT NULL);
81 CREATE TABLE t6 (c1 INTEGER NOT NULL);
82 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
83 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
84 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
85 INSERT INTO t4 (c1) VALUES(10);
86 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
87 --sorted_result
88 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
89 --sorted_result
90 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
91 --sorted_result
92 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
93 DROP TABLE t1,t2,t3,t4,t5,t6;
94 CREATE TABLE t1 (c1 BIGINT NOT NULL);
95 CREATE TABLE t2 (c1 BIGINT NOT NULL);
96 CREATE TABLE t3 (c1 BIGINT NOT NULL);
97 CREATE TABLE t4 (c1 BIGINT NOT NULL);
98 CREATE TABLE t5 (c1 BIGINT NOT NULL);
99 CREATE TABLE t6 (c1 BIGINT NOT NULL);
100 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
101 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
102 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
103 INSERT INTO t4 (c1) VALUES(10);
104 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
105 --sorted_result
106 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
107 --sorted_result
108 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
109 --sorted_result
110 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
111 DROP TABLE t1,t2,t3,t4,t5,t6;
112 CREATE TABLE t1 (c1 TINYINT NOT NULL);
113 CREATE TABLE t2 (c1 TINYINT NOT NULL);
114 CREATE TABLE t3 (c1 TINYINT NOT NULL);
115 CREATE TABLE t4 (c1 TINYINT NOT NULL);
116 CREATE TABLE t5 (c1 TINYINT NOT NULL);
117 CREATE TABLE t6 (c1 TINYINT NOT NULL);
118 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
119 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
120 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
121 INSERT INTO t4 (c1) VALUES(10);
122 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
123 --sorted_result
124 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
125 --sorted_result
126 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
127 --sorted_result
128 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
129 DROP TABLE t1,t2,t3,t4,t5,t6;
130 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
131 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
132 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
133 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
134 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
135 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
136 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
137 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
138 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
139 INSERT INTO t4 (c1) VALUES(10);
140 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
141 --sorted_result
142 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
143 --sorted_result
144 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
145 --sorted_result
146 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
147 DROP TABLE t1,t2,t3,t4,t5,t6;
148 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
149 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
150 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
151 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
152 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
153 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
154 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
155 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
156 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
157 INSERT INTO t4 (c1) VALUES(10);
158 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
159 --sorted_result
160 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
161 --sorted_result
162 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
163 --sorted_result
164 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
165 DROP TABLE t1,t2,t3,t4,t5,t6;
166 CREATE TABLE t1 (c1 INT NOT NULL);
167 CREATE TABLE t2 (c1 INT NOT NULL);
168 CREATE TABLE t3 (c1 INT NOT NULL);
169 CREATE TABLE t4 (c1 INT NOT NULL);
170 CREATE TABLE t5 (c1 INT NOT NULL);
171 CREATE TABLE t6 (c1 INT NOT NULL);
172 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
173 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
174 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
175 INSERT INTO t4 (c1) VALUES(10);
176 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
177 --sorted_result
178 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
179 --sorted_result
180 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
181 --sorted_result
182 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
183 DROP TABLE t1,t2,t3,t4,t5,t6;
184 CREATE TABLE t1 (c1 INTEGER NOT NULL);
185 CREATE TABLE t2 (c1 INTEGER NOT NULL);
186 CREATE TABLE t3 (c1 INTEGER NOT NULL);
187 CREATE TABLE t4 (c1 INTEGER NOT NULL);
188 CREATE TABLE t5 (c1 INTEGER NOT NULL);
189 CREATE TABLE t6 (c1 INTEGER NOT NULL);
190 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
191 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
192 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
193 INSERT INTO t4 (c1) VALUES(10);
194 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
195 --sorted_result
196 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
197 --sorted_result
198 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
199 --sorted_result
200 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
201 DROP TABLE t1,t2,t3,t4,t5,t6;
202 CREATE TABLE t1 (c1 BIGINT NOT NULL);
203 CREATE TABLE t2 (c1 BIGINT NOT NULL);
204 CREATE TABLE t3 (c1 BIGINT NOT NULL);
205 CREATE TABLE t4 (c1 BIGINT NOT NULL);
206 CREATE TABLE t5 (c1 BIGINT NOT NULL);
207 CREATE TABLE t6 (c1 BIGINT NOT NULL);
208 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
209 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
210 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
211 INSERT INTO t4 (c1) VALUES(10);
212 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
213 --sorted_result
214 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
215 --sorted_result
216 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
217 --sorted_result
218 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
219 DROP TABLE t1,t2,t3,t4,t5,t6;
220 CREATE TABLE t1 (c1 TINYINT NOT NULL);
221 CREATE TABLE t2 (c1 TINYINT NOT NULL);
222 CREATE TABLE t3 (c1 TINYINT NOT NULL);
223 CREATE TABLE t4 (c1 TINYINT NOT NULL);
224 CREATE TABLE t5 (c1 TINYINT NOT NULL);
225 CREATE TABLE t6 (c1 TINYINT NOT NULL);
226 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
227 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
228 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
229 INSERT INTO t4 (c1) VALUES(10);
230 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
231 --sorted_result
232 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
233 --sorted_result
234 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
235 --sorted_result
236 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
237 DROP TABLE t1,t2,t3,t4,t5,t6;
238 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
239 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
240 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
241 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
242 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
243 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
244 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
245 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
246 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
247 INSERT INTO t4 (c1) VALUES(10);
248 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
249 --sorted_result
250 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
251 --sorted_result
252 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
253 --sorted_result
254 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
255 DROP TABLE t1,t2,t3,t4,t5,t6;
256 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
257 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
258 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
259 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
260 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
261 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
262 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
263 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
264 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
265 INSERT INTO t4 (c1) VALUES(10);
266 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
267 --sorted_result
268 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
269 --sorted_result
270 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
271 --sorted_result
272 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
273 DROP TABLE t1,t2,t3,t4,t5,t6;
274 CREATE TABLE t1 (c1 INT NOT NULL);
275 CREATE TABLE t2 (c1 INT NOT NULL);
276 CREATE TABLE t3 (c1 INT NOT NULL);
277 CREATE TABLE t4 (c1 INT NOT NULL);
278 CREATE TABLE t5 (c1 INT NOT NULL);
279 CREATE TABLE t6 (c1 INT NOT NULL);
280 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
281 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
282 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
283 INSERT INTO t4 (c1) VALUES(10);
284 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
285 --sorted_result
286 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
287 --sorted_result
288 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
289 --sorted_result
290 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
291 DROP TABLE t1,t2,t3,t4,t5,t6;
292 CREATE TABLE t1 (c1 INTEGER NOT NULL);
293 CREATE TABLE t2 (c1 INTEGER NOT NULL);
294 CREATE TABLE t3 (c1 INTEGER NOT NULL);
295 CREATE TABLE t4 (c1 INTEGER NOT NULL);
296 CREATE TABLE t5 (c1 INTEGER NOT NULL);
297 CREATE TABLE t6 (c1 INTEGER NOT NULL);
298 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
299 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
300 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
301 INSERT INTO t4 (c1) VALUES(10);
302 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
303 --sorted_result
304 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
305 --sorted_result
306 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
307 --sorted_result
308 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
309 DROP TABLE t1,t2,t3,t4,t5,t6;
310 CREATE TABLE t1 (c1 BIGINT NOT NULL);
311 CREATE TABLE t2 (c1 BIGINT NOT NULL);
312 CREATE TABLE t3 (c1 BIGINT NOT NULL);
313 CREATE TABLE t4 (c1 BIGINT NOT NULL);
314 CREATE TABLE t5 (c1 BIGINT NOT NULL);
315 CREATE TABLE t6 (c1 BIGINT NOT NULL);
316 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
317 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
318 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
319 INSERT INTO t4 (c1) VALUES(10);
320 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
321 --sorted_result
322 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
323 --sorted_result
324 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
325 --sorted_result
326 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
327 DROP TABLE t1,t2,t3,t4,t5,t6;
328 CREATE TABLE t1 (c1 TINYINT NOT NULL);
329 CREATE TABLE t2 (c1 TINYINT NOT NULL);
330 CREATE TABLE t3 (c1 TINYINT NOT NULL);
331 CREATE TABLE t4 (c1 TINYINT NOT NULL);
332 CREATE TABLE t5 (c1 TINYINT NOT NULL);
333 CREATE TABLE t6 (c1 TINYINT NOT NULL);
334 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
335 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
336 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
337 INSERT INTO t4 (c1) VALUES(10);
338 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
339 --sorted_result
340 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
341 --sorted_result
342 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
343 --sorted_result
344 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
345 DROP TABLE t1,t2,t3,t4,t5,t6;
346 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
347 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
348 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
349 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
350 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
351 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
352 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
353 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
354 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
355 INSERT INTO t4 (c1) VALUES(10);
356 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
357 --sorted_result
358 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
359 --sorted_result
360 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
361 --sorted_result
362 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
363 DROP TABLE t1,t2,t3,t4,t5,t6;
364 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
365 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
366 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
367 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
368 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
369 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
370 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
371 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
372 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
373 INSERT INTO t4 (c1) VALUES(10);
374 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
375 --sorted_result
376 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
377 --sorted_result
378 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
379 --sorted_result
380 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
381 DROP TABLE t1,t2,t3,t4,t5,t6;
382 CREATE TABLE t1 (c1 INT NOT NULL);
383 CREATE TABLE t2 (c1 INT NOT NULL);
384 CREATE TABLE t3 (c1 INT NOT NULL);
385 CREATE TABLE t4 (c1 INT NOT NULL);
386 CREATE TABLE t5 (c1 INT NOT NULL);
387 CREATE TABLE t6 (c1 INT NOT NULL);
388 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
389 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
390 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
391 INSERT INTO t4 (c1) VALUES(10);
392 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
393 --sorted_result
394 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
395 --sorted_result
396 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
397 --sorted_result
398 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
399 DROP TABLE t1,t2,t3,t4,t5,t6;
400 CREATE TABLE t1 (c1 INTEGER NOT NULL);
401 CREATE TABLE t2 (c1 INTEGER NOT NULL);
402 CREATE TABLE t3 (c1 INTEGER NOT NULL);
403 CREATE TABLE t4 (c1 INTEGER NOT NULL);
404 CREATE TABLE t5 (c1 INTEGER NOT NULL);
405 CREATE TABLE t6 (c1 INTEGER NOT NULL);
406 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
407 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
408 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
409 INSERT INTO t4 (c1) VALUES(10);
410 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
411 --sorted_result
412 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
413 --sorted_result
414 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
415 --sorted_result
416 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
417 DROP TABLE t1,t2,t3,t4,t5,t6;
418 CREATE TABLE t1 (c1 BIGINT NOT NULL);
419 CREATE TABLE t2 (c1 BIGINT NOT NULL);
420 CREATE TABLE t3 (c1 BIGINT NOT NULL);
421 CREATE TABLE t4 (c1 BIGINT NOT NULL);
422 CREATE TABLE t5 (c1 BIGINT NOT NULL);
423 CREATE TABLE t6 (c1 BIGINT NOT NULL);
424 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
425 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
426 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
427 INSERT INTO t4 (c1) VALUES(10);
428 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
429 --sorted_result
430 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
431 --sorted_result
432 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
433 --sorted_result
434 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
435 DROP TABLE t1,t2,t3,t4,t5,t6;
436 CREATE TABLE t1 (c1 TINYINT NOT NULL);
437 CREATE TABLE t2 (c1 TINYINT NOT NULL);
438 CREATE TABLE t3 (c1 TINYINT NOT NULL);
439 CREATE TABLE t4 (c1 TINYINT NOT NULL);
440 CREATE TABLE t5 (c1 TINYINT NOT NULL);
441 CREATE TABLE t6 (c1 TINYINT NOT NULL);
442 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
443 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
444 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
445 INSERT INTO t4 (c1) VALUES(10);
446 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
447 --sorted_result
448 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
449 --sorted_result
450 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
451 --sorted_result
452 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
453 DROP TABLE t1,t2,t3,t4,t5,t6;
454 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
455 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
456 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
457 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
458 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
459 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
460 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
461 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
462 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
463 INSERT INTO t4 (c1) VALUES(10);
464 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
465 --sorted_result
466 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
467 --sorted_result
468 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
469 --sorted_result
470 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
471 DROP TABLE t1,t2,t3,t4,t5,t6;
472 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
473 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
474 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
475 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
476 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
477 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
478 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
479 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
480 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
481 INSERT INTO t4 (c1) VALUES(10);
482 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
483 --sorted_result
484 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
485 --sorted_result
486 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
487 --sorted_result
488 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
489 DROP TABLE t1,t2,t3,t4,t5,t6;
490 CREATE TABLE t1 (c1 INT NOT NULL);
491 CREATE TABLE t2 (c1 INT NOT NULL);
492 CREATE TABLE t3 (c1 INT NOT NULL);
493 CREATE TABLE t4 (c1 INT NOT NULL);
494 CREATE TABLE t5 (c1 INT NOT NULL);
495 CREATE TABLE t6 (c1 INT NOT NULL);
496 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
497 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
498 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
499 INSERT INTO t4 (c1) VALUES(10);
500 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
501 --sorted_result
502 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
503 --sorted_result
504 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
505 --sorted_result
506 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
507 DROP TABLE t1,t2,t3,t4,t5,t6;
508 CREATE TABLE t1 (c1 INTEGER NOT NULL);
509 CREATE TABLE t2 (c1 INTEGER NOT NULL);
510 CREATE TABLE t3 (c1 INTEGER NOT NULL);
511 CREATE TABLE t4 (c1 INTEGER NOT NULL);
512 CREATE TABLE t5 (c1 INTEGER NOT NULL);
513 CREATE TABLE t6 (c1 INTEGER NOT NULL);
514 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
515 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
516 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
517 INSERT INTO t4 (c1) VALUES(10);
518 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
519 --sorted_result
520 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
521 --sorted_result
522 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
523 --sorted_result
524 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
525 DROP TABLE t1,t2,t3,t4,t5,t6;
526 CREATE TABLE t1 (c1 BIGINT NOT NULL);
527 CREATE TABLE t2 (c1 BIGINT NOT NULL);
528 CREATE TABLE t3 (c1 BIGINT NOT NULL);
529 CREATE TABLE t4 (c1 BIGINT NOT NULL);
530 CREATE TABLE t5 (c1 BIGINT NOT NULL);
531 CREATE TABLE t6 (c1 BIGINT NOT NULL);
532 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
533 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
534 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
535 INSERT INTO t4 (c1) VALUES(10);
536 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
537 --sorted_result
538 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
539 --sorted_result
540 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
541 --sorted_result
542 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
543 DROP TABLE t1,t2,t3,t4,t5,t6;
544 CREATE TABLE t1 (c1 TINYINT NOT NULL);
545 CREATE TABLE t2 (c1 TINYINT NOT NULL);
546 CREATE TABLE t3 (c1 TINYINT NOT NULL);
547 CREATE TABLE t4 (c1 TINYINT NOT NULL);
548 CREATE TABLE t5 (c1 TINYINT NOT NULL);
549 CREATE TABLE t6 (c1 TINYINT NOT NULL);
550 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
551 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
552 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
553 INSERT INTO t4 (c1) VALUES(10);
554 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
555 --sorted_result
556 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
557 --sorted_result
558 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
559 --sorted_result
560 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
561 DROP TABLE t1,t2,t3,t4,t5,t6;
562 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
563 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
564 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
565 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
566 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
567 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
568 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
569 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
570 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
571 INSERT INTO t4 (c1) VALUES(10);
572 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
573 --sorted_result
574 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
575 --sorted_result
576 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
577 --sorted_result
578 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
579 DROP TABLE t1,t2,t3,t4,t5,t6;
580 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
581 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
582 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
583 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
584 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
585 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
586 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
587 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
588 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
589 INSERT INTO t4 (c1) VALUES(10);
590 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
591 --sorted_result
592 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
593 --sorted_result
594 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
595 --sorted_result
596 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
597 DROP TABLE t1,t2,t3,t4,t5,t6;
598 CREATE TABLE t1 (c1 INT NOT NULL);
599 CREATE TABLE t2 (c1 INT NOT NULL);
600 CREATE TABLE t3 (c1 INT NOT NULL);
601 CREATE TABLE t4 (c1 INT NOT NULL);
602 CREATE TABLE t5 (c1 INT NOT NULL);
603 CREATE TABLE t6 (c1 INT NOT NULL);
604 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
605 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
606 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
607 INSERT INTO t4 (c1) VALUES(10);
608 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
609 --sorted_result
610 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
611 --sorted_result
612 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
613 --sorted_result
614 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
615 DROP TABLE t1,t2,t3,t4,t5,t6;
616 CREATE TABLE t1 (c1 INTEGER NOT NULL);
617 CREATE TABLE t2 (c1 INTEGER NOT NULL);
618 CREATE TABLE t3 (c1 INTEGER NOT NULL);
619 CREATE TABLE t4 (c1 INTEGER NOT NULL);
620 CREATE TABLE t5 (c1 INTEGER NOT NULL);
621 CREATE TABLE t6 (c1 INTEGER NOT NULL);
622 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
623 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
624 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
625 INSERT INTO t4 (c1) VALUES(10);
626 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
627 --sorted_result
628 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
629 --sorted_result
630 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
631 --sorted_result
632 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
633 DROP TABLE t1,t2,t3,t4,t5,t6;
634 CREATE TABLE t1 (c1 BIGINT NOT NULL);
635 CREATE TABLE t2 (c1 BIGINT NOT NULL);
636 CREATE TABLE t3 (c1 BIGINT NOT NULL);
637 CREATE TABLE t4 (c1 BIGINT NOT NULL);
638 CREATE TABLE t5 (c1 BIGINT NOT NULL);
639 CREATE TABLE t6 (c1 BIGINT NOT NULL);
640 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
641 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
642 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
643 INSERT INTO t4 (c1) VALUES(10);
644 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
645 --sorted_result
646 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
647 --sorted_result
648 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
649 --sorted_result
650 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
651 DROP TABLE t1,t2,t3,t4,t5,t6;
652 CREATE TABLE t1 (c1 TINYINT NOT NULL);
653 CREATE TABLE t2 (c1 TINYINT NOT NULL);
654 CREATE TABLE t3 (c1 TINYINT NOT NULL);
655 CREATE TABLE t4 (c1 TINYINT NOT NULL);
656 CREATE TABLE t5 (c1 TINYINT NOT NULL);
657 CREATE TABLE t6 (c1 TINYINT NOT NULL);
658 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
659 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
660 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
661 INSERT INTO t4 (c1) VALUES(10);
662 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
663 --sorted_result
664 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
665 --sorted_result
666 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
667 --sorted_result
668 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
669 DROP TABLE t1,t2,t3,t4,t5,t6;
670 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
671 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
672 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
673 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
674 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
675 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
676 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
677 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
678 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
679 INSERT INTO t4 (c1) VALUES(10);
680 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
681 --sorted_result
682 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
683 --sorted_result
684 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
685 --sorted_result
686 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
687 DROP TABLE t1,t2,t3,t4,t5,t6;
688 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
689 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
690 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
691 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
692 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
693 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
694 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
695 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
696 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
697 INSERT INTO t4 (c1) VALUES(10);
698 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
699 --sorted_result
700 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
701 --sorted_result
702 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
703 --sorted_result
704 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
705 DROP TABLE t1,t2,t3,t4,t5,t6;
706 CREATE TABLE t1 (c1 INT NOT NULL);
707 CREATE TABLE t2 (c1 INT NOT NULL);
708 CREATE TABLE t3 (c1 INT NOT NULL);
709 CREATE TABLE t4 (c1 INT NOT NULL);
710 CREATE TABLE t5 (c1 INT NOT NULL);
711 CREATE TABLE t6 (c1 INT NOT NULL);
712 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
713 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
714 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
715 INSERT INTO t4 (c1) VALUES(10);
716 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
717 --sorted_result
718 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
719 --sorted_result
720 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
721 --sorted_result
722 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
723 DROP TABLE t1,t2,t3,t4,t5,t6;
724 CREATE TABLE t1 (c1 INTEGER NOT NULL);
725 CREATE TABLE t2 (c1 INTEGER NOT NULL);
726 CREATE TABLE t3 (c1 INTEGER NOT NULL);
727 CREATE TABLE t4 (c1 INTEGER NOT NULL);
728 CREATE TABLE t5 (c1 INTEGER NOT NULL);
729 CREATE TABLE t6 (c1 INTEGER NOT NULL);
730 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
731 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
732 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
733 INSERT INTO t4 (c1) VALUES(10);
734 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
735 --sorted_result
736 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
737 --sorted_result
738 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
739 --sorted_result
740 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
741 DROP TABLE t1,t2,t3,t4,t5,t6;
742 CREATE TABLE t1 (c1 BIGINT NOT NULL);
743 CREATE TABLE t2 (c1 BIGINT NOT NULL);
744 CREATE TABLE t3 (c1 BIGINT NOT NULL);
745 CREATE TABLE t4 (c1 BIGINT NOT NULL);
746 CREATE TABLE t5 (c1 BIGINT NOT NULL);
747 CREATE TABLE t6 (c1 BIGINT NOT NULL);
748 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
749 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
750 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
751 INSERT INTO t4 (c1) VALUES(10);
752 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
753 --sorted_result
754 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
755 --sorted_result
756 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
757 --sorted_result
758 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
759 DROP TABLE t1,t2,t3,t4,t5,t6;
760 CREATE TABLE t1 (c1 TINYINT NOT NULL);
761 CREATE TABLE t2 (c1 TINYINT NOT NULL);
762 CREATE TABLE t3 (c1 TINYINT NOT NULL);
763 CREATE TABLE t4 (c1 TINYINT NOT NULL);
764 CREATE TABLE t5 (c1 TINYINT NOT NULL);
765 CREATE TABLE t6 (c1 TINYINT NOT NULL);
766 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
767 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
768 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
769 INSERT INTO t4 (c1) VALUES(10);
770 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
771 --sorted_result
772 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
773 --sorted_result
774 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
775 --sorted_result
776 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
777 DROP TABLE t1,t2,t3,t4,t5,t6;
778 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
779 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
780 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
781 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
782 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
783 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
784 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
785 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
786 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
787 INSERT INTO t4 (c1) VALUES(10);
788 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
789 --sorted_result
790 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
791 --sorted_result
792 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
793 --sorted_result
794 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
795 DROP TABLE t1,t2,t3,t4,t5,t6;
796 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
797 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
798 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
799 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
800 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
801 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
802 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
803 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
804 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
805 INSERT INTO t4 (c1) VALUES(10);
806 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
807 --sorted_result
808 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
809 --sorted_result
810 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
811 --sorted_result
812 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
813 DROP TABLE t1,t2,t3,t4,t5,t6;
814 CREATE TABLE t1 (c1 INT NOT NULL);
815 CREATE TABLE t2 (c1 INT NOT NULL);
816 CREATE TABLE t3 (c1 INT NOT NULL);
817 CREATE TABLE t4 (c1 INT NOT NULL);
818 CREATE TABLE t5 (c1 INT NOT NULL);
819 CREATE TABLE t6 (c1 INT NOT NULL);
820 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
821 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
822 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
823 INSERT INTO t4 (c1) VALUES(10);
824 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
825 --sorted_result
826 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
827 --sorted_result
828 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
829 --sorted_result
830 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
831 DROP TABLE t1,t2,t3,t4,t5,t6;
832 CREATE TABLE t1 (c1 INTEGER NOT NULL);
833 CREATE TABLE t2 (c1 INTEGER NOT NULL);
834 CREATE TABLE t3 (c1 INTEGER NOT NULL);
835 CREATE TABLE t4 (c1 INTEGER NOT NULL);
836 CREATE TABLE t5 (c1 INTEGER NOT NULL);
837 CREATE TABLE t6 (c1 INTEGER NOT NULL);
838 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
839 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
840 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
841 INSERT INTO t4 (c1) VALUES(10);
842 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
843 --sorted_result
844 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
845 --sorted_result
846 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
847 --sorted_result
848 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
849 DROP TABLE t1,t2,t3,t4,t5,t6;
850 CREATE TABLE t1 (c1 BIGINT NOT NULL);
851 CREATE TABLE t2 (c1 BIGINT NOT NULL);
852 CREATE TABLE t3 (c1 BIGINT NOT NULL);
853 CREATE TABLE t4 (c1 BIGINT NOT NULL);
854 CREATE TABLE t5 (c1 BIGINT NOT NULL);
855 CREATE TABLE t6 (c1 BIGINT NOT NULL);
856 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
857 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
858 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
859 INSERT INTO t4 (c1) VALUES(10);
860 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
861 --sorted_result
862 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
863 --sorted_result
864 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
865 --sorted_result
866 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
867 DROP TABLE t1,t2,t3,t4,t5,t6;
868 CREATE TABLE t1 (c1 TINYINT NOT NULL);
869 CREATE TABLE t2 (c1 TINYINT NOT NULL);
870 CREATE TABLE t3 (c1 TINYINT NOT NULL);
871 CREATE TABLE t4 (c1 TINYINT NOT NULL);
872 CREATE TABLE t5 (c1 TINYINT NOT NULL);
873 CREATE TABLE t6 (c1 TINYINT NOT NULL);
874 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
875 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
876 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
877 INSERT INTO t4 (c1) VALUES(10);
878 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
879 --sorted_result
880 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
881 --sorted_result
882 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
883 --sorted_result
884 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
885 DROP TABLE t1,t2,t3,t4,t5,t6;
886 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
887 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
888 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
889 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
890 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
891 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
892 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
893 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
894 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
895 INSERT INTO t4 (c1) VALUES(10);
896 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
897 --sorted_result
898 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
899 --sorted_result
900 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
901 --sorted_result
902 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
903 DROP TABLE t1,t2,t3,t4,t5,t6;
904 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
905 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
906 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
907 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
908 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
909 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
910 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
911 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
912 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
913 INSERT INTO t4 (c1) VALUES(10);
914 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
915 --sorted_result
916 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
917 --sorted_result
918 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
919 --sorted_result
920 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
921 DROP TABLE t1,t2,t3,t4,t5,t6;
922 CREATE TABLE t1 (c1 INT NOT NULL);
923 CREATE TABLE t2 (c1 INT NOT NULL);
924 CREATE TABLE t3 (c1 INT NOT NULL);
925 CREATE TABLE t4 (c1 INT NOT NULL);
926 CREATE TABLE t5 (c1 INT NOT NULL);
927 CREATE TABLE t6 (c1 INT NOT NULL);
928 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
929 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
930 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
931 INSERT INTO t4 (c1) VALUES(10);
932 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
933 --sorted_result
934 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
935 --sorted_result
936 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
937 --sorted_result
938 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
939 DROP TABLE t1,t2,t3,t4,t5,t6;
940 CREATE TABLE t1 (c1 INTEGER NOT NULL);
941 CREATE TABLE t2 (c1 INTEGER NOT NULL);
942 CREATE TABLE t3 (c1 INTEGER NOT NULL);
943 CREATE TABLE t4 (c1 INTEGER NOT NULL);
944 CREATE TABLE t5 (c1 INTEGER NOT NULL);
945 CREATE TABLE t6 (c1 INTEGER NOT NULL);
946 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
947 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
948 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
949 INSERT INTO t4 (c1) VALUES(10);
950 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
951 --sorted_result
952 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
953 --sorted_result
954 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
955 --sorted_result
956 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
957 DROP TABLE t1,t2,t3,t4,t5,t6;
958 CREATE TABLE t1 (c1 BIGINT NOT NULL);
959 CREATE TABLE t2 (c1 BIGINT NOT NULL);
960 CREATE TABLE t3 (c1 BIGINT NOT NULL);
961 CREATE TABLE t4 (c1 BIGINT NOT NULL);
962 CREATE TABLE t5 (c1 BIGINT NOT NULL);
963 CREATE TABLE t6 (c1 BIGINT NOT NULL);
964 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
965 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
966 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
967 INSERT INTO t4 (c1) VALUES(10);
968 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
969 --sorted_result
970 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
971 --sorted_result
972 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
973 --sorted_result
974 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
975 DROP TABLE t1,t2,t3,t4,t5,t6;
976 CREATE TABLE t1 (c1 TINYINT NOT NULL);
977 CREATE TABLE t2 (c1 TINYINT NOT NULL);
978 CREATE TABLE t3 (c1 TINYINT NOT NULL);
979 CREATE TABLE t4 (c1 TINYINT NOT NULL);
980 CREATE TABLE t5 (c1 TINYINT NOT NULL);
981 CREATE TABLE t6 (c1 TINYINT NOT NULL);
982 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
983 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
984 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
985 INSERT INTO t4 (c1) VALUES(10);
986 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
987 --sorted_result
988 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
989 --sorted_result
990 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
991 --sorted_result
992 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
993 DROP TABLE t1,t2,t3,t4,t5,t6;
994 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
995 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
996 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
997 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
998 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
999 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1000 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1001 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1002 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1003 INSERT INTO t4 (c1) VALUES(10);
1004 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1005 --sorted_result
1006 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1007 --sorted_result
1008 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1009 --sorted_result
1010 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1011 DROP TABLE t1,t2,t3,t4,t5,t6;
1012 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1013 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1014 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1015 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1016 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1017 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1018 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1019 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1020 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1021 INSERT INTO t4 (c1) VALUES(10);
1022 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1023 --sorted_result
1024 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1025 --sorted_result
1026 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1027 --sorted_result
1028 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1029 DROP TABLE t1,t2,t3,t4,t5,t6;
1030 CREATE TABLE t1 (c1 INT NOT NULL);
1031 CREATE TABLE t2 (c1 INT NOT NULL);
1032 CREATE TABLE t3 (c1 INT NOT NULL);
1033 CREATE TABLE t4 (c1 INT NOT NULL);
1034 CREATE TABLE t5 (c1 INT NOT NULL);
1035 CREATE TABLE t6 (c1 INT NOT NULL);
1036 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1037 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1038 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1039 INSERT INTO t4 (c1) VALUES(10);
1040 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1041 --sorted_result
1042 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1043 --sorted_result
1044 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1045 --sorted_result
1046 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1047 DROP TABLE t1,t2,t3,t4,t5,t6;
1048 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1049 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1050 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1051 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1052 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1053 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1054 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1055 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1056 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1057 INSERT INTO t4 (c1) VALUES(10);
1058 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1059 --sorted_result
1060 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1061 --sorted_result
1062 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1063 --sorted_result
1064 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1065 DROP TABLE t1,t2,t3,t4,t5,t6;
1066 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1067 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1068 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1069 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1070 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1071 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1072 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1073 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1074 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1075 INSERT INTO t4 (c1) VALUES(10);
1076 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1077 --sorted_result
1078 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1079 --sorted_result
1080 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1081 --sorted_result
1082 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1083 DROP TABLE t1,t2,t3,t4,t5,t6;
1084 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1085 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1086 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1087 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1088 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1089 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1090 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1091 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1092 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1093 INSERT INTO t4 (c1) VALUES(10);
1094 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1095 --sorted_result
1096 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1097 --sorted_result
1098 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1099 --sorted_result
1100 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1101 DROP TABLE t1,t2,t3,t4,t5,t6;
1102 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1103 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1104 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1105 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1106 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1107 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1108 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1109 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1110 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1111 INSERT INTO t4 (c1) VALUES(10);
1112 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1113 --sorted_result
1114 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1115 --sorted_result
1116 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1117 --sorted_result
1118 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1119 DROP TABLE t1,t2,t3,t4,t5,t6;
1120 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1121 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1122 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1123 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1124 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1125 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1126 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1127 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1128 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1129 INSERT INTO t4 (c1) VALUES(10);
1130 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1131 --sorted_result
1132 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1133 --sorted_result
1134 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1135 --sorted_result
1136 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1137 DROP TABLE t1,t2,t3,t4,t5,t6;
1138 CREATE TABLE t1 (c1 INT NOT NULL);
1139 CREATE TABLE t2 (c1 INT NOT NULL);
1140 CREATE TABLE t3 (c1 INT NOT NULL);
1141 CREATE TABLE t4 (c1 INT NOT NULL);
1142 CREATE TABLE t5 (c1 INT NOT NULL);
1143 CREATE TABLE t6 (c1 INT NOT NULL);
1144 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1145 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1146 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1147 INSERT INTO t4 (c1) VALUES(10);
1148 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1149 --sorted_result
1150 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1151 --sorted_result
1152 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1153 --sorted_result
1154 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1155 DROP TABLE t1,t2,t3,t4,t5,t6;
1156 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1157 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1158 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1159 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1160 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1161 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1162 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1163 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1164 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1165 INSERT INTO t4 (c1) VALUES(10);
1166 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1167 --sorted_result
1168 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1169 --sorted_result
1170 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1171 --sorted_result
1172 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1173 DROP TABLE t1,t2,t3,t4,t5,t6;
1174 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1175 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1176 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1177 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1178 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1179 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1180 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1181 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1182 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1183 INSERT INTO t4 (c1) VALUES(10);
1184 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1185 --sorted_result
1186 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1187 --sorted_result
1188 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1189 --sorted_result
1190 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1191 DROP TABLE t1,t2,t3,t4,t5,t6;
1192 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1193 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1194 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1195 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1196 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1197 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1198 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1199 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1200 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1201 INSERT INTO t4 (c1) VALUES(10);
1202 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1203 --sorted_result
1204 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1205 --sorted_result
1206 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1207 --sorted_result
1208 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1209 DROP TABLE t1,t2,t3,t4,t5,t6;
1210 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1211 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1212 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1213 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1214 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1215 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1216 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1217 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1218 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1219 INSERT INTO t4 (c1) VALUES(10);
1220 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1221 --sorted_result
1222 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1223 --sorted_result
1224 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1225 --sorted_result
1226 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1227 DROP TABLE t1,t2,t3,t4,t5,t6;
1228 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1229 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1230 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1231 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1232 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1233 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1234 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1235 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1236 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1237 INSERT INTO t4 (c1) VALUES(10);
1238 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1239 --sorted_result
1240 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1241 --sorted_result
1242 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1243 --sorted_result
1244 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1245 DROP TABLE t1,t2,t3,t4,t5,t6;
1246 CREATE TABLE t1 (c1 INT NOT NULL);
1247 CREATE TABLE t2 (c1 INT NOT NULL);
1248 CREATE TABLE t3 (c1 INT NOT NULL);
1249 CREATE TABLE t4 (c1 INT NOT NULL);
1250 CREATE TABLE t5 (c1 INT NOT NULL);
1251 CREATE TABLE t6 (c1 INT NOT NULL);
1252 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1253 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1254 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1255 INSERT INTO t4 (c1) VALUES(10);
1256 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1257 --sorted_result
1258 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1259 --sorted_result
1260 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1261 --sorted_result
1262 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1263 DROP TABLE t1,t2,t3,t4,t5,t6;
1264 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1265 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1266 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1267 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1268 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1269 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1270 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1271 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1272 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1273 INSERT INTO t4 (c1) VALUES(10);
1274 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1275 --sorted_result
1276 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1277 --sorted_result
1278 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1279 --sorted_result
1280 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1281 DROP TABLE t1,t2,t3,t4,t5,t6;
1282 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1283 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1284 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1285 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1286 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1287 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1288 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1289 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1290 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1291 INSERT INTO t4 (c1) VALUES(10);
1292 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1293 --sorted_result
1294 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1295 --sorted_result
1296 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1297 --sorted_result
1298 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1299 DROP TABLE t1,t2,t3,t4,t5,t6;
1300 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1301 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1302 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1303 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1304 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1305 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1306 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1307 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1308 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1309 INSERT INTO t4 (c1) VALUES(10);
1310 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1311 --sorted_result
1312 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1313 --sorted_result
1314 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1315 --sorted_result
1316 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1317 DROP TABLE t1,t2,t3,t4,t5,t6;
1318 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1319 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1320 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1321 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1322 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1323 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1324 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1325 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1326 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1327 INSERT INTO t4 (c1) VALUES(10);
1328 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1329 --sorted_result
1330 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1331 --sorted_result
1332 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1333 --sorted_result
1334 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1335 DROP TABLE t1,t2,t3,t4,t5,t6;
1336 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1337 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1338 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1339 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1340 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1341 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1342 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1343 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1344 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1345 INSERT INTO t4 (c1) VALUES(10);
1346 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1347 --sorted_result
1348 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1349 --sorted_result
1350 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1351 --sorted_result
1352 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1353 DROP TABLE t1,t2,t3,t4,t5,t6;
1354 CREATE TABLE t1 (c1 INT NOT NULL);
1355 CREATE TABLE t2 (c1 INT NOT NULL);
1356 CREATE TABLE t3 (c1 INT NOT NULL);
1357 CREATE TABLE t4 (c1 INT NOT NULL);
1358 CREATE TABLE t5 (c1 INT NOT NULL);
1359 CREATE TABLE t6 (c1 INT NOT NULL);
1360 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1361 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1362 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1363 INSERT INTO t4 (c1) VALUES(10);
1364 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1365 --sorted_result
1366 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1367 --sorted_result
1368 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1369 --sorted_result
1370 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1371 DROP TABLE t1,t2,t3,t4,t5,t6;
1372 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1373 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1374 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1375 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1376 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1377 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1378 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1379 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1380 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1381 INSERT INTO t4 (c1) VALUES(10);
1382 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1383 --sorted_result
1384 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1385 --sorted_result
1386 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1387 --sorted_result
1388 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1389 DROP TABLE t1,t2,t3,t4,t5,t6;
1390 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1391 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1392 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1393 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1394 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1395 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1396 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1397 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1398 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1399 INSERT INTO t4 (c1) VALUES(10);
1400 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1401 --sorted_result
1402 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1403 --sorted_result
1404 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1405 --sorted_result
1406 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1407 DROP TABLE t1,t2,t3,t4,t5,t6;
1408 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1409 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1410 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1411 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1412 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1413 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1414 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1415 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1416 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1417 INSERT INTO t4 (c1) VALUES(10);
1418 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1419 --sorted_result
1420 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1421 --sorted_result
1422 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1423 --sorted_result
1424 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1425 DROP TABLE t1,t2,t3,t4,t5,t6;
1426 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1427 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1428 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1429 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1430 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1431 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1432 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1433 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1434 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1435 INSERT INTO t4 (c1) VALUES(10);
1436 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1437 --sorted_result
1438 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1439 --sorted_result
1440 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1441 --sorted_result
1442 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1443 DROP TABLE t1,t2,t3,t4,t5,t6;
1444 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1445 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1446 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1447 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1448 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1449 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1450 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1451 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1452 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1453 INSERT INTO t4 (c1) VALUES(10);
1454 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1455 --sorted_result
1456 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1457 --sorted_result
1458 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1459 --sorted_result
1460 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1461 DROP TABLE t1,t2,t3,t4,t5,t6;
1462 CREATE TABLE t1 (c1 INT NOT NULL);
1463 CREATE TABLE t2 (c1 INT NOT NULL);
1464 CREATE TABLE t3 (c1 INT NOT NULL);
1465 CREATE TABLE t4 (c1 INT NOT NULL);
1466 CREATE TABLE t5 (c1 INT NOT NULL);
1467 CREATE TABLE t6 (c1 INT NOT NULL);
1468 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1469 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1470 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1471 INSERT INTO t4 (c1) VALUES(10);
1472 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1473 --sorted_result
1474 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1475 --sorted_result
1476 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1477 --sorted_result
1478 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1479 DROP TABLE t1,t2,t3,t4,t5,t6;
1480 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1481 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1482 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1483 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1484 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1485 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1486 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1487 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1488 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1489 INSERT INTO t4 (c1) VALUES(10);
1490 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1491 --sorted_result
1492 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1493 --sorted_result
1494 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1495 --sorted_result
1496 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1497 DROP TABLE t1,t2,t3,t4,t5,t6;
1498 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1499 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1500 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1501 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1502 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1503 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1504 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1505 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1506 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1507 INSERT INTO t4 (c1) VALUES(10);
1508 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1509 --sorted_result
1510 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1511 --sorted_result
1512 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1513 --sorted_result
1514 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1515 DROP TABLE t1,t2,t3,t4,t5,t6;
1516 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1517 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1518 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1519 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1520 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1521 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1522 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1523 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1524 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1525 INSERT INTO t4 (c1) VALUES(10);
1526 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1527 --sorted_result
1528 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1529 --sorted_result
1530 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1531 --sorted_result
1532 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1533 DROP TABLE t1,t2,t3,t4,t5,t6;
1534 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1535 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1536 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1537 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1538 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1539 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1540 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1541 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1542 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1543 INSERT INTO t4 (c1) VALUES(10);
1544 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1545 --sorted_result
1546 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1547 --sorted_result
1548 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1549 --sorted_result
1550 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1551 DROP TABLE t1,t2,t3,t4,t5,t6;
1552 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1553 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1554 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1555 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1556 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1557 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1558 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1559 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1560 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1561 INSERT INTO t4 (c1) VALUES(10);
1562 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1563 --sorted_result
1564 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1565 --sorted_result
1566 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1567 --sorted_result
1568 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1569 DROP TABLE t1,t2,t3,t4,t5,t6;
1570 CREATE TABLE t1 (c1 INT NOT NULL);
1571 CREATE TABLE t2 (c1 INT NOT NULL);
1572 CREATE TABLE t3 (c1 INT NOT NULL);
1573 CREATE TABLE t4 (c1 INT NOT NULL);
1574 CREATE TABLE t5 (c1 INT NOT NULL);
1575 CREATE TABLE t6 (c1 INT NOT NULL);
1576 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1577 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1578 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1579 INSERT INTO t4 (c1) VALUES(10);
1580 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1581 --sorted_result
1582 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1583 --sorted_result
1584 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1585 --sorted_result
1586 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1587 DROP TABLE t1,t2,t3,t4,t5,t6;
1588 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1589 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1590 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1591 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1592 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1593 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1594 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1595 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1596 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1597 INSERT INTO t4 (c1) VALUES(10);
1598 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1599 --sorted_result
1600 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1601 --sorted_result
1602 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1603 --sorted_result
1604 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1605 DROP TABLE t1,t2,t3,t4,t5,t6;
1606 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1607 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1608 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1609 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1610 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1611 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1612 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1613 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1614 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1615 INSERT INTO t4 (c1) VALUES(10);
1616 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1617 --sorted_result
1618 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1619 --sorted_result
1620 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1621 --sorted_result
1622 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1623 DROP TABLE t1,t2,t3,t4,t5,t6;
1624 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1625 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1626 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1627 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1628 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1629 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1630 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1631 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1632 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1633 INSERT INTO t4 (c1) VALUES(10);
1634 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1635 --sorted_result
1636 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1637 --sorted_result
1638 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1639 --sorted_result
1640 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1641 DROP TABLE t1,t2,t3,t4,t5,t6;
1642 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1643 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1644 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1645 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1646 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1647 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1648 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1649 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1650 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1651 INSERT INTO t4 (c1) VALUES(10);
1652 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1653 --sorted_result
1654 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1655 --sorted_result
1656 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1657 --sorted_result
1658 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1659 DROP TABLE t1,t2,t3,t4,t5,t6;
1660 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1661 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1662 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1663 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1664 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1665 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1666 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1667 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1668 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1669 INSERT INTO t4 (c1) VALUES(10);
1670 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1671 --sorted_result
1672 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1673 --sorted_result
1674 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1675 --sorted_result
1676 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1677 DROP TABLE t1,t2,t3,t4,t5,t6;
1678 CREATE TABLE t1 (c1 INT NOT NULL);
1679 CREATE TABLE t2 (c1 INT NOT NULL);
1680 CREATE TABLE t3 (c1 INT NOT NULL);
1681 CREATE TABLE t4 (c1 INT NOT NULL);
1682 CREATE TABLE t5 (c1 INT NOT NULL);
1683 CREATE TABLE t6 (c1 INT NOT NULL);
1684 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1685 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1686 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1687 INSERT INTO t4 (c1) VALUES(10);
1688 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1689 --sorted_result
1690 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1691 --sorted_result
1692 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1693 --sorted_result
1694 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1695 DROP TABLE t1,t2,t3,t4,t5,t6;
1696 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1697 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1698 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1699 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1700 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1701 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1702 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1703 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1704 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1705 INSERT INTO t4 (c1) VALUES(10);
1706 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1707 --sorted_result
1708 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1709 --sorted_result
1710 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1711 --sorted_result
1712 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1713 DROP TABLE t1,t2,t3,t4,t5,t6;
1714 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1715 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1716 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1717 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1718 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1719 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1720 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1721 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1722 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1723 INSERT INTO t4 (c1) VALUES(10);
1724 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1725 --sorted_result
1726 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1727 --sorted_result
1728 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1729 --sorted_result
1730 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1731 DROP TABLE t1,t2,t3,t4,t5,t6;
1732 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1733 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1734 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1735 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1736 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1737 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1738 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1739 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1740 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1741 INSERT INTO t4 (c1) VALUES(10);
1742 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1743 --sorted_result
1744 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1745 --sorted_result
1746 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1747 --sorted_result
1748 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1749 DROP TABLE t1,t2,t3,t4,t5,t6;
1750 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1751 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1752 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1753 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1754 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1755 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1756 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1757 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1758 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1759 INSERT INTO t4 (c1) VALUES(10);
1760 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1761 --sorted_result
1762 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1763 --sorted_result
1764 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1765 --sorted_result
1766 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1767 DROP TABLE t1,t2,t3,t4,t5,t6;
1768 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1769 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1770 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1771 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1772 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1773 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1774 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1775 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1776 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1777 INSERT INTO t4 (c1) VALUES(10);
1778 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1779 --sorted_result
1780 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1781 --sorted_result
1782 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1783 --sorted_result
1784 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1785 DROP TABLE t1,t2,t3,t4,t5,t6;
1786 CREATE TABLE t1 (c1 INT NOT NULL);
1787 CREATE TABLE t2 (c1 INT NOT NULL);
1788 CREATE TABLE t3 (c1 INT NOT NULL);
1789 CREATE TABLE t4 (c1 INT NOT NULL);
1790 CREATE TABLE t5 (c1 INT NOT NULL);
1791 CREATE TABLE t6 (c1 INT NOT NULL);
1792 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1793 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1794 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1795 INSERT INTO t4 (c1) VALUES(10);
1796 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1797 --sorted_result
1798 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1799 --sorted_result
1800 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1801 --sorted_result
1802 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1803 DROP TABLE t1,t2,t3,t4,t5,t6;
1804 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1805 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1806 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1807 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1808 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1809 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1810 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1811 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1812 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1813 INSERT INTO t4 (c1) VALUES(10);
1814 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1815 --sorted_result
1816 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1817 --sorted_result
1818 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1819 --sorted_result
1820 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1821 DROP TABLE t1,t2,t3,t4,t5,t6;
1822 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1823 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1824 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1825 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1826 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1827 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1828 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1829 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1830 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1831 INSERT INTO t4 (c1) VALUES(10);
1832 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1833 --sorted_result
1834 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1835 --sorted_result
1836 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1837 --sorted_result
1838 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1839 DROP TABLE t1,t2,t3,t4,t5,t6;
1840 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1841 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1842 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1843 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1844 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1845 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1846 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1847 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1848 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1849 INSERT INTO t4 (c1) VALUES(10);
1850 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1851 --sorted_result
1852 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1853 --sorted_result
1854 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1855 --sorted_result
1856 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1857 DROP TABLE t1,t2,t3,t4,t5,t6;
1858 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1859 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1860 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1861 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1862 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1863 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1864 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1865 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1866 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1867 INSERT INTO t4 (c1) VALUES(10);
1868 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1869 --sorted_result
1870 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1871 --sorted_result
1872 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1873 --sorted_result
1874 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1875 DROP TABLE t1,t2,t3,t4,t5,t6;
1876 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1877 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1878 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1879 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1880 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1881 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1882 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1883 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1884 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1885 INSERT INTO t4 (c1) VALUES(10);
1886 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1887 --sorted_result
1888 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1889 --sorted_result
1890 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1891 --sorted_result
1892 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1893 DROP TABLE t1,t2,t3,t4,t5,t6;
1894 CREATE TABLE t1 (c1 INT NOT NULL);
1895 CREATE TABLE t2 (c1 INT NOT NULL);
1896 CREATE TABLE t3 (c1 INT NOT NULL);
1897 CREATE TABLE t4 (c1 INT NOT NULL);
1898 CREATE TABLE t5 (c1 INT NOT NULL);
1899 CREATE TABLE t6 (c1 INT NOT NULL);
1900 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1901 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1902 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1903 INSERT INTO t4 (c1) VALUES(10);
1904 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1905 --sorted_result
1906 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1907 --sorted_result
1908 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1909 --sorted_result
1910 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1911 DROP TABLE t1,t2,t3,t4,t5,t6;
1912 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1913 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1914 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1915 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1916 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1917 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1918 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1919 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1920 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1921 INSERT INTO t4 (c1) VALUES(10);
1922 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1923 --sorted_result
1924 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1925 --sorted_result
1926 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1927 --sorted_result
1928 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1929 DROP TABLE t1,t2,t3,t4,t5,t6;
1930 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1931 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1932 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1933 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1934 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1935 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1936 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1937 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1938 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1939 INSERT INTO t4 (c1) VALUES(10);
1940 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1941 --sorted_result
1942 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1943 --sorted_result
1944 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1945 --sorted_result
1946 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1947 DROP TABLE t1,t2,t3,t4,t5,t6;
1948 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1949 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1950 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1951 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1952 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1953 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1954 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1955 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1956 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1957 INSERT INTO t4 (c1) VALUES(10);
1958 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1959 --sorted_result
1960 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1961 --sorted_result
1962 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1963 --sorted_result
1964 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1965 DROP TABLE t1,t2,t3,t4,t5,t6;
1966 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1967 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1968 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1969 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1970 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1971 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1972 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1973 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1974 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1975 INSERT INTO t4 (c1) VALUES(10);
1976 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1977 --sorted_result
1978 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1979 --sorted_result
1980 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1981 --sorted_result
1982 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1983 DROP TABLE t1,t2,t3,t4,t5,t6;
1984 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1985 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1986 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1987 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1988 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1989 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1990 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1991 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1992 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1993 INSERT INTO t4 (c1) VALUES(10);
1994 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1995 --sorted_result
1996 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1997 --sorted_result
1998 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1999 --sorted_result
2000 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2001 DROP TABLE t1,t2,t3,t4,t5,t6;
2002 CREATE TABLE t1 (c1 INT NOT NULL);
2003 CREATE TABLE t2 (c1 INT NOT NULL);
2004 CREATE TABLE t3 (c1 INT NOT NULL);
2005 CREATE TABLE t4 (c1 INT NOT NULL);
2006 CREATE TABLE t5 (c1 INT NOT NULL);
2007 CREATE TABLE t6 (c1 INT NOT NULL);
2008 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2009 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2010 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2011 INSERT INTO t4 (c1) VALUES(10);
2012 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2013 --sorted_result
2014 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2015 --sorted_result
2016 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2017 --sorted_result
2018 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2019 DROP TABLE t1,t2,t3,t4,t5,t6;
2020 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2021 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2022 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2023 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2024 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2025 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2026 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2027 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2028 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2029 INSERT INTO t4 (c1) VALUES(10);
2030 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2031 --sorted_result
2032 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2033 --sorted_result
2034 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2035 --sorted_result
2036 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2037 DROP TABLE t1,t2,t3,t4,t5,t6;
2038 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2039 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2040 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2041 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2042 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2043 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2044 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2045 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2046 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2047 INSERT INTO t4 (c1) VALUES(10);
2048 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2049 --sorted_result
2050 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2051 --sorted_result
2052 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2053 --sorted_result
2054 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2055 DROP TABLE t1,t2,t3,t4,t5,t6;
2056 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2057 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2058 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2059 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2060 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2061 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2062 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2063 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2064 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2065 INSERT INTO t4 (c1) VALUES(10);
2066 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2067 --sorted_result
2068 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2069 --sorted_result
2070 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2071 --sorted_result
2072 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2073 DROP TABLE t1,t2,t3,t4,t5,t6;
2074 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2075 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2076 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2077 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2078 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2079 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2080 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2081 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2082 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2083 INSERT INTO t4 (c1) VALUES(10);
2084 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2085 --sorted_result
2086 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2087 --sorted_result
2088 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2089 --sorted_result
2090 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2091 DROP TABLE t1,t2,t3,t4,t5,t6;
2092 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2093 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2094 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2095 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2096 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2097 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2098 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2099 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2100 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2101 INSERT INTO t4 (c1) VALUES(10);
2102 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2103 --sorted_result
2104 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2105 --sorted_result
2106 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2107 --sorted_result
2108 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2109 DROP TABLE t1,t2,t3,t4,t5,t6;
2110 CREATE TABLE t1 (c1 INT NOT NULL);
2111 CREATE TABLE t2 (c1 INT NOT NULL);
2112 CREATE TABLE t3 (c1 INT NOT NULL);
2113 CREATE TABLE t4 (c1 INT NOT NULL);
2114 CREATE TABLE t5 (c1 INT NOT NULL);
2115 CREATE TABLE t6 (c1 INT NOT NULL);
2116 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2117 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2118 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2119 INSERT INTO t4 (c1) VALUES(10);
2120 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2121 --sorted_result
2122 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2123 --sorted_result
2124 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2125 --sorted_result
2126 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2127 DROP TABLE t1,t2,t3,t4,t5,t6;
2128 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2129 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2130 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2131 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2132 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2133 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2134 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2135 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2136 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2137 INSERT INTO t4 (c1) VALUES(10);
2138 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2139 --sorted_result
2140 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2141 --sorted_result
2142 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2143 --sorted_result
2144 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2145 DROP TABLE t1,t2,t3,t4,t5,t6;
2146 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2147 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2148 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2149 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2150 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2151 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2152 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2153 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2154 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2155 INSERT INTO t4 (c1) VALUES(10);
2156 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2157 --sorted_result
2158 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2159 --sorted_result
2160 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2161 --sorted_result
2162 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2163 DROP TABLE t1,t2,t3,t4,t5,t6;
2164 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2165 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2166 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2167 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2168 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2169 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2170 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2171 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2172 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2173 INSERT INTO t4 (c1) VALUES(10);
2174 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2175 --sorted_result
2176 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2177 --sorted_result
2178 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2179 --sorted_result
2180 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
2181 DROP TABLE t1,t2,t3,t4,t5,t6;
2182 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2183 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2184 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2185 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2186 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2187 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2188 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2189 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2190 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2191 INSERT INTO t4 (c1) VALUES(10);
2192 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2193 --sorted_result
2194 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2195 --sorted_result
2196 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2197 --sorted_result
2198 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
2199 DROP TABLE t1,t2,t3,t4,t5,t6;
2200 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2201 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2202 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2203 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2204 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2205 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2206 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2207 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2208 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2209 INSERT INTO t4 (c1) VALUES(10);
2210 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2211 --sorted_result
2212 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2213 --sorted_result
2214 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2215 --sorted_result
2216 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
2217 DROP TABLE t1,t2,t3,t4,t5,t6;
2218 CREATE TABLE t1 (c1 INT NOT NULL);
2219 CREATE TABLE t2 (c1 INT NOT NULL);
2220 CREATE TABLE t3 (c1 INT NOT NULL);
2221 CREATE TABLE t4 (c1 INT NOT NULL);
2222 CREATE TABLE t5 (c1 INT NOT NULL);
2223 CREATE TABLE t6 (c1 INT NOT NULL);
2224 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2225 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2226 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2227 INSERT INTO t4 (c1) VALUES(10);
2228 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2229 --sorted_result
2230 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2231 --sorted_result
2232 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2233 --sorted_result
2234 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
2235 DROP TABLE t1,t2,t3,t4,t5,t6;
2236 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2237 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2238 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2239 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2240 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2241 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2242 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2243 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2244 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2245 INSERT INTO t4 (c1) VALUES(10);
2246 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2247 --sorted_result
2248 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2249 --sorted_result
2250 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2251 --sorted_result
2252 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
2253 DROP TABLE t1,t2,t3,t4,t5,t6;
2254 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2255 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2256 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2257 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2258 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2259 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2260 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2261 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2262 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2263 INSERT INTO t4 (c1) VALUES(10);
2264 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2265 --sorted_result
2266 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2267 --sorted_result
2268 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2269 --sorted_result
2270 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
2271 DROP TABLE t1,t2,t3,t4,t5,t6;
2272 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2273 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2274 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2275 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2276 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2277 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2278 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2279 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2280 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2281 INSERT INTO t4 (c1) VALUES(10);
2282 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2283 --sorted_result
2284 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2285 --sorted_result
2286 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2287 --sorted_result
2288 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
2289 DROP TABLE t1,t2,t3,t4,t5,t6;
2290 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2291 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2292 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2293 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2294 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2295 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2296 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2297 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2298 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2299 INSERT INTO t4 (c1) VALUES(10);
2300 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2301 --sorted_result
2302 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2303 --sorted_result
2304 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2305 --sorted_result
2306 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
2307 DROP TABLE t1,t2,t3,t4,t5,t6;
2308 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2309 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2310 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2311 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2312 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2313 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2314 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2315 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2316 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2317 INSERT INTO t4 (c1) VALUES(10);
2318 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2319 --sorted_result
2320 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2321 --sorted_result
2322 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2323 --sorted_result
2324 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
2325 DROP TABLE t1,t2,t3,t4,t5,t6;
2326 CREATE TABLE t1 (c1 INT NOT NULL);
2327 CREATE TABLE t2 (c1 INT NOT NULL);
2328 CREATE TABLE t3 (c1 INT NOT NULL);
2329 CREATE TABLE t4 (c1 INT NOT NULL);
2330 CREATE TABLE t5 (c1 INT NOT NULL);
2331 CREATE TABLE t6 (c1 INT NOT NULL);
2332 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2333 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2334 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2335 INSERT INTO t4 (c1) VALUES(10);
2336 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2337 --sorted_result
2338 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2339 --sorted_result
2340 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2341 --sorted_result
2342 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
2343 DROP TABLE t1,t2,t3,t4,t5,t6;
2344 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2345 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2346 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2347 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2348 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2349 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2350 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2351 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2352 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2353 INSERT INTO t4 (c1) VALUES(10);
2354 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2355 --sorted_result
2356 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2357 --sorted_result
2358 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2359 --sorted_result
2360 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
2361 DROP TABLE t1,t2,t3,t4,t5,t6;
2362 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2363 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2364 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2365 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2366 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2367 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2368 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2369 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2370 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2371 INSERT INTO t4 (c1) VALUES(10);
2372 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2373 --sorted_result
2374 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2375 --sorted_result
2376 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2377 --sorted_result
2378 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
2379 DROP TABLE t1,t2,t3,t4,t5,t6;
2380 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2381 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2382 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2383 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2384 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2385 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2386 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2387 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2388 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2389 INSERT INTO t4 (c1) VALUES(10);
2390 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2391 --sorted_result
2392 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2393 --sorted_result
2394 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2395 --sorted_result
2396 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2397 DROP TABLE t1,t2,t3,t4,t5,t6;
2398 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2399 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2400 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2401 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2402 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2403 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2404 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2405 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2406 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2407 INSERT INTO t4 (c1) VALUES(10);
2408 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2409 --sorted_result
2410 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2411 --sorted_result
2412 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2413 --sorted_result
2414 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2415 DROP TABLE t1,t2,t3,t4,t5,t6;
2416 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2417 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2418 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2419 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2420 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2421 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2422 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2423 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2424 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2425 INSERT INTO t4 (c1) VALUES(10);
2426 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2427 --sorted_result
2428 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2429 --sorted_result
2430 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2431 --sorted_result
2432 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2433 DROP TABLE t1,t2,t3,t4,t5,t6;
2434 CREATE TABLE t1 (c1 INT NOT NULL);
2435 CREATE TABLE t2 (c1 INT NOT NULL);
2436 CREATE TABLE t3 (c1 INT NOT NULL);
2437 CREATE TABLE t4 (c1 INT NOT NULL);
2438 CREATE TABLE t5 (c1 INT NOT NULL);
2439 CREATE TABLE t6 (c1 INT NOT NULL);
2440 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2441 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2442 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2443 INSERT INTO t4 (c1) VALUES(10);
2444 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2445 --sorted_result
2446 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2447 --sorted_result
2448 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2449 --sorted_result
2450 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2451 DROP TABLE t1,t2,t3,t4,t5,t6;
2452 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2453 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2454 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2455 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2456 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2457 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2458 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2459 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2460 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2461 INSERT INTO t4 (c1) VALUES(10);
2462 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2463 --sorted_result
2464 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2465 --sorted_result
2466 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2467 --sorted_result
2468 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2469 DROP TABLE t1,t2,t3,t4,t5,t6;
2470 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2471 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2472 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2473 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2474 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2475 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2476 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2477 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2478 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2479 INSERT INTO t4 (c1) VALUES(10);
2480 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2481 --sorted_result
2482 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2483 --sorted_result
2484 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2485 --sorted_result
2486 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2487 DROP TABLE t1,t2,t3,t4,t5,t6;
2488 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2489 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2490 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2491 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2492 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2493 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2494 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2495 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2496 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2497 INSERT INTO t4 (c1) VALUES(10);
2498 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2499 --sorted_result
2500 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2501 --sorted_result
2502 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2503 --sorted_result
2504 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2505 DROP TABLE t1,t2,t3,t4,t5,t6;
2506 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2507 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2508 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2509 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2510 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2511 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2512 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2513 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2514 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2515 INSERT INTO t4 (c1) VALUES(10);
2516 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2517 --sorted_result
2518 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2519 --sorted_result
2520 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2521 --sorted_result
2522 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2523 DROP TABLE t1,t2,t3,t4,t5,t6;
2524 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2525 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2526 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2527 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2528 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2529 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2530 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2531 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2532 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2533 INSERT INTO t4 (c1) VALUES(10);
2534 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2535 --sorted_result
2536 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2537 --sorted_result
2538 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2539 --sorted_result
2540 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2541 DROP TABLE t1,t2,t3,t4,t5,t6;
2542 CREATE TABLE t1 (c1 INT NOT NULL);
2543 CREATE TABLE t2 (c1 INT NOT NULL);
2544 CREATE TABLE t3 (c1 INT NOT NULL);
2545 CREATE TABLE t4 (c1 INT NOT NULL);
2546 CREATE TABLE t5 (c1 INT NOT NULL);
2547 CREATE TABLE t6 (c1 INT NOT NULL);
2548 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2549 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2550 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2551 INSERT INTO t4 (c1) VALUES(10);
2552 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2553 --sorted_result
2554 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2555 --sorted_result
2556 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2557 --sorted_result
2558 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2559 DROP TABLE t1,t2,t3,t4,t5,t6;
2560 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2561 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2562 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2563 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2564 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2565 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2566 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2567 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2568 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2569 INSERT INTO t4 (c1) VALUES(10);
2570 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2571 --sorted_result
2572 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2573 --sorted_result
2574 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2575 --sorted_result
2576 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2577 DROP TABLE t1,t2,t3,t4,t5,t6;
2578 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2579 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2580 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2581 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2582 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2583 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2584 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2585 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2586 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2587 INSERT INTO t4 (c1) VALUES(10);
2588 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2589 --sorted_result
2590 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2591 --sorted_result
2592 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2593 --sorted_result
2594 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2595 DROP TABLE t1,t2,t3,t4,t5,t6;
2596 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2597 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2598 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2599 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2600 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2601 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2602 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2603 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2604 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2605 INSERT INTO t4 (c1) VALUES(10);
2606 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2607 --sorted_result
2608 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2609 --sorted_result
2610 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2611 --sorted_result
2612 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2613 DROP TABLE t1,t2,t3,t4,t5,t6;
2614 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2615 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2616 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2617 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2618 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2619 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2620 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2621 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2622 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2623 INSERT INTO t4 (c1) VALUES(10);
2624 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2625 --sorted_result
2626 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2627 --sorted_result
2628 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2629 --sorted_result
2630 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2631 DROP TABLE t1,t2,t3,t4,t5,t6;
2632 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2633 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2634 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2635 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2636 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2637 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2638 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2639 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2640 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2641 INSERT INTO t4 (c1) VALUES(10);
2642 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2643 --sorted_result
2644 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2645 --sorted_result
2646 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2647 --sorted_result
2648 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2649 DROP TABLE t1,t2,t3,t4,t5,t6;
2650 CREATE TABLE t1 (c1 INT NOT NULL);
2651 CREATE TABLE t2 (c1 INT NOT NULL);
2652 CREATE TABLE t3 (c1 INT NOT NULL);
2653 CREATE TABLE t4 (c1 INT NOT NULL);
2654 CREATE TABLE t5 (c1 INT NOT NULL);
2655 CREATE TABLE t6 (c1 INT NOT NULL);
2656 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2657 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2658 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2659 INSERT INTO t4 (c1) VALUES(10);
2660 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2661 --sorted_result
2662 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2663 --sorted_result
2664 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2665 --sorted_result
2666 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2667 DROP TABLE t1,t2,t3,t4,t5,t6;
2668 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2669 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2670 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2671 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2672 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2673 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2674 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2675 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2676 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2677 INSERT INTO t4 (c1) VALUES(10);
2678 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2679 --sorted_result
2680 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2681 --sorted_result
2682 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2683 --sorted_result
2684 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2685 DROP TABLE t1,t2,t3,t4,t5,t6;
2686 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2687 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2688 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2689 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2690 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2691 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2692 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2693 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2694 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2695 INSERT INTO t4 (c1) VALUES(10);
2696 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2697 --sorted_result
2698 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2699 --sorted_result
2700 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2701 --sorted_result
2702 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2703 DROP TABLE t1,t2,t3,t4,t5,t6;
2704 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2705 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2706 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2707 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2708 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2709 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2710 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2711 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2712 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2713 INSERT INTO t4 (c1) VALUES(10);
2714 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2715 --sorted_result
2716 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2717 --sorted_result
2718 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2719 --sorted_result
2720 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2721 DROP TABLE t1,t2,t3,t4,t5,t6;
2722 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2723 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2724 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2725 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2726 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2727 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2728 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2729 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2730 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2731 INSERT INTO t4 (c1) VALUES(10);
2732 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2733 --sorted_result
2734 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2735 --sorted_result
2736 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2737 --sorted_result
2738 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2739 DROP TABLE t1,t2,t3,t4,t5,t6;
2740 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2741 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2742 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2743 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2744 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2745 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2746 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2747 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2748 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2749 INSERT INTO t4 (c1) VALUES(10);
2750 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2751 --sorted_result
2752 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2753 --sorted_result
2754 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2755 --sorted_result
2756 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2757 DROP TABLE t1,t2,t3,t4,t5,t6;
2758 CREATE TABLE t1 (c1 INT NOT NULL);
2759 CREATE TABLE t2 (c1 INT NOT NULL);
2760 CREATE TABLE t3 (c1 INT NOT NULL);
2761 CREATE TABLE t4 (c1 INT NOT NULL);
2762 CREATE TABLE t5 (c1 INT NOT NULL);
2763 CREATE TABLE t6 (c1 INT NOT NULL);
2764 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2765 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2766 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2767 INSERT INTO t4 (c1) VALUES(10);
2768 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2769 --sorted_result
2770 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2771 --sorted_result
2772 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2773 --sorted_result
2774 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2775 DROP TABLE t1,t2,t3,t4,t5,t6;
2776 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2777 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2778 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2779 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2780 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2781 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2782 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2784 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2785 INSERT INTO t4 (c1) VALUES(10);
2786 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2787 --sorted_result
2788 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2789 --sorted_result
2790 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2791 --sorted_result
2792 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2793 DROP TABLE t1,t2,t3,t4,t5,t6;
2794 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2795 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2796 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2797 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2798 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2799 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2800 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2801 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2802 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2803 INSERT INTO t4 (c1) VALUES(10);
2804 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2805 --sorted_result
2806 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2807 --sorted_result
2808 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2809 --sorted_result
2810 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2811 DROP TABLE t1,t2,t3,t4,t5,t6;
2812 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2813 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2814 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2815 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2816 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2817 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2818 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2819 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2820 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2821 INSERT INTO t4 (c1) VALUES(10);
2822 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2823 --sorted_result
2824 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2825 --sorted_result
2826 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2827 --sorted_result
2828 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2829 DROP TABLE t1,t2,t3,t4,t5,t6;
2830 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2831 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2832 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2833 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2834 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2835 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2836 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2837 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2838 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2839 INSERT INTO t4 (c1) VALUES(10);
2840 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2841 --sorted_result
2842 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2843 --sorted_result
2844 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2845 --sorted_result
2846 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2847 DROP TABLE t1,t2,t3,t4,t5,t6;
2848 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2849 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2850 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2851 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2852 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2853 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2854 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2855 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2856 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2857 INSERT INTO t4 (c1) VALUES(10);
2858 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2859 --sorted_result
2860 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2861 --sorted_result
2862 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2863 --sorted_result
2864 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2865 DROP TABLE t1,t2,t3,t4,t5,t6;
2866 CREATE TABLE t1 (c1 INT NOT NULL);
2867 CREATE TABLE t2 (c1 INT NOT NULL);
2868 CREATE TABLE t3 (c1 INT NOT NULL);
2869 CREATE TABLE t4 (c1 INT NOT NULL);
2870 CREATE TABLE t5 (c1 INT NOT NULL);
2871 CREATE TABLE t6 (c1 INT NOT NULL);
2872 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2873 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2874 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2875 INSERT INTO t4 (c1) VALUES(10);
2876 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2877 --sorted_result
2878 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2879 --sorted_result
2880 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2881 --sorted_result
2882 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2883 DROP TABLE t1,t2,t3,t4,t5,t6;
2884 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2885 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2886 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2887 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2888 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2889 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2890 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2891 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2892 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2893 INSERT INTO t4 (c1) VALUES(10);
2894 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2895 --sorted_result
2896 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2897 --sorted_result
2898 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2899 --sorted_result
2900 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2901 DROP TABLE t1,t2,t3,t4,t5,t6;
2902 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2903 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2904 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2905 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2906 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2907 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2908 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2909 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2910 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2911 INSERT INTO t4 (c1) VALUES(10);
2912 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2913 --sorted_result
2914 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2915 --sorted_result
2916 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2917 --sorted_result
2918 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2919 DROP TABLE t1,t2,t3,t4,t5,t6;
2920 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2921 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2922 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2923 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2924 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2925 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2926 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2927 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2928 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2929 INSERT INTO t4 (c1) VALUES(10);
2930 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2931 --sorted_result
2932 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2933 --sorted_result
2934 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2935 --sorted_result
2936 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2937 DROP TABLE t1,t2,t3,t4,t5,t6;
2938 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2939 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2940 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2941 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2942 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2943 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2944 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2945 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2946 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2947 INSERT INTO t4 (c1) VALUES(10);
2948 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2949 --sorted_result
2950 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2951 --sorted_result
2952 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2953 --sorted_result
2954 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2955 DROP TABLE t1,t2,t3,t4,t5,t6;
2956 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2957 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2958 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2959 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2960 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2961 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2962 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2963 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2964 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2965 INSERT INTO t4 (c1) VALUES(10);
2966 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2967 --sorted_result
2968 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2969 --sorted_result
2970 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2971 --sorted_result
2972 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2973 DROP TABLE t1,t2,t3,t4,t5,t6;
2974 CREATE TABLE t1 (c1 INT NOT NULL);
2975 CREATE TABLE t2 (c1 INT NOT NULL);
2976 CREATE TABLE t3 (c1 INT NOT NULL);
2977 CREATE TABLE t4 (c1 INT NOT NULL);
2978 CREATE TABLE t5 (c1 INT NOT NULL);
2979 CREATE TABLE t6 (c1 INT NOT NULL);
2980 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2981 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2982 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2983 INSERT INTO t4 (c1) VALUES(10);
2984 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2985 --sorted_result
2986 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2987 --sorted_result
2988 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2989 --sorted_result
2990 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2991 DROP TABLE t1,t2,t3,t4,t5,t6;
2992 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2993 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2994 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2995 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2996 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2997 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2998 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2999 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3000 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3001 INSERT INTO t4 (c1) VALUES(10);
3002 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3003 --sorted_result
3004 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3005 --sorted_result
3006 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3007 --sorted_result
3008 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
3009 DROP TABLE t1,t2,t3,t4,t5,t6;
3010 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3011 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3012 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3013 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3014 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3015 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3016 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3017 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3018 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3019 INSERT INTO t4 (c1) VALUES(10);
3020 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3021 --sorted_result
3022 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3023 --sorted_result
3024 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3025 --sorted_result
3026 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
3027 DROP TABLE t1,t2,t3,t4,t5,t6;
3028 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3029 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3030 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3031 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3032 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3033 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3034 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3035 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3036 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3037 INSERT INTO t4 (c1) VALUES(10);
3038 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3039 --sorted_result
3040 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3041 --sorted_result
3042 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3043 --sorted_result
3044 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
3045 DROP TABLE t1,t2,t3,t4,t5,t6;
3046 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3047 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3048 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3049 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3050 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3051 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3052 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3053 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3054 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3055 INSERT INTO t4 (c1) VALUES(10);
3056 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3057 --sorted_result
3058 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3059 --sorted_result
3060 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3061 --sorted_result
3062 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
3063 DROP TABLE t1,t2,t3,t4,t5,t6;
3064 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3065 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3066 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3067 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3068 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3069 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3070 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3071 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3072 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3073 INSERT INTO t4 (c1) VALUES(10);
3074 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3075 --sorted_result
3076 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3077 --sorted_result
3078 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3079 --sorted_result
3080 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
3081 DROP TABLE t1,t2,t3,t4,t5,t6;
3082 CREATE TABLE t1 (c1 INT NOT NULL);
3083 CREATE TABLE t2 (c1 INT NOT NULL);
3084 CREATE TABLE t3 (c1 INT NOT NULL);
3085 CREATE TABLE t4 (c1 INT NOT NULL);
3086 CREATE TABLE t5 (c1 INT NOT NULL);
3087 CREATE TABLE t6 (c1 INT NOT NULL);
3088 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3089 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3090 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3091 INSERT INTO t4 (c1) VALUES(10);
3092 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3093 --sorted_result
3094 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3095 --sorted_result
3096 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3097 --sorted_result
3098 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
3099 DROP TABLE t1,t2,t3,t4,t5,t6;
3100 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3101 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3102 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3103 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3104 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3105 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3106 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3107 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3108 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3109 INSERT INTO t4 (c1) VALUES(10);
3110 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3111 --sorted_result
3112 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3113 --sorted_result
3114 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3115 --sorted_result
3116 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
3117 DROP TABLE t1,t2,t3,t4,t5,t6;
3118 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3119 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3120 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3121 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3122 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3123 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3124 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3125 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3126 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3127 INSERT INTO t4 (c1) VALUES(10);
3128 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3129 --sorted_result
3130 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3131 --sorted_result
3132 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3133 --sorted_result
3134 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
3135 DROP TABLE t1,t2,t3,t4,t5,t6;
3136 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3137 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3138 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3139 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3140 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3141 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3142 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3143 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3144 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3145 INSERT INTO t4 (c1) VALUES(10);
3146 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3147 --sorted_result
3148 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3149 --sorted_result
3150 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3151 --sorted_result
3152 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
3153 DROP TABLE t1,t2,t3,t4,t5,t6;
3154 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3155 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3156 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3157 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3158 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3159 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3160 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3161 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3162 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3163 INSERT INTO t4 (c1) VALUES(10);
3164 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3165 --sorted_result
3166 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3167 --sorted_result
3168 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3169 --sorted_result
3170 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
3171 DROP TABLE t1,t2,t3,t4,t5,t6;
3172 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3173 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3174 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3175 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3176 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3177 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3178 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3179 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3180 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3181 INSERT INTO t4 (c1) VALUES(10);
3182 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3183 --sorted_result
3184 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3185 --sorted_result
3186 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3187 --sorted_result
3188 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
3189 DROP TABLE t1,t2,t3,t4,t5,t6;
3190 CREATE TABLE t1 (c1 INT NOT NULL);
3191 CREATE TABLE t2 (c1 INT NOT NULL);
3192 CREATE TABLE t3 (c1 INT NOT NULL);
3193 CREATE TABLE t4 (c1 INT NOT NULL);
3194 CREATE TABLE t5 (c1 INT NOT NULL);
3195 CREATE TABLE t6 (c1 INT NOT NULL);
3196 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3197 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3198 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3199 INSERT INTO t4 (c1) VALUES(10);
3200 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3201 --sorted_result
3202 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3203 --sorted_result
3204 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3205 --sorted_result
3206 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
3207 DROP TABLE t1,t2,t3,t4,t5,t6;
3208 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3209 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3210 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3211 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3212 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3213 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3214 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3215 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3216 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3217 INSERT INTO t4 (c1) VALUES(10);
3218 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3219 --sorted_result
3220 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3221 --sorted_result
3222 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3223 --sorted_result
3224 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
3225 DROP TABLE t1,t2,t3,t4,t5,t6;
3226 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3227 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3228 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3229 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3230 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3231 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3232 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3233 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3234 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3235 INSERT INTO t4 (c1) VALUES(10);
3236 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3237 --sorted_result
3238 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3239 --sorted_result
3240 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3241 --sorted_result
3242 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
3243 DROP TABLE t1,t2,t3,t4,t5,t6;
3244 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3245 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3246 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3247 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3248 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3249 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3250 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3251 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3252 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3253 INSERT INTO t4 (c1) VALUES(10);
3254 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3255 --sorted_result
3256 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3257 --sorted_result
3258 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3259 --sorted_result
3260 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
3261 DROP TABLE t1,t2,t3,t4,t5,t6;
3262 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3263 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3264 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3265 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3266 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3267 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3268 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3269 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3270 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3271 INSERT INTO t4 (c1) VALUES(10);
3272 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3273 --sorted_result
3274 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3275 --sorted_result
3276 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3277 --sorted_result
3278 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
3279 DROP TABLE t1,t2,t3,t4,t5,t6;
3280 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3281 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3282 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3283 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3284 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3285 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3286 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3287 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3288 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3289 INSERT INTO t4 (c1) VALUES(10);
3290 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3291 --sorted_result
3292 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3293 --sorted_result
3294 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3295 --sorted_result
3296 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
3297 DROP TABLE t1,t2,t3,t4,t5,t6;
3298 CREATE TABLE t1 (c1 INT NOT NULL);
3299 CREATE TABLE t2 (c1 INT NOT NULL);
3300 CREATE TABLE t3 (c1 INT NOT NULL);
3301 CREATE TABLE t4 (c1 INT NOT NULL);
3302 CREATE TABLE t5 (c1 INT NOT NULL);
3303 CREATE TABLE t6 (c1 INT NOT NULL);
3304 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3305 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3306 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3307 INSERT INTO t4 (c1) VALUES(10);
3308 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3309 --sorted_result
3310 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3311 --sorted_result
3312 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3313 --sorted_result
3314 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
3315 DROP TABLE t1,t2,t3,t4,t5,t6;
3316 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3317 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3318 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3319 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3320 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3321 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3322 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3323 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3324 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3325 INSERT INTO t4 (c1) VALUES(10);
3326 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3327 --sorted_result
3328 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3329 --sorted_result
3330 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3331 --sorted_result
3332 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
3333 DROP TABLE t1,t2,t3,t4,t5,t6;
3334 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3335 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3336 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3337 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3338 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3339 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3340 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3341 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3342 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3343 INSERT INTO t4 (c1) VALUES(10);
3344 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3345 --sorted_result
3346 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
3347 --sorted_result
3348 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
3349 --sorted_result
3350 SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
3351 DROP TABLE t1,t2,t3,t4,t5,t6;
3352 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3353 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3354 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3355 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3356 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3357 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3358 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3359 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3360 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3361 INSERT INTO t4 (c1) VALUES(10);
3362 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3363 --sorted_result
3364 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3365 --sorted_result
3366 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3367 --sorted_result
3368 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
3369 DROP TABLE t1,t2,t3,t4,t5,t6;
3370 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3371 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3372 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3373 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3374 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3375 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3376 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3377 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3378 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3379 INSERT INTO t4 (c1) VALUES(10);
3380 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3381 --sorted_result
3382 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3383 --sorted_result
3384 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3385 --sorted_result
3386 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
3387 DROP TABLE t1,t2,t3,t4,t5,t6;
3388 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3389 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3390 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3391 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3392 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3393 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3394 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3395 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3396 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3397 INSERT INTO t4 (c1) VALUES(10);
3398 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3399 --sorted_result
3400 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3401 --sorted_result
3402 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3403 --sorted_result
3404 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
3405 DROP TABLE t1,t2,t3,t4,t5,t6;
3406 CREATE TABLE t1 (c1 INT NOT NULL);
3407 CREATE TABLE t2 (c1 INT NOT NULL);
3408 CREATE TABLE t3 (c1 INT NOT NULL);
3409 CREATE TABLE t4 (c1 INT NOT NULL);
3410 CREATE TABLE t5 (c1 INT NOT NULL);
3411 CREATE TABLE t6 (c1 INT NOT NULL);
3412 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3413 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3414 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3415 INSERT INTO t4 (c1) VALUES(10);
3416 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3417 --sorted_result
3418 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3419 --sorted_result
3420 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3421 --sorted_result
3422 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
3423 DROP TABLE t1,t2,t3,t4,t5,t6;
3424 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3425 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3426 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3427 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3428 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3429 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3430 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3431 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3432 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3433 INSERT INTO t4 (c1) VALUES(10);
3434 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3435 --sorted_result
3436 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3437 --sorted_result
3438 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3439 --sorted_result
3440 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
3441 DROP TABLE t1,t2,t3,t4,t5,t6;
3442 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3443 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3444 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3445 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3446 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3447 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3448 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3449 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3450 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3451 INSERT INTO t4 (c1) VALUES(10);
3452 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3453 --sorted_result
3454 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
3455 --sorted_result
3456 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
3457 --sorted_result
3458 SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
3459 DROP TABLE t1,t2,t3,t4,t5,t6;
3460 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3461 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3462 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3463 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3464 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3465 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3466 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3467 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3468 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3469 INSERT INTO t4 (c1) VALUES(10);
3470 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3471 --sorted_result
3472 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3473 --sorted_result
3474 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3475 --sorted_result
3476 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
3477 DROP TABLE t1,t2,t3,t4,t5,t6;
3478 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3479 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3480 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3481 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3482 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3483 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3484 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3485 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3486 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3487 INSERT INTO t4 (c1) VALUES(10);
3488 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3489 --sorted_result
3490 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3491 --sorted_result
3492 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3493 --sorted_result
3494 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
3495 DROP TABLE t1,t2,t3,t4,t5,t6;
3496 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3497 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3498 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3499 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3500 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3501 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3502 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3503 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3504 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3505 INSERT INTO t4 (c1) VALUES(10);
3506 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3507 --sorted_result
3508 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3509 --sorted_result
3510 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3511 --sorted_result
3512 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
3513 DROP TABLE t1,t2,t3,t4,t5,t6;
3514 CREATE TABLE t1 (c1 INT NOT NULL);
3515 CREATE TABLE t2 (c1 INT NOT NULL);
3516 CREATE TABLE t3 (c1 INT NOT NULL);
3517 CREATE TABLE t4 (c1 INT NOT NULL);
3518 CREATE TABLE t5 (c1 INT NOT NULL);
3519 CREATE TABLE t6 (c1 INT NOT NULL);
3520 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3521 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3522 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3523 INSERT INTO t4 (c1) VALUES(10);
3524 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3525 --sorted_result
3526 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3527 --sorted_result
3528 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3529 --sorted_result
3530 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
3531 DROP TABLE t1,t2,t3,t4,t5,t6;
3532 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3533 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3534 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3535 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3536 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3537 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3538 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3539 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3540 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3541 INSERT INTO t4 (c1) VALUES(10);
3542 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3543 --sorted_result
3544 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3545 --sorted_result
3546 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3547 --sorted_result
3548 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
3549 DROP TABLE t1,t2,t3,t4,t5,t6;
3550 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3551 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3552 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3553 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3554 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3555 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3556 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3557 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3558 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3559 INSERT INTO t4 (c1) VALUES(10);
3560 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3561 --sorted_result
3562 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
3563 --sorted_result
3564 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
3565 --sorted_result
3566 SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
3567 DROP TABLE t1,t2,t3,t4,t5,t6;
3568 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3569 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3570 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3571 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3572 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3573 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3574 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3575 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3576 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3577 INSERT INTO t4 (c1) VALUES(10);
3578 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3579 --sorted_result
3580 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3581 --sorted_result
3582 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3583 --sorted_result
3584 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3585 DROP TABLE t1,t2,t3,t4,t5,t6;
3586 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3587 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3588 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3589 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3590 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3591 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3592 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3593 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3594 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3595 INSERT INTO t4 (c1) VALUES(10);
3596 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3597 --sorted_result
3598 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3599 --sorted_result
3600 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3601 --sorted_result
3602 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3603 DROP TABLE t1,t2,t3,t4,t5,t6;
3604 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3605 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3606 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3607 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3608 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3609 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3610 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3611 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3612 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3613 INSERT INTO t4 (c1) VALUES(10);
3614 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3615 --sorted_result
3616 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3617 --sorted_result
3618 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3619 --sorted_result
3620 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3621 DROP TABLE t1,t2,t3,t4,t5,t6;
3622 CREATE TABLE t1 (c1 INT NOT NULL);
3623 CREATE TABLE t2 (c1 INT NOT NULL);
3624 CREATE TABLE t3 (c1 INT NOT NULL);
3625 CREATE TABLE t4 (c1 INT NOT NULL);
3626 CREATE TABLE t5 (c1 INT NOT NULL);
3627 CREATE TABLE t6 (c1 INT NOT NULL);
3628 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3629 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3630 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3631 INSERT INTO t4 (c1) VALUES(10);
3632 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3633 --sorted_result
3634 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3635 --sorted_result
3636 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3637 --sorted_result
3638 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3639 DROP TABLE t1,t2,t3,t4,t5,t6;
3640 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3641 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3642 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3643 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3644 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3645 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3646 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3647 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3648 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3649 INSERT INTO t4 (c1) VALUES(10);
3650 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3651 --sorted_result
3652 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3653 --sorted_result
3654 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3655 --sorted_result
3656 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3657 DROP TABLE t1,t2,t3,t4,t5,t6;
3658 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3659 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3660 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3661 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3662 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3663 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3664 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3665 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3666 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3667 INSERT INTO t4 (c1) VALUES(10);
3668 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3669 --sorted_result
3670 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3671 --sorted_result
3672 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3673 --sorted_result
3674 SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3675 DROP TABLE t1,t2,t3,t4,t5,t6;
3676 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3677 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3678 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3679 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3680 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3681 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3682 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3683 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3684 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3685 INSERT INTO t4 (c1) VALUES(10);
3686 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3687 --sorted_result
3688 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3689 --sorted_result
3690 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3691 --sorted_result
3692 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3693 DROP TABLE t1,t2,t3,t4,t5,t6;
3694 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3695 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3696 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3697 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3698 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3699 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3700 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3701 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3702 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3703 INSERT INTO t4 (c1) VALUES(10);
3704 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3705 --sorted_result
3706 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3707 --sorted_result
3708 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3709 --sorted_result
3710 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3711 DROP TABLE t1,t2,t3,t4,t5,t6;
3712 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3713 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3714 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3715 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3716 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3717 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3718 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3719 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3720 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3721 INSERT INTO t4 (c1) VALUES(10);
3722 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3723 --sorted_result
3724 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3725 --sorted_result
3726 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3727 --sorted_result
3728 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3729 DROP TABLE t1,t2,t3,t4,t5,t6;
3730 CREATE TABLE t1 (c1 INT NOT NULL);
3731 CREATE TABLE t2 (c1 INT NOT NULL);
3732 CREATE TABLE t3 (c1 INT NOT NULL);
3733 CREATE TABLE t4 (c1 INT NOT NULL);
3734 CREATE TABLE t5 (c1 INT NOT NULL);
3735 CREATE TABLE t6 (c1 INT NOT NULL);
3736 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3737 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3738 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3739 INSERT INTO t4 (c1) VALUES(10);
3740 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3741 --sorted_result
3742 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3743 --sorted_result
3744 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3745 --sorted_result
3746 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3747 DROP TABLE t1,t2,t3,t4,t5,t6;
3748 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3749 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3750 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3751 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3752 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3753 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3754 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3755 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3756 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3757 INSERT INTO t4 (c1) VALUES(10);
3758 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3759 --sorted_result
3760 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3761 --sorted_result
3762 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3763 --sorted_result
3764 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3765 DROP TABLE t1,t2,t3,t4,t5,t6;
3766 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3767 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3768 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3769 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3770 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3771 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3772 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3773 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3774 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3775 INSERT INTO t4 (c1) VALUES(10);
3776 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3777 --sorted_result
3778 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3779 --sorted_result
3780 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3781 --sorted_result
3782 SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3783 DROP TABLE t1,t2,t3,t4,t5,t6;
3784