Debian Codegraph @

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

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