Debian Codegraph @

mysql-test/suite/engines/funcs/t/se_join_default.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,t2 WHERE t1.c1 < t2.c1;
19 DROP TABLE t1,t2,t3,t4,t5,t6;
20 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
21 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
22 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
23 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
24 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
25 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
26 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
27 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
28 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
29 INSERT INTO t4 (c1) VALUES(10);
30 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
31 -- sorted_result
32 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
33 DROP TABLE t1,t2,t3,t4,t5,t6;
34 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
35 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
36 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
37 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
38 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
39 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
40 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
41 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
42 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
43 INSERT INTO t4 (c1) VALUES(10);
44 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
45 -- sorted_result
46 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
47 DROP TABLE t1,t2,t3,t4,t5,t6;
48 CREATE TABLE t1 (c1 INT NOT NULL);
49 CREATE TABLE t2 (c1 INT NOT NULL);
50 CREATE TABLE t3 (c1 INT NOT NULL);
51 CREATE TABLE t4 (c1 INT NOT NULL);
52 CREATE TABLE t5 (c1 INT NOT NULL);
53 CREATE TABLE t6 (c1 INT NOT NULL);
54 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
55 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
56 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
57 INSERT INTO t4 (c1) VALUES(10);
58 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
59 -- sorted_result
60 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
61 DROP TABLE t1,t2,t3,t4,t5,t6;
62 CREATE TABLE t1 (c1 INTEGER NOT NULL);
63 CREATE TABLE t2 (c1 INTEGER NOT NULL);
64 CREATE TABLE t3 (c1 INTEGER NOT NULL);
65 CREATE TABLE t4 (c1 INTEGER NOT NULL);
66 CREATE TABLE t5 (c1 INTEGER NOT NULL);
67 CREATE TABLE t6 (c1 INTEGER NOT NULL);
68 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
69 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
70 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
71 INSERT INTO t4 (c1) VALUES(10);
72 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
73 -- sorted_result
74 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
75 DROP TABLE t1,t2,t3,t4,t5,t6;
76 CREATE TABLE t1 (c1 BIGINT NOT NULL);
77 CREATE TABLE t2 (c1 BIGINT NOT NULL);
78 CREATE TABLE t3 (c1 BIGINT NOT NULL);
79 CREATE TABLE t4 (c1 BIGINT NOT NULL);
80 CREATE TABLE t5 (c1 BIGINT NOT NULL);
81 CREATE TABLE t6 (c1 BIGINT NOT NULL);
82 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
83 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
84 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
85 INSERT INTO t4 (c1) VALUES(10);
86 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
87 -- sorted_result
88 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 < t2.c1;
89 DROP TABLE t1,t2,t3,t4,t5,t6;
90 CREATE TABLE t1 (c1 TINYINT NOT NULL);
91 CREATE TABLE t2 (c1 TINYINT NOT NULL);
92 CREATE TABLE t3 (c1 TINYINT NOT NULL);
93 CREATE TABLE t4 (c1 TINYINT NOT NULL);
94 CREATE TABLE t5 (c1 TINYINT NOT NULL);
95 CREATE TABLE t6 (c1 TINYINT NOT NULL);
96 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
97 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
98 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
99 INSERT INTO t4 (c1) VALUES(10);
100 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
101 -- sorted_result
102 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
103 DROP TABLE t1,t2,t3,t4,t5,t6;
104 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
105 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
106 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
107 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
108 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
109 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
110 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
111 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
112 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
113 INSERT INTO t4 (c1) VALUES(10);
114 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
115 -- sorted_result
116 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
117 DROP TABLE t1,t2,t3,t4,t5,t6;
118 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
119 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
120 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
121 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
122 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
123 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
124 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
125 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
126 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
127 INSERT INTO t4 (c1) VALUES(10);
128 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
129 -- sorted_result
130 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
131 DROP TABLE t1,t2,t3,t4,t5,t6;
132 CREATE TABLE t1 (c1 INT NOT NULL);
133 CREATE TABLE t2 (c1 INT NOT NULL);
134 CREATE TABLE t3 (c1 INT NOT NULL);
135 CREATE TABLE t4 (c1 INT NOT NULL);
136 CREATE TABLE t5 (c1 INT NOT NULL);
137 CREATE TABLE t6 (c1 INT 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,t3 WHERE t1.c1 < t3.c1;
145 DROP TABLE t1,t2,t3,t4,t5,t6;
146 CREATE TABLE t1 (c1 INTEGER NOT NULL);
147 CREATE TABLE t2 (c1 INTEGER NOT NULL);
148 CREATE TABLE t3 (c1 INTEGER NOT NULL);
149 CREATE TABLE t4 (c1 INTEGER NOT NULL);
150 CREATE TABLE t5 (c1 INTEGER NOT NULL);
151 CREATE TABLE t6 (c1 INTEGER NOT NULL);
152 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
153 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
154 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
155 INSERT INTO t4 (c1) VALUES(10);
156 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
157 -- sorted_result
158 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
159 DROP TABLE t1,t2,t3,t4,t5,t6;
160 CREATE TABLE t1 (c1 BIGINT NOT NULL);
161 CREATE TABLE t2 (c1 BIGINT NOT NULL);
162 CREATE TABLE t3 (c1 BIGINT NOT NULL);
163 CREATE TABLE t4 (c1 BIGINT NOT NULL);
164 CREATE TABLE t5 (c1 BIGINT NOT NULL);
165 CREATE TABLE t6 (c1 BIGINT NOT NULL);
166 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
167 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
168 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
169 INSERT INTO t4 (c1) VALUES(10);
170 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
171 -- sorted_result
172 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 < t3.c1;
173 DROP TABLE t1,t2,t3,t4,t5,t6;
174 CREATE TABLE t1 (c1 TINYINT NOT NULL);
175 CREATE TABLE t2 (c1 TINYINT NOT NULL);
176 CREATE TABLE t3 (c1 TINYINT NOT NULL);
177 CREATE TABLE t4 (c1 TINYINT NOT NULL);
178 CREATE TABLE t5 (c1 TINYINT NOT NULL);
179 CREATE TABLE t6 (c1 TINYINT NOT NULL);
180 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
181 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
182 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
183 INSERT INTO t4 (c1) VALUES(10);
184 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
185 -- sorted_result
186 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
187 DROP TABLE t1,t2,t3,t4,t5,t6;
188 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
189 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
190 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
191 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
192 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
193 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
194 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
195 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
196 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
197 INSERT INTO t4 (c1) VALUES(10);
198 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
199 -- sorted_result
200 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
201 DROP TABLE t1,t2,t3,t4,t5,t6;
202 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
203 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
204 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
205 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
206 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
207 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
208 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
209 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
210 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
211 INSERT INTO t4 (c1) VALUES(10);
212 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
213 -- sorted_result
214 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
215 DROP TABLE t1,t2,t3,t4,t5,t6;
216 CREATE TABLE t1 (c1 INT NOT NULL);
217 CREATE TABLE t2 (c1 INT NOT NULL);
218 CREATE TABLE t3 (c1 INT NOT NULL);
219 CREATE TABLE t4 (c1 INT NOT NULL);
220 CREATE TABLE t5 (c1 INT NOT NULL);
221 CREATE TABLE t6 (c1 INT NOT NULL);
222 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
223 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
224 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
225 INSERT INTO t4 (c1) VALUES(10);
226 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
227 -- sorted_result
228 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
229 DROP TABLE t1,t2,t3,t4,t5,t6;
230 CREATE TABLE t1 (c1 INTEGER NOT NULL);
231 CREATE TABLE t2 (c1 INTEGER NOT NULL);
232 CREATE TABLE t3 (c1 INTEGER NOT NULL);
233 CREATE TABLE t4 (c1 INTEGER NOT NULL);
234 CREATE TABLE t5 (c1 INTEGER NOT NULL);
235 CREATE TABLE t6 (c1 INTEGER NOT NULL);
236 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
237 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
238 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
239 INSERT INTO t4 (c1) VALUES(10);
240 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
241 -- sorted_result
242 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
243 DROP TABLE t1,t2,t3,t4,t5,t6;
244 CREATE TABLE t1 (c1 BIGINT NOT NULL);
245 CREATE TABLE t2 (c1 BIGINT NOT NULL);
246 CREATE TABLE t3 (c1 BIGINT NOT NULL);
247 CREATE TABLE t4 (c1 BIGINT NOT NULL);
248 CREATE TABLE t5 (c1 BIGINT NOT NULL);
249 CREATE TABLE t6 (c1 BIGINT NOT NULL);
250 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
251 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
252 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
253 INSERT INTO t4 (c1) VALUES(10);
254 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
255 -- sorted_result
256 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 < t4.c1;
257 DROP TABLE t1,t2,t3,t4,t5,t6;
258 CREATE TABLE t1 (c1 TINYINT NOT NULL);
259 CREATE TABLE t2 (c1 TINYINT NOT NULL);
260 CREATE TABLE t3 (c1 TINYINT NOT NULL);
261 CREATE TABLE t4 (c1 TINYINT NOT NULL);
262 CREATE TABLE t5 (c1 TINYINT NOT NULL);
263 CREATE TABLE t6 (c1 TINYINT 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,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
271 DROP TABLE t1,t2,t3,t4,t5,t6;
272 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
273 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
274 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
275 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
276 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
277 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
278 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
279 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
280 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
281 INSERT INTO t4 (c1) VALUES(10);
282 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
283 -- sorted_result
284 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
285 DROP TABLE t1,t2,t3,t4,t5,t6;
286 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
287 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
288 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
289 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
290 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
291 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
292 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
293 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
294 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
295 INSERT INTO t4 (c1) VALUES(10);
296 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
297 -- sorted_result
298 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
299 DROP TABLE t1,t2,t3,t4,t5,t6;
300 CREATE TABLE t1 (c1 INT NOT NULL);
301 CREATE TABLE t2 (c1 INT NOT NULL);
302 CREATE TABLE t3 (c1 INT NOT NULL);
303 CREATE TABLE t4 (c1 INT NOT NULL);
304 CREATE TABLE t5 (c1 INT NOT NULL);
305 CREATE TABLE t6 (c1 INT NOT NULL);
306 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
307 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
308 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
309 INSERT INTO t4 (c1) VALUES(10);
310 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
311 -- sorted_result
312 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
313 DROP TABLE t1,t2,t3,t4,t5,t6;
314 CREATE TABLE t1 (c1 INTEGER NOT NULL);
315 CREATE TABLE t2 (c1 INTEGER NOT NULL);
316 CREATE TABLE t3 (c1 INTEGER NOT NULL);
317 CREATE TABLE t4 (c1 INTEGER NOT NULL);
318 CREATE TABLE t5 (c1 INTEGER NOT NULL);
319 CREATE TABLE t6 (c1 INTEGER NOT NULL);
320 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
321 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
322 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
323 INSERT INTO t4 (c1) VALUES(10);
324 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
325 -- sorted_result
326 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
327 DROP TABLE t1,t2,t3,t4,t5,t6;
328 CREATE TABLE t1 (c1 BIGINT NOT NULL);
329 CREATE TABLE t2 (c1 BIGINT NOT NULL);
330 CREATE TABLE t3 (c1 BIGINT NOT NULL);
331 CREATE TABLE t4 (c1 BIGINT NOT NULL);
332 CREATE TABLE t5 (c1 BIGINT NOT NULL);
333 CREATE TABLE t6 (c1 BIGINT NOT NULL);
334 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
335 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
336 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
337 INSERT INTO t4 (c1) VALUES(10);
338 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
339 -- sorted_result
340 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 < t5.c1;
341 DROP TABLE t1,t2,t3,t4,t5,t6;
342 CREATE TABLE t1 (c1 TINYINT NOT NULL);
343 CREATE TABLE t2 (c1 TINYINT NOT NULL);
344 CREATE TABLE t3 (c1 TINYINT NOT NULL);
345 CREATE TABLE t4 (c1 TINYINT NOT NULL);
346 CREATE TABLE t5 (c1 TINYINT NOT NULL);
347 CREATE TABLE t6 (c1 TINYINT NOT NULL);
348 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
349 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
350 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
351 INSERT INTO t4 (c1) VALUES(10);
352 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
353 -- sorted_result
354 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
355 DROP TABLE t1,t2,t3,t4,t5,t6;
356 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
357 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
358 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
359 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
360 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
361 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
362 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
363 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
364 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
365 INSERT INTO t4 (c1) VALUES(10);
366 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
367 -- sorted_result
368 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
369 DROP TABLE t1,t2,t3,t4,t5,t6;
370 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
371 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
372 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
373 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
374 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
375 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
376 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
377 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
378 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
379 INSERT INTO t4 (c1) VALUES(10);
380 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
381 -- sorted_result
382 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
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,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
397 DROP TABLE t1,t2,t3,t4,t5,t6;
398 CREATE TABLE t1 (c1 INTEGER NOT NULL);
399 CREATE TABLE t2 (c1 INTEGER NOT NULL);
400 CREATE TABLE t3 (c1 INTEGER NOT NULL);
401 CREATE TABLE t4 (c1 INTEGER NOT NULL);
402 CREATE TABLE t5 (c1 INTEGER NOT NULL);
403 CREATE TABLE t6 (c1 INTEGER NOT NULL);
404 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
405 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
406 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
407 INSERT INTO t4 (c1) VALUES(10);
408 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
409 -- sorted_result
410 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
411 DROP TABLE t1,t2,t3,t4,t5,t6;
412 CREATE TABLE t1 (c1 BIGINT NOT NULL);
413 CREATE TABLE t2 (c1 BIGINT NOT NULL);
414 CREATE TABLE t3 (c1 BIGINT NOT NULL);
415 CREATE TABLE t4 (c1 BIGINT NOT NULL);
416 CREATE TABLE t5 (c1 BIGINT NOT NULL);
417 CREATE TABLE t6 (c1 BIGINT NOT NULL);
418 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
419 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
420 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
421 INSERT INTO t4 (c1) VALUES(10);
422 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
423 -- sorted_result
424 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 < t6.c1;
425 DROP TABLE t1,t2,t3,t4,t5,t6;
426 CREATE TABLE t1 (c1 TINYINT NOT NULL);
427 CREATE TABLE t2 (c1 TINYINT NOT NULL);
428 CREATE TABLE t3 (c1 TINYINT NOT NULL);
429 CREATE TABLE t4 (c1 TINYINT NOT NULL);
430 CREATE TABLE t5 (c1 TINYINT NOT NULL);
431 CREATE TABLE t6 (c1 TINYINT NOT NULL);
432 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
433 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
434 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
435 INSERT INTO t4 (c1) VALUES(10);
436 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
437 -- sorted_result
438 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
439 DROP TABLE t1,t2,t3,t4,t5,t6;
440 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
441 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
442 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
443 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
444 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
445 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
446 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
447 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
448 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
449 INSERT INTO t4 (c1) VALUES(10);
450 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
451 -- sorted_result
452 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
453 DROP TABLE t1,t2,t3,t4,t5,t6;
454 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
455 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
456 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
457 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
458 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
459 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
460 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
461 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
462 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
463 INSERT INTO t4 (c1) VALUES(10);
464 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
465 -- sorted_result
466 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
467 DROP TABLE t1,t2,t3,t4,t5,t6;
468 CREATE TABLE t1 (c1 INT NOT NULL);
469 CREATE TABLE t2 (c1 INT NOT NULL);
470 CREATE TABLE t3 (c1 INT NOT NULL);
471 CREATE TABLE t4 (c1 INT NOT NULL);
472 CREATE TABLE t5 (c1 INT NOT NULL);
473 CREATE TABLE t6 (c1 INT NOT NULL);
474 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
475 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
476 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
477 INSERT INTO t4 (c1) VALUES(10);
478 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
479 -- sorted_result
480 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
481 DROP TABLE t1,t2,t3,t4,t5,t6;
482 CREATE TABLE t1 (c1 INTEGER NOT NULL);
483 CREATE TABLE t2 (c1 INTEGER NOT NULL);
484 CREATE TABLE t3 (c1 INTEGER NOT NULL);
485 CREATE TABLE t4 (c1 INTEGER NOT NULL);
486 CREATE TABLE t5 (c1 INTEGER NOT NULL);
487 CREATE TABLE t6 (c1 INTEGER NOT NULL);
488 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
489 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
490 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
491 INSERT INTO t4 (c1) VALUES(10);
492 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
493 -- sorted_result
494 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
495 DROP TABLE t1,t2,t3,t4,t5,t6;
496 CREATE TABLE t1 (c1 BIGINT NOT NULL);
497 CREATE TABLE t2 (c1 BIGINT NOT NULL);
498 CREATE TABLE t3 (c1 BIGINT NOT NULL);
499 CREATE TABLE t4 (c1 BIGINT NOT NULL);
500 CREATE TABLE t5 (c1 BIGINT NOT NULL);
501 CREATE TABLE t6 (c1 BIGINT NOT NULL);
502 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
503 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
504 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
505 INSERT INTO t4 (c1) VALUES(10);
506 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
507 -- sorted_result
508 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <= t2.c1;
509 DROP TABLE t1,t2,t3,t4,t5,t6;
510 CREATE TABLE t1 (c1 TINYINT NOT NULL);
511 CREATE TABLE t2 (c1 TINYINT NOT NULL);
512 CREATE TABLE t3 (c1 TINYINT NOT NULL);
513 CREATE TABLE t4 (c1 TINYINT NOT NULL);
514 CREATE TABLE t5 (c1 TINYINT NOT NULL);
515 CREATE TABLE t6 (c1 TINYINT 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,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
523 DROP TABLE t1,t2,t3,t4,t5,t6;
524 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
525 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
526 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
527 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
528 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
529 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
530 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
531 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
532 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
533 INSERT INTO t4 (c1) VALUES(10);
534 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
535 -- sorted_result
536 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
537 DROP TABLE t1,t2,t3,t4,t5,t6;
538 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
539 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
540 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
541 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
542 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
543 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
544 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
545 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
546 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
547 INSERT INTO t4 (c1) VALUES(10);
548 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
549 -- sorted_result
550 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
551 DROP TABLE t1,t2,t3,t4,t5,t6;
552 CREATE TABLE t1 (c1 INT NOT NULL);
553 CREATE TABLE t2 (c1 INT NOT NULL);
554 CREATE TABLE t3 (c1 INT NOT NULL);
555 CREATE TABLE t4 (c1 INT NOT NULL);
556 CREATE TABLE t5 (c1 INT NOT NULL);
557 CREATE TABLE t6 (c1 INT NOT NULL);
558 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
559 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
560 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
561 INSERT INTO t4 (c1) VALUES(10);
562 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
563 -- sorted_result
564 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
565 DROP TABLE t1,t2,t3,t4,t5,t6;
566 CREATE TABLE t1 (c1 INTEGER NOT NULL);
567 CREATE TABLE t2 (c1 INTEGER NOT NULL);
568 CREATE TABLE t3 (c1 INTEGER NOT NULL);
569 CREATE TABLE t4 (c1 INTEGER NOT NULL);
570 CREATE TABLE t5 (c1 INTEGER NOT NULL);
571 CREATE TABLE t6 (c1 INTEGER NOT NULL);
572 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
573 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
574 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
575 INSERT INTO t4 (c1) VALUES(10);
576 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
577 -- sorted_result
578 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
579 DROP TABLE t1,t2,t3,t4,t5,t6;
580 CREATE TABLE t1 (c1 BIGINT NOT NULL);
581 CREATE TABLE t2 (c1 BIGINT NOT NULL);
582 CREATE TABLE t3 (c1 BIGINT NOT NULL);
583 CREATE TABLE t4 (c1 BIGINT NOT NULL);
584 CREATE TABLE t5 (c1 BIGINT NOT NULL);
585 CREATE TABLE t6 (c1 BIGINT NOT NULL);
586 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
587 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
588 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
589 INSERT INTO t4 (c1) VALUES(10);
590 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
591 -- sorted_result
592 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <= t3.c1;
593 DROP TABLE t1,t2,t3,t4,t5,t6;
594 CREATE TABLE t1 (c1 TINYINT NOT NULL);
595 CREATE TABLE t2 (c1 TINYINT NOT NULL);
596 CREATE TABLE t3 (c1 TINYINT NOT NULL);
597 CREATE TABLE t4 (c1 TINYINT NOT NULL);
598 CREATE TABLE t5 (c1 TINYINT NOT NULL);
599 CREATE TABLE t6 (c1 TINYINT NOT NULL);
600 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
601 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
602 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
603 INSERT INTO t4 (c1) VALUES(10);
604 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
605 -- sorted_result
606 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
607 DROP TABLE t1,t2,t3,t4,t5,t6;
608 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
609 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
610 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
611 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
612 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
613 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
614 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
615 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
616 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
617 INSERT INTO t4 (c1) VALUES(10);
618 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
619 -- sorted_result
620 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
621 DROP TABLE t1,t2,t3,t4,t5,t6;
622 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
623 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
624 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
625 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
626 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
627 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
628 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
629 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
630 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
631 INSERT INTO t4 (c1) VALUES(10);
632 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
633 -- sorted_result
634 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
635 DROP TABLE t1,t2,t3,t4,t5,t6;
636 CREATE TABLE t1 (c1 INT NOT NULL);
637 CREATE TABLE t2 (c1 INT NOT NULL);
638 CREATE TABLE t3 (c1 INT NOT NULL);
639 CREATE TABLE t4 (c1 INT NOT NULL);
640 CREATE TABLE t5 (c1 INT NOT NULL);
641 CREATE TABLE t6 (c1 INT 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,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
649 DROP TABLE t1,t2,t3,t4,t5,t6;
650 CREATE TABLE t1 (c1 INTEGER NOT NULL);
651 CREATE TABLE t2 (c1 INTEGER NOT NULL);
652 CREATE TABLE t3 (c1 INTEGER NOT NULL);
653 CREATE TABLE t4 (c1 INTEGER NOT NULL);
654 CREATE TABLE t5 (c1 INTEGER NOT NULL);
655 CREATE TABLE t6 (c1 INTEGER NOT NULL);
656 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
657 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
658 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
659 INSERT INTO t4 (c1) VALUES(10);
660 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
661 -- sorted_result
662 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
663 DROP TABLE t1,t2,t3,t4,t5,t6;
664 CREATE TABLE t1 (c1 BIGINT NOT NULL);
665 CREATE TABLE t2 (c1 BIGINT NOT NULL);
666 CREATE TABLE t3 (c1 BIGINT NOT NULL);
667 CREATE TABLE t4 (c1 BIGINT NOT NULL);
668 CREATE TABLE t5 (c1 BIGINT NOT NULL);
669 CREATE TABLE t6 (c1 BIGINT NOT NULL);
670 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
671 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
672 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
673 INSERT INTO t4 (c1) VALUES(10);
674 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
675 -- sorted_result
676 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <= t4.c1;
677 DROP TABLE t1,t2,t3,t4,t5,t6;
678 CREATE TABLE t1 (c1 TINYINT NOT NULL);
679 CREATE TABLE t2 (c1 TINYINT NOT NULL);
680 CREATE TABLE t3 (c1 TINYINT NOT NULL);
681 CREATE TABLE t4 (c1 TINYINT NOT NULL);
682 CREATE TABLE t5 (c1 TINYINT NOT NULL);
683 CREATE TABLE t6 (c1 TINYINT NOT NULL);
684 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
685 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
686 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
687 INSERT INTO t4 (c1) VALUES(10);
688 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
689 -- sorted_result
690 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
691 DROP TABLE t1,t2,t3,t4,t5,t6;
692 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
693 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
694 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
695 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
696 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
697 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
698 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
699 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
700 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
701 INSERT INTO t4 (c1) VALUES(10);
702 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
703 -- sorted_result
704 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
705 DROP TABLE t1,t2,t3,t4,t5,t6;
706 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
707 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
708 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
709 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
710 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
711 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
712 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
713 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
714 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
715 INSERT INTO t4 (c1) VALUES(10);
716 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
717 -- sorted_result
718 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
719 DROP TABLE t1,t2,t3,t4,t5,t6;
720 CREATE TABLE t1 (c1 INT NOT NULL);
721 CREATE TABLE t2 (c1 INT NOT NULL);
722 CREATE TABLE t3 (c1 INT NOT NULL);
723 CREATE TABLE t4 (c1 INT NOT NULL);
724 CREATE TABLE t5 (c1 INT NOT NULL);
725 CREATE TABLE t6 (c1 INT NOT NULL);
726 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
727 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
728 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
729 INSERT INTO t4 (c1) VALUES(10);
730 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
731 -- sorted_result
732 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
733 DROP TABLE t1,t2,t3,t4,t5,t6;
734 CREATE TABLE t1 (c1 INTEGER NOT NULL);
735 CREATE TABLE t2 (c1 INTEGER NOT NULL);
736 CREATE TABLE t3 (c1 INTEGER NOT NULL);
737 CREATE TABLE t4 (c1 INTEGER NOT NULL);
738 CREATE TABLE t5 (c1 INTEGER NOT NULL);
739 CREATE TABLE t6 (c1 INTEGER NOT NULL);
740 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
741 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
742 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
743 INSERT INTO t4 (c1) VALUES(10);
744 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
745 -- sorted_result
746 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
747 DROP TABLE t1,t2,t3,t4,t5,t6;
748 CREATE TABLE t1 (c1 BIGINT NOT NULL);
749 CREATE TABLE t2 (c1 BIGINT NOT NULL);
750 CREATE TABLE t3 (c1 BIGINT NOT NULL);
751 CREATE TABLE t4 (c1 BIGINT NOT NULL);
752 CREATE TABLE t5 (c1 BIGINT NOT NULL);
753 CREATE TABLE t6 (c1 BIGINT NOT NULL);
754 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
755 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
756 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
757 INSERT INTO t4 (c1) VALUES(10);
758 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
759 -- sorted_result
760 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <= t5.c1;
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,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
775 DROP TABLE t1,t2,t3,t4,t5,t6;
776 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
777 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
778 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
779 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
780 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
781 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
782 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
784 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
785 INSERT INTO t4 (c1) VALUES(10);
786 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
787 -- sorted_result
788 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
789 DROP TABLE t1,t2,t3,t4,t5,t6;
790 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
791 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
792 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
793 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
794 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
795 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
796 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
797 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
798 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
799 INSERT INTO t4 (c1) VALUES(10);
800 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
801 -- sorted_result
802 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
803 DROP TABLE t1,t2,t3,t4,t5,t6;
804 CREATE TABLE t1 (c1 INT NOT NULL);
805 CREATE TABLE t2 (c1 INT NOT NULL);
806 CREATE TABLE t3 (c1 INT NOT NULL);
807 CREATE TABLE t4 (c1 INT NOT NULL);
808 CREATE TABLE t5 (c1 INT NOT NULL);
809 CREATE TABLE t6 (c1 INT NOT NULL);
810 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
811 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
812 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
813 INSERT INTO t4 (c1) VALUES(10);
814 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
815 -- sorted_result
816 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
817 DROP TABLE t1,t2,t3,t4,t5,t6;
818 CREATE TABLE t1 (c1 INTEGER NOT NULL);
819 CREATE TABLE t2 (c1 INTEGER NOT NULL);
820 CREATE TABLE t3 (c1 INTEGER NOT NULL);
821 CREATE TABLE t4 (c1 INTEGER NOT NULL);
822 CREATE TABLE t5 (c1 INTEGER NOT NULL);
823 CREATE TABLE t6 (c1 INTEGER NOT NULL);
824 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
825 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
826 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
827 INSERT INTO t4 (c1) VALUES(10);
828 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
829 -- sorted_result
830 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
831 DROP TABLE t1,t2,t3,t4,t5,t6;
832 CREATE TABLE t1 (c1 BIGINT NOT NULL);
833 CREATE TABLE t2 (c1 BIGINT NOT NULL);
834 CREATE TABLE t3 (c1 BIGINT NOT NULL);
835 CREATE TABLE t4 (c1 BIGINT NOT NULL);
836 CREATE TABLE t5 (c1 BIGINT NOT NULL);
837 CREATE TABLE t6 (c1 BIGINT NOT NULL);
838 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
839 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
840 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
841 INSERT INTO t4 (c1) VALUES(10);
842 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
843 -- sorted_result
844 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <= t6.c1;
845 DROP TABLE t1,t2,t3,t4,t5,t6;
846 CREATE TABLE t1 (c1 TINYINT NOT NULL);
847 CREATE TABLE t2 (c1 TINYINT NOT NULL);
848 CREATE TABLE t3 (c1 TINYINT NOT NULL);
849 CREATE TABLE t4 (c1 TINYINT NOT NULL);
850 CREATE TABLE t5 (c1 TINYINT NOT NULL);
851 CREATE TABLE t6 (c1 TINYINT NOT NULL);
852 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
853 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
854 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
855 INSERT INTO t4 (c1) VALUES(10);
856 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
857 -- sorted_result
858 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
859 DROP TABLE t1,t2,t3,t4,t5,t6;
860 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
861 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
862 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
863 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
864 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
865 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
866 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
867 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
868 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
869 INSERT INTO t4 (c1) VALUES(10);
870 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
871 -- sorted_result
872 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
873 DROP TABLE t1,t2,t3,t4,t5,t6;
874 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
875 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
876 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
877 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
878 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
879 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
880 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
881 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
882 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
883 INSERT INTO t4 (c1) VALUES(10);
884 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
885 -- sorted_result
886 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
887 DROP TABLE t1,t2,t3,t4,t5,t6;
888 CREATE TABLE t1 (c1 INT NOT NULL);
889 CREATE TABLE t2 (c1 INT NOT NULL);
890 CREATE TABLE t3 (c1 INT NOT NULL);
891 CREATE TABLE t4 (c1 INT NOT NULL);
892 CREATE TABLE t5 (c1 INT NOT NULL);
893 CREATE TABLE t6 (c1 INT 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,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
901 DROP TABLE t1,t2,t3,t4,t5,t6;
902 CREATE TABLE t1 (c1 INTEGER NOT NULL);
903 CREATE TABLE t2 (c1 INTEGER NOT NULL);
904 CREATE TABLE t3 (c1 INTEGER NOT NULL);
905 CREATE TABLE t4 (c1 INTEGER NOT NULL);
906 CREATE TABLE t5 (c1 INTEGER NOT NULL);
907 CREATE TABLE t6 (c1 INTEGER NOT NULL);
908 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
909 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
910 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
911 INSERT INTO t4 (c1) VALUES(10);
912 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
913 -- sorted_result
914 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
915 DROP TABLE t1,t2,t3,t4,t5,t6;
916 CREATE TABLE t1 (c1 BIGINT NOT NULL);
917 CREATE TABLE t2 (c1 BIGINT NOT NULL);
918 CREATE TABLE t3 (c1 BIGINT NOT NULL);
919 CREATE TABLE t4 (c1 BIGINT NOT NULL);
920 CREATE TABLE t5 (c1 BIGINT NOT NULL);
921 CREATE TABLE t6 (c1 BIGINT NOT NULL);
922 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
923 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
924 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
925 INSERT INTO t4 (c1) VALUES(10);
926 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
927 -- sorted_result
928 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 = t2.c1;
929 DROP TABLE t1,t2,t3,t4,t5,t6;
930 CREATE TABLE t1 (c1 TINYINT NOT NULL);
931 CREATE TABLE t2 (c1 TINYINT NOT NULL);
932 CREATE TABLE t3 (c1 TINYINT NOT NULL);
933 CREATE TABLE t4 (c1 TINYINT NOT NULL);
934 CREATE TABLE t5 (c1 TINYINT NOT NULL);
935 CREATE TABLE t6 (c1 TINYINT NOT NULL);
936 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
937 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
938 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
939 INSERT INTO t4 (c1) VALUES(10);
940 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
941 -- sorted_result
942 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
943 DROP TABLE t1,t2,t3,t4,t5,t6;
944 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
945 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
946 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
947 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
948 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
949 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
950 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
951 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
952 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
953 INSERT INTO t4 (c1) VALUES(10);
954 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
955 -- sorted_result
956 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
957 DROP TABLE t1,t2,t3,t4,t5,t6;
958 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
959 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
960 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
961 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
962 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
963 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
964 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
965 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
966 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
967 INSERT INTO t4 (c1) VALUES(10);
968 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
969 -- sorted_result
970 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
971 DROP TABLE t1,t2,t3,t4,t5,t6;
972 CREATE TABLE t1 (c1 INT NOT NULL);
973 CREATE TABLE t2 (c1 INT NOT NULL);
974 CREATE TABLE t3 (c1 INT NOT NULL);
975 CREATE TABLE t4 (c1 INT NOT NULL);
976 CREATE TABLE t5 (c1 INT NOT NULL);
977 CREATE TABLE t6 (c1 INT NOT NULL);
978 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
979 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
980 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
981 INSERT INTO t4 (c1) VALUES(10);
982 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
983 -- sorted_result
984 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
985 DROP TABLE t1,t2,t3,t4,t5,t6;
986 CREATE TABLE t1 (c1 INTEGER NOT NULL);
987 CREATE TABLE t2 (c1 INTEGER NOT NULL);
988 CREATE TABLE t3 (c1 INTEGER NOT NULL);
989 CREATE TABLE t4 (c1 INTEGER NOT NULL);
990 CREATE TABLE t5 (c1 INTEGER NOT NULL);
991 CREATE TABLE t6 (c1 INTEGER NOT NULL);
992 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
993 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
994 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
995 INSERT INTO t4 (c1) VALUES(10);
996 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
997 -- sorted_result
998 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
999 DROP TABLE t1,t2,t3,t4,t5,t6;
1000 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1001 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1002 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1003 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1004 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1005 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1006 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1007 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1008 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1009 INSERT INTO t4 (c1) VALUES(10);
1010 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1011 -- sorted_result
1012 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 = t3.c1;
1013 DROP TABLE t1,t2,t3,t4,t5,t6;
1014 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1015 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1016 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1017 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1018 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1019 CREATE TABLE t6 (c1 TINYINT 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,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
1027 DROP TABLE t1,t2,t3,t4,t5,t6;
1028 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1029 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1030 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1031 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1032 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1033 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1034 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1035 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1036 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1037 INSERT INTO t4 (c1) VALUES(10);
1038 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1039 -- sorted_result
1040 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
1041 DROP TABLE t1,t2,t3,t4,t5,t6;
1042 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1043 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1044 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1045 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1046 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1047 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1048 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1049 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1050 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1051 INSERT INTO t4 (c1) VALUES(10);
1052 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1053 -- sorted_result
1054 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
1055 DROP TABLE t1,t2,t3,t4,t5,t6;
1056 CREATE TABLE t1 (c1 INT NOT NULL);
1057 CREATE TABLE t2 (c1 INT NOT NULL);
1058 CREATE TABLE t3 (c1 INT NOT NULL);
1059 CREATE TABLE t4 (c1 INT NOT NULL);
1060 CREATE TABLE t5 (c1 INT NOT NULL);
1061 CREATE TABLE t6 (c1 INT NOT NULL);
1062 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1063 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1064 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1065 INSERT INTO t4 (c1) VALUES(10);
1066 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1067 -- sorted_result
1068 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
1069 DROP TABLE t1,t2,t3,t4,t5,t6;
1070 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1071 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1072 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1073 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1074 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1075 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1076 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1077 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1078 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1079 INSERT INTO t4 (c1) VALUES(10);
1080 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1081 -- sorted_result
1082 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
1083 DROP TABLE t1,t2,t3,t4,t5,t6;
1084 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1085 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1086 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1087 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1088 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1089 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1090 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1091 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1092 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1093 INSERT INTO t4 (c1) VALUES(10);
1094 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1095 -- sorted_result
1096 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 = t4.c1;
1097 DROP TABLE t1,t2,t3,t4,t5,t6;
1098 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1099 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1100 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1101 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1102 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1103 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1104 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1105 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1106 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1107 INSERT INTO t4 (c1) VALUES(10);
1108 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1109 -- sorted_result
1110 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
1111 DROP TABLE t1,t2,t3,t4,t5,t6;
1112 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1113 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1114 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1115 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1116 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1117 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1118 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1119 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1120 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1121 INSERT INTO t4 (c1) VALUES(10);
1122 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1123 -- sorted_result
1124 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
1125 DROP TABLE t1,t2,t3,t4,t5,t6;
1126 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1127 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1128 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1129 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1130 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1131 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1132 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1133 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1134 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1135 INSERT INTO t4 (c1) VALUES(10);
1136 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1137 -- sorted_result
1138 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
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,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
1153 DROP TABLE t1,t2,t3,t4,t5,t6;
1154 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1155 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1156 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1157 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1158 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1159 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1160 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1161 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1162 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1163 INSERT INTO t4 (c1) VALUES(10);
1164 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1165 -- sorted_result
1166 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
1167 DROP TABLE t1,t2,t3,t4,t5,t6;
1168 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1169 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1170 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1171 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1172 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1173 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1174 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1175 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1176 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1177 INSERT INTO t4 (c1) VALUES(10);
1178 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1179 -- sorted_result
1180 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 = t5.c1;
1181 DROP TABLE t1,t2,t3,t4,t5,t6;
1182 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1183 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1184 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1185 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1186 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1187 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1188 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1189 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1190 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1191 INSERT INTO t4 (c1) VALUES(10);
1192 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1193 -- sorted_result
1194 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
1195 DROP TABLE t1,t2,t3,t4,t5,t6;
1196 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1197 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1198 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1199 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1200 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1201 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1202 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1203 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1204 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1205 INSERT INTO t4 (c1) VALUES(10);
1206 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1207 -- sorted_result
1208 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
1209 DROP TABLE t1,t2,t3,t4,t5,t6;
1210 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1211 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1212 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1213 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1214 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1215 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1216 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1217 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1218 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1219 INSERT INTO t4 (c1) VALUES(10);
1220 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1221 -- sorted_result
1222 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
1223 DROP TABLE t1,t2,t3,t4,t5,t6;
1224 CREATE TABLE t1 (c1 INT NOT NULL);
1225 CREATE TABLE t2 (c1 INT NOT NULL);
1226 CREATE TABLE t3 (c1 INT NOT NULL);
1227 CREATE TABLE t4 (c1 INT NOT NULL);
1228 CREATE TABLE t5 (c1 INT NOT NULL);
1229 CREATE TABLE t6 (c1 INT NOT NULL);
1230 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1231 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1232 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1233 INSERT INTO t4 (c1) VALUES(10);
1234 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1235 -- sorted_result
1236 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
1237 DROP TABLE t1,t2,t3,t4,t5,t6;
1238 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1239 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1240 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1241 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1242 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1243 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1244 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1245 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1246 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1247 INSERT INTO t4 (c1) VALUES(10);
1248 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1249 -- sorted_result
1250 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
1251 DROP TABLE t1,t2,t3,t4,t5,t6;
1252 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1253 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1254 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1255 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1256 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1257 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1258 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1259 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1260 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1261 INSERT INTO t4 (c1) VALUES(10);
1262 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1263 -- sorted_result
1264 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 = t6.c1;
1265 DROP TABLE t1,t2,t3,t4,t5,t6;
1266 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1267 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1268 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1269 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1270 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1271 CREATE TABLE t6 (c1 TINYINT 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,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
1279 DROP TABLE t1,t2,t3,t4,t5,t6;
1280 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1281 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1282 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1283 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1284 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1285 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1286 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1287 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1288 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1289 INSERT INTO t4 (c1) VALUES(10);
1290 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1291 -- sorted_result
1292 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
1293 DROP TABLE t1,t2,t3,t4,t5,t6;
1294 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1295 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1296 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1297 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1298 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1299 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1300 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1301 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1302 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1303 INSERT INTO t4 (c1) VALUES(10);
1304 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1305 -- sorted_result
1306 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
1307 DROP TABLE t1,t2,t3,t4,t5,t6;
1308 CREATE TABLE t1 (c1 INT NOT NULL);
1309 CREATE TABLE t2 (c1 INT NOT NULL);
1310 CREATE TABLE t3 (c1 INT NOT NULL);
1311 CREATE TABLE t4 (c1 INT NOT NULL);
1312 CREATE TABLE t5 (c1 INT NOT NULL);
1313 CREATE TABLE t6 (c1 INT NOT NULL);
1314 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1315 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1316 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1317 INSERT INTO t4 (c1) VALUES(10);
1318 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1319 -- sorted_result
1320 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
1321 DROP TABLE t1,t2,t3,t4,t5,t6;
1322 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1323 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1324 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1325 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1326 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1327 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1328 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1329 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1330 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1331 INSERT INTO t4 (c1) VALUES(10);
1332 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1333 -- sorted_result
1334 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
1335 DROP TABLE t1,t2,t3,t4,t5,t6;
1336 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1337 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1338 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1339 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1340 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1341 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1342 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1343 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1344 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1345 INSERT INTO t4 (c1) VALUES(10);
1346 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1347 -- sorted_result
1348 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 >= t2.c1;
1349 DROP TABLE t1,t2,t3,t4,t5,t6;
1350 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1351 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1352 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1353 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1354 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1355 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1356 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1357 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1358 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1359 INSERT INTO t4 (c1) VALUES(10);
1360 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1361 -- sorted_result
1362 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
1363 DROP TABLE t1,t2,t3,t4,t5,t6;
1364 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1365 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1366 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1367 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1368 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1369 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1370 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1371 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1372 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1373 INSERT INTO t4 (c1) VALUES(10);
1374 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1375 -- sorted_result
1376 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
1377 DROP TABLE t1,t2,t3,t4,t5,t6;
1378 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1379 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1380 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1381 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1382 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1383 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1384 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1385 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1386 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1387 INSERT INTO t4 (c1) VALUES(10);
1388 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1389 -- sorted_result
1390 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
1391 DROP TABLE t1,t2,t3,t4,t5,t6;
1392 CREATE TABLE t1 (c1 INT NOT NULL);
1393 CREATE TABLE t2 (c1 INT NOT NULL);
1394 CREATE TABLE t3 (c1 INT NOT NULL);
1395 CREATE TABLE t4 (c1 INT NOT NULL);
1396 CREATE TABLE t5 (c1 INT NOT NULL);
1397 CREATE TABLE t6 (c1 INT 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,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
1405 DROP TABLE t1,t2,t3,t4,t5,t6;
1406 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1407 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1408 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1409 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1410 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1411 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1412 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1413 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1414 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1415 INSERT INTO t4 (c1) VALUES(10);
1416 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1417 -- sorted_result
1418 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
1419 DROP TABLE t1,t2,t3,t4,t5,t6;
1420 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1421 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1422 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1423 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1424 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1425 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1426 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1427 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1428 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1429 INSERT INTO t4 (c1) VALUES(10);
1430 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1431 -- sorted_result
1432 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 >= t3.c1;
1433 DROP TABLE t1,t2,t3,t4,t5,t6;
1434 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1435 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1436 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1437 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1438 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1439 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1440 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1441 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1442 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1443 INSERT INTO t4 (c1) VALUES(10);
1444 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1445 -- sorted_result
1446 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
1447 DROP TABLE t1,t2,t3,t4,t5,t6;
1448 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1449 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1450 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1451 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1452 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1453 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1454 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1455 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1456 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1457 INSERT INTO t4 (c1) VALUES(10);
1458 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1459 -- sorted_result
1460 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
1461 DROP TABLE t1,t2,t3,t4,t5,t6;
1462 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1463 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1464 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1465 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1466 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1467 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1468 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1469 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1470 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1471 INSERT INTO t4 (c1) VALUES(10);
1472 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1473 -- sorted_result
1474 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
1475 DROP TABLE t1,t2,t3,t4,t5,t6;
1476 CREATE TABLE t1 (c1 INT NOT NULL);
1477 CREATE TABLE t2 (c1 INT NOT NULL);
1478 CREATE TABLE t3 (c1 INT NOT NULL);
1479 CREATE TABLE t4 (c1 INT NOT NULL);
1480 CREATE TABLE t5 (c1 INT NOT NULL);
1481 CREATE TABLE t6 (c1 INT NOT NULL);
1482 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1483 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1484 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1485 INSERT INTO t4 (c1) VALUES(10);
1486 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1487 -- sorted_result
1488 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
1489 DROP TABLE t1,t2,t3,t4,t5,t6;
1490 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1491 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1492 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1493 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1494 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1495 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1496 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1497 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1498 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1499 INSERT INTO t4 (c1) VALUES(10);
1500 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1501 -- sorted_result
1502 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
1503 DROP TABLE t1,t2,t3,t4,t5,t6;
1504 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1505 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1506 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1507 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1508 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1509 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1510 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1511 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1512 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1513 INSERT INTO t4 (c1) VALUES(10);
1514 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1515 -- sorted_result
1516 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 >= t4.c1;
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,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
1531 DROP TABLE t1,t2,t3,t4,t5,t6;
1532 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1533 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1534 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1535 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1536 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1537 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1538 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1539 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1540 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1541 INSERT INTO t4 (c1) VALUES(10);
1542 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1543 -- sorted_result
1544 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
1545 DROP TABLE t1,t2,t3,t4,t5,t6;
1546 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1547 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1548 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1549 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1550 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1551 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1552 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1553 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1554 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1555 INSERT INTO t4 (c1) VALUES(10);
1556 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1557 -- sorted_result
1558 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
1559 DROP TABLE t1,t2,t3,t4,t5,t6;
1560 CREATE TABLE t1 (c1 INT NOT NULL);
1561 CREATE TABLE t2 (c1 INT NOT NULL);
1562 CREATE TABLE t3 (c1 INT NOT NULL);
1563 CREATE TABLE t4 (c1 INT NOT NULL);
1564 CREATE TABLE t5 (c1 INT NOT NULL);
1565 CREATE TABLE t6 (c1 INT NOT NULL);
1566 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1567 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1568 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1569 INSERT INTO t4 (c1) VALUES(10);
1570 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1571 -- sorted_result
1572 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
1573 DROP TABLE t1,t2,t3,t4,t5,t6;
1574 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1575 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1576 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1577 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1578 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1579 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1580 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1581 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1582 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1583 INSERT INTO t4 (c1) VALUES(10);
1584 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1585 -- sorted_result
1586 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
1587 DROP TABLE t1,t2,t3,t4,t5,t6;
1588 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1589 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1590 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1591 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1592 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1593 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1594 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1595 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1596 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1597 INSERT INTO t4 (c1) VALUES(10);
1598 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1599 -- sorted_result
1600 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 >= t5.c1;
1601 DROP TABLE t1,t2,t3,t4,t5,t6;
1602 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1603 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1604 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1605 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1606 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1607 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1608 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1609 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1610 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1611 INSERT INTO t4 (c1) VALUES(10);
1612 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1613 -- sorted_result
1614 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
1615 DROP TABLE t1,t2,t3,t4,t5,t6;
1616 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1617 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1618 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1619 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1620 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1621 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1622 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1623 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1624 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1625 INSERT INTO t4 (c1) VALUES(10);
1626 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1627 -- sorted_result
1628 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
1629 DROP TABLE t1,t2,t3,t4,t5,t6;
1630 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1631 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1632 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1633 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1634 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1635 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1636 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1637 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1638 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1639 INSERT INTO t4 (c1) VALUES(10);
1640 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1641 -- sorted_result
1642 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
1643 DROP TABLE t1,t2,t3,t4,t5,t6;
1644 CREATE TABLE t1 (c1 INT NOT NULL);
1645 CREATE TABLE t2 (c1 INT NOT NULL);
1646 CREATE TABLE t3 (c1 INT NOT NULL);
1647 CREATE TABLE t4 (c1 INT NOT NULL);
1648 CREATE TABLE t5 (c1 INT NOT NULL);
1649 CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
1657 DROP TABLE t1,t2,t3,t4,t5,t6;
1658 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1659 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1660 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1661 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1662 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1663 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1664 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1665 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1666 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1667 INSERT INTO t4 (c1) VALUES(10);
1668 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1669 -- sorted_result
1670 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
1671 DROP TABLE t1,t2,t3,t4,t5,t6;
1672 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1673 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1674 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1675 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1676 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1677 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1678 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1679 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1680 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1681 INSERT INTO t4 (c1) VALUES(10);
1682 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1683 -- sorted_result
1684 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 >= t6.c1;
1685 DROP TABLE t1,t2,t3,t4,t5,t6;
1686 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1687 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1688 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1689 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1690 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1691 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1692 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1693 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1694 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1695 INSERT INTO t4 (c1) VALUES(10);
1696 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1697 -- sorted_result
1698 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
1699 DROP TABLE t1,t2,t3,t4,t5,t6;
1700 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1701 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1702 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1703 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1704 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1705 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1706 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1707 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1708 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1709 INSERT INTO t4 (c1) VALUES(10);
1710 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1711 -- sorted_result
1712 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
1713 DROP TABLE t1,t2,t3,t4,t5,t6;
1714 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1715 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1716 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1717 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1718 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1719 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1720 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1721 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1722 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1723 INSERT INTO t4 (c1) VALUES(10);
1724 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1725 -- sorted_result
1726 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
1727 DROP TABLE t1,t2,t3,t4,t5,t6;
1728 CREATE TABLE t1 (c1 INT NOT NULL);
1729 CREATE TABLE t2 (c1 INT NOT NULL);
1730 CREATE TABLE t3 (c1 INT NOT NULL);
1731 CREATE TABLE t4 (c1 INT NOT NULL);
1732 CREATE TABLE t5 (c1 INT NOT NULL);
1733 CREATE TABLE t6 (c1 INT NOT NULL);
1734 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1735 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1736 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1737 INSERT INTO t4 (c1) VALUES(10);
1738 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1739 -- sorted_result
1740 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
1741 DROP TABLE t1,t2,t3,t4,t5,t6;
1742 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1743 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1744 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1745 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1746 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1747 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1748 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1749 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1750 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1751 INSERT INTO t4 (c1) VALUES(10);
1752 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1753 -- sorted_result
1754 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
1755 DROP TABLE t1,t2,t3,t4,t5,t6;
1756 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1757 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1758 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1759 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1760 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1761 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1762 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1763 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1764 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1765 INSERT INTO t4 (c1) VALUES(10);
1766 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1767 -- sorted_result
1768 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 != t2.c1;
1769 DROP TABLE t1,t2,t3,t4,t5,t6;
1770 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1771 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1772 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1773 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1774 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1775 CREATE TABLE t6 (c1 TINYINT 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,t3 WHERE t1.c1 != t3.c1;
1783 DROP TABLE t1,t2,t3,t4,t5,t6;
1784 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1785 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1786 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1787 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1788 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1789 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1790 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1791 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1792 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1793 INSERT INTO t4 (c1) VALUES(10);
1794 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1795 -- sorted_result
1796 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
1797 DROP TABLE t1,t2,t3,t4,t5,t6;
1798 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1799 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1800 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1801 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1802 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1803 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1804 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1805 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1806 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1807 INSERT INTO t4 (c1) VALUES(10);
1808 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1809 -- sorted_result
1810 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
1811 DROP TABLE t1,t2,t3,t4,t5,t6;
1812 CREATE TABLE t1 (c1 INT NOT NULL);
1813 CREATE TABLE t2 (c1 INT NOT NULL);
1814 CREATE TABLE t3 (c1 INT NOT NULL);
1815 CREATE TABLE t4 (c1 INT NOT NULL);
1816 CREATE TABLE t5 (c1 INT NOT NULL);
1817 CREATE TABLE t6 (c1 INT NOT NULL);
1818 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1819 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1820 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1821 INSERT INTO t4 (c1) VALUES(10);
1822 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1823 -- sorted_result
1824 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
1825 DROP TABLE t1,t2,t3,t4,t5,t6;
1826 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1827 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1828 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1829 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1830 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1831 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1832 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1833 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1834 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1835 INSERT INTO t4 (c1) VALUES(10);
1836 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1837 -- sorted_result
1838 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
1839 DROP TABLE t1,t2,t3,t4,t5,t6;
1840 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1841 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1842 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1843 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1844 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1845 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1846 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1847 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1848 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1849 INSERT INTO t4 (c1) VALUES(10);
1850 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1851 -- sorted_result
1852 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 != t3.c1;
1853 DROP TABLE t1,t2,t3,t4,t5,t6;
1854 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1855 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1856 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1857 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1858 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1859 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1860 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1861 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1862 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1863 INSERT INTO t4 (c1) VALUES(10);
1864 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1865 -- sorted_result
1866 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
1867 DROP TABLE t1,t2,t3,t4,t5,t6;
1868 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1869 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1870 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1871 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1872 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1873 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1874 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1875 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1876 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1877 INSERT INTO t4 (c1) VALUES(10);
1878 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1879 -- sorted_result
1880 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
1881 DROP TABLE t1,t2,t3,t4,t5,t6;
1882 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1883 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1884 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1885 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1886 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1887 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1888 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1889 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1890 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1891 INSERT INTO t4 (c1) VALUES(10);
1892 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1893 -- sorted_result
1894 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
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,t4 WHERE t1.c1 != t4.c1;
1909 DROP TABLE t1,t2,t3,t4,t5,t6;
1910 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1911 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1912 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1913 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1914 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1915 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1916 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1917 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1918 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1919 INSERT INTO t4 (c1) VALUES(10);
1920 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1921 -- sorted_result
1922 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
1923 DROP TABLE t1,t2,t3,t4,t5,t6;
1924 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1925 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1926 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1927 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1928 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1929 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1930 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1931 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1932 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1933 INSERT INTO t4 (c1) VALUES(10);
1934 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1935 -- sorted_result
1936 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 != t4.c1;
1937 DROP TABLE t1,t2,t3,t4,t5,t6;
1938 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1939 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1940 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1941 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1942 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1943 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1944 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1945 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1946 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1947 INSERT INTO t4 (c1) VALUES(10);
1948 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1949 -- sorted_result
1950 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
1951 DROP TABLE t1,t2,t3,t4,t5,t6;
1952 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1953 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1954 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1955 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1956 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1957 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1958 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1959 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1960 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1961 INSERT INTO t4 (c1) VALUES(10);
1962 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1963 -- sorted_result
1964 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
1965 DROP TABLE t1,t2,t3,t4,t5,t6;
1966 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1967 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1968 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1969 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1970 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1971 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1972 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1973 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1974 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1975 INSERT INTO t4 (c1) VALUES(10);
1976 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1977 -- sorted_result
1978 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
1979 DROP TABLE t1,t2,t3,t4,t5,t6;
1980 CREATE TABLE t1 (c1 INT NOT NULL);
1981 CREATE TABLE t2 (c1 INT NOT NULL);
1982 CREATE TABLE t3 (c1 INT NOT NULL);
1983 CREATE TABLE t4 (c1 INT NOT NULL);
1984 CREATE TABLE t5 (c1 INT NOT NULL);
1985 CREATE TABLE t6 (c1 INT NOT NULL);
1986 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1987 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1988 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1989 INSERT INTO t4 (c1) VALUES(10);
1990 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1991 -- sorted_result
1992 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
1993 DROP TABLE t1,t2,t3,t4,t5,t6;
1994 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1995 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1996 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1997 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1998 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1999 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2000 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2001 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2002 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2003 INSERT INTO t4 (c1) VALUES(10);
2004 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2005 -- sorted_result
2006 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
2007 DROP TABLE t1,t2,t3,t4,t5,t6;
2008 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2009 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2010 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2011 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2012 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2013 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2014 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2015 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2016 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2017 INSERT INTO t4 (c1) VALUES(10);
2018 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2019 -- sorted_result
2020 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 != t5.c1;
2021 DROP TABLE t1,t2,t3,t4,t5,t6;
2022 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2023 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2024 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2025 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2026 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2027 CREATE TABLE t6 (c1 TINYINT 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,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
2035 DROP TABLE t1,t2,t3,t4,t5,t6;
2036 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2037 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2038 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2039 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2040 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2041 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2042 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2043 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2044 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2045 INSERT INTO t4 (c1) VALUES(10);
2046 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2047 -- sorted_result
2048 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
2049 DROP TABLE t1,t2,t3,t4,t5,t6;
2050 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2051 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2052 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2053 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2054 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2055 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2056 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2057 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2058 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2059 INSERT INTO t4 (c1) VALUES(10);
2060 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2061 -- sorted_result
2062 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
2063 DROP TABLE t1,t2,t3,t4,t5,t6;
2064 CREATE TABLE t1 (c1 INT NOT NULL);
2065 CREATE TABLE t2 (c1 INT NOT NULL);
2066 CREATE TABLE t3 (c1 INT NOT NULL);
2067 CREATE TABLE t4 (c1 INT NOT NULL);
2068 CREATE TABLE t5 (c1 INT NOT NULL);
2069 CREATE TABLE t6 (c1 INT NOT NULL);
2070 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2071 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2072 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2073 INSERT INTO t4 (c1) VALUES(10);
2074 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2075 -- sorted_result
2076 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
2077 DROP TABLE t1,t2,t3,t4,t5,t6;
2078 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2079 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2080 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2081 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2082 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2083 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2084 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2085 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2086 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2087 INSERT INTO t4 (c1) VALUES(10);
2088 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2089 -- sorted_result
2090 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
2091 DROP TABLE t1,t2,t3,t4,t5,t6;
2092 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2093 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2094 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2095 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2096 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2097 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2098 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2099 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2100 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2101 INSERT INTO t4 (c1) VALUES(10);
2102 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2103 -- sorted_result
2104 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 != t6.c1;
2105 DROP TABLE t1,t2,t3,t4,t5,t6;
2106 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2107 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2108 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2109 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2110 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2111 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2112 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2113 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2114 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2115 INSERT INTO t4 (c1) VALUES(10);
2116 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2117 -- sorted_result
2118 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
2119 DROP TABLE t1,t2,t3,t4,t5,t6;
2120 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2121 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2122 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2123 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2124 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2125 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2126 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2127 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2128 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2129 INSERT INTO t4 (c1) VALUES(10);
2130 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2131 -- sorted_result
2132 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
2133 DROP TABLE t1,t2,t3,t4,t5,t6;
2134 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2135 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2136 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2137 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2138 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2139 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2140 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2141 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2142 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2143 INSERT INTO t4 (c1) VALUES(10);
2144 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2145 -- sorted_result
2146 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
2147 DROP TABLE t1,t2,t3,t4,t5,t6;
2148 CREATE TABLE t1 (c1 INT NOT NULL);
2149 CREATE TABLE t2 (c1 INT NOT NULL);
2150 CREATE TABLE t3 (c1 INT NOT NULL);
2151 CREATE TABLE t4 (c1 INT NOT NULL);
2152 CREATE TABLE t5 (c1 INT NOT NULL);
2153 CREATE TABLE t6 (c1 INT 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,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
2161 DROP TABLE t1,t2,t3,t4,t5,t6;
2162 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2163 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2164 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2165 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2166 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2167 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2168 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2169 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2170 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2171 INSERT INTO t4 (c1) VALUES(10);
2172 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2173 -- sorted_result
2174 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
2175 DROP TABLE t1,t2,t3,t4,t5,t6;
2176 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2177 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2178 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2179 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2180 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2181 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2182 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2183 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2184 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2185 INSERT INTO t4 (c1) VALUES(10);
2186 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2187 -- sorted_result
2188 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <> t2.c1;
2189 DROP TABLE t1,t2,t3,t4,t5,t6;
2190 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2191 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2192 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2193 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2194 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2195 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2196 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2197 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2198 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2199 INSERT INTO t4 (c1) VALUES(10);
2200 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2201 -- sorted_result
2202 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
2203 DROP TABLE t1,t2,t3,t4,t5,t6;
2204 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2205 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2206 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2207 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2208 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2209 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2210 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2211 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2212 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2213 INSERT INTO t4 (c1) VALUES(10);
2214 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2215 -- sorted_result
2216 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
2217 DROP TABLE t1,t2,t3,t4,t5,t6;
2218 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2219 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2220 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2221 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2222 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2223 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2224 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2225 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2226 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2227 INSERT INTO t4 (c1) VALUES(10);
2228 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2229 -- sorted_result
2230 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
2231 DROP TABLE t1,t2,t3,t4,t5,t6;
2232 CREATE TABLE t1 (c1 INT NOT NULL);
2233 CREATE TABLE t2 (c1 INT NOT NULL);
2234 CREATE TABLE t3 (c1 INT NOT NULL);
2235 CREATE TABLE t4 (c1 INT NOT NULL);
2236 CREATE TABLE t5 (c1 INT NOT NULL);
2237 CREATE TABLE t6 (c1 INT NOT NULL);
2238 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2239 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2240 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2241 INSERT INTO t4 (c1) VALUES(10);
2242 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2243 -- sorted_result
2244 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
2245 DROP TABLE t1,t2,t3,t4,t5,t6;
2246 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2247 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2248 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2249 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2250 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2251 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2252 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2253 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2254 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2255 INSERT INTO t4 (c1) VALUES(10);
2256 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2257 -- sorted_result
2258 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
2259 DROP TABLE t1,t2,t3,t4,t5,t6;
2260 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2261 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2262 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2263 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2264 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2265 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2266 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2267 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2268 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2269 INSERT INTO t4 (c1) VALUES(10);
2270 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2271 -- sorted_result
2272 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <> t3.c1;
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,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
2287 DROP TABLE t1,t2,t3,t4,t5,t6;
2288 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2289 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2290 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2291 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2292 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2293 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2294 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2295 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2296 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2297 INSERT INTO t4 (c1) VALUES(10);
2298 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2299 -- sorted_result
2300 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
2301 DROP TABLE t1,t2,t3,t4,t5,t6;
2302 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2303 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2304 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2305 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2306 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2307 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2308 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2309 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2310 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2311 INSERT INTO t4 (c1) VALUES(10);
2312 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2313 -- sorted_result
2314 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
2315 DROP TABLE t1,t2,t3,t4,t5,t6;
2316 CREATE TABLE t1 (c1 INT NOT NULL);
2317 CREATE TABLE t2 (c1 INT NOT NULL);
2318 CREATE TABLE t3 (c1 INT NOT NULL);
2319 CREATE TABLE t4 (c1 INT NOT NULL);
2320 CREATE TABLE t5 (c1 INT NOT NULL);
2321 CREATE TABLE t6 (c1 INT NOT NULL);
2322 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2323 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2324 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2325 INSERT INTO t4 (c1) VALUES(10);
2326 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2327 -- sorted_result
2328 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
2329 DROP TABLE t1,t2,t3,t4,t5,t6;
2330 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2331 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2332 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2333 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2334 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2335 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2336 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2337 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2338 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2339 INSERT INTO t4 (c1) VALUES(10);
2340 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2341 -- sorted_result
2342 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
2343 DROP TABLE t1,t2,t3,t4,t5,t6;
2344 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2345 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2346 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2347 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2348 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2349 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2350 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2351 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2352 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2353 INSERT INTO t4 (c1) VALUES(10);
2354 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2355 -- sorted_result
2356 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <> t4.c1;
2357 DROP TABLE t1,t2,t3,t4,t5,t6;
2358 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2359 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2360 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2361 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2362 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2363 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2364 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2365 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2366 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2367 INSERT INTO t4 (c1) VALUES(10);
2368 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2369 -- sorted_result
2370 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
2371 DROP TABLE t1,t2,t3,t4,t5,t6;
2372 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2373 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2374 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2375 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2376 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2377 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2378 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2379 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2380 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2381 INSERT INTO t4 (c1) VALUES(10);
2382 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2383 -- sorted_result
2384 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
2385 DROP TABLE t1,t2,t3,t4,t5,t6;
2386 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2387 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2388 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2389 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2390 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2391 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2392 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2393 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2394 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2395 INSERT INTO t4 (c1) VALUES(10);
2396 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2397 -- sorted_result
2398 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
2399 DROP TABLE t1,t2,t3,t4,t5,t6;
2400 CREATE TABLE t1 (c1 INT NOT NULL);
2401 CREATE TABLE t2 (c1 INT NOT NULL);
2402 CREATE TABLE t3 (c1 INT NOT NULL);
2403 CREATE TABLE t4 (c1 INT NOT NULL);
2404 CREATE TABLE t5 (c1 INT NOT NULL);
2405 CREATE TABLE t6 (c1 INT 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,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
2413 DROP TABLE t1,t2,t3,t4,t5,t6;
2414 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2415 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2416 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2417 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2418 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2419 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2420 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2421 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2422 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2423 INSERT INTO t4 (c1) VALUES(10);
2424 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2425 -- sorted_result
2426 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
2427 DROP TABLE t1,t2,t3,t4,t5,t6;
2428 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2429 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2430 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2431 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2432 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2433 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2434 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2435 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2436 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2437 INSERT INTO t4 (c1) VALUES(10);
2438 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2439 -- sorted_result
2440 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <> t5.c1;
2441 DROP TABLE t1,t2,t3,t4,t5,t6;
2442 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2443 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2444 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2445 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2446 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2447 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2448 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2449 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2450 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2451 INSERT INTO t4 (c1) VALUES(10);
2452 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2453 -- sorted_result
2454 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
2455 DROP TABLE t1,t2,t3,t4,t5,t6;
2456 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2457 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2458 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2459 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2460 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2461 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2462 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2463 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2464 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2465 INSERT INTO t4 (c1) VALUES(10);
2466 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2467 -- sorted_result
2468 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
2469 DROP TABLE t1,t2,t3,t4,t5,t6;
2470 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2471 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2472 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2473 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2474 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2475 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2476 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2477 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2478 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2479 INSERT INTO t4 (c1) VALUES(10);
2480 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2481 -- sorted_result
2482 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
2483 DROP TABLE t1,t2,t3,t4,t5,t6;
2484 CREATE TABLE t1 (c1 INT NOT NULL);
2485 CREATE TABLE t2 (c1 INT NOT NULL);
2486 CREATE TABLE t3 (c1 INT NOT NULL);
2487 CREATE TABLE t4 (c1 INT NOT NULL);
2488 CREATE TABLE t5 (c1 INT NOT NULL);
2489 CREATE TABLE t6 (c1 INT NOT NULL);
2490 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2491 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2492 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2493 INSERT INTO t4 (c1) VALUES(10);
2494 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2495 -- sorted_result
2496 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
2497 DROP TABLE t1,t2,t3,t4,t5,t6;
2498 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2499 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2500 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2501 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2502 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2503 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2504 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2505 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2506 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2507 INSERT INTO t4 (c1) VALUES(10);
2508 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2509 -- sorted_result
2510 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
2511 DROP TABLE t1,t2,t3,t4,t5,t6;
2512 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2513 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2514 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2515 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2516 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2517 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2518 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2519 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2520 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2521 INSERT INTO t4 (c1) VALUES(10);
2522 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2523 -- sorted_result
2524 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <> t6.c1;
2525 DROP TABLE t1,t2,t3,t4,t5,t6;
2526 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2527 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2528 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2529 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2530 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2531 CREATE TABLE t6 (c1 TINYINT 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,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
2539 DROP TABLE t1,t2,t3,t4,t5,t6;
2540 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2541 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2542 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2543 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2544 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2545 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2546 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2547 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2548 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2549 INSERT INTO t4 (c1) VALUES(10);
2550 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2551 -- sorted_result
2552 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
2553 DROP TABLE t1,t2,t3,t4,t5,t6;
2554 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2555 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2556 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2557 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2558 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2559 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2560 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2561 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2562 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2563 INSERT INTO t4 (c1) VALUES(10);
2564 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2565 -- sorted_result
2566 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
2567 DROP TABLE t1,t2,t3,t4,t5,t6;
2568 CREATE TABLE t1 (c1 INT NOT NULL);
2569 CREATE TABLE t2 (c1 INT NOT NULL);
2570 CREATE TABLE t3 (c1 INT NOT NULL);
2571 CREATE TABLE t4 (c1 INT NOT NULL);
2572 CREATE TABLE t5 (c1 INT NOT NULL);
2573 CREATE TABLE t6 (c1 INT NOT NULL);
2574 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2575 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2576 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2577 INSERT INTO t4 (c1) VALUES(10);
2578 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2579 -- sorted_result
2580 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
2581 DROP TABLE t1,t2,t3,t4,t5,t6;
2582 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2583 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2584 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2585 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2586 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2587 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2588 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2589 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2590 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2591 INSERT INTO t4 (c1) VALUES(10);
2592 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2593 -- sorted_result
2594 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
2595 DROP TABLE t1,t2,t3,t4,t5,t6;
2596 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2597 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2598 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2599 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2600 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2601 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2602 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2603 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2604 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2605 INSERT INTO t4 (c1) VALUES(10);
2606 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2607 -- sorted_result
2608 SELECT t1.c1,t2.c1 FROM t1,t2 WHERE t1.c1 <=> t2.c1;
2609 DROP TABLE t1,t2,t3,t4,t5,t6;
2610 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2611 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2612 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2613 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2614 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2615 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2616 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2617 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2618 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2619 INSERT INTO t4 (c1) VALUES(10);
2620 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2621 -- sorted_result
2622 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
2623 DROP TABLE t1,t2,t3,t4,t5,t6;
2624 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2625 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2626 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2627 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2628 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2629 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2630 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2631 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2632 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2633 INSERT INTO t4 (c1) VALUES(10);
2634 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2635 -- sorted_result
2636 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
2637 DROP TABLE t1,t2,t3,t4,t5,t6;
2638 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2639 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2640 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2641 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2642 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2643 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2644 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2645 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2646 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2647 INSERT INTO t4 (c1) VALUES(10);
2648 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2649 -- sorted_result
2650 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
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,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
2665 DROP TABLE t1,t2,t3,t4,t5,t6;
2666 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2667 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2668 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2669 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2670 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2671 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2672 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2673 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2674 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2675 INSERT INTO t4 (c1) VALUES(10);
2676 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2677 -- sorted_result
2678 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
2679 DROP TABLE t1,t2,t3,t4,t5,t6;
2680 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2681 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2682 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2683 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2684 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2685 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2686 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2687 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2688 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2689 INSERT INTO t4 (c1) VALUES(10);
2690 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2691 -- sorted_result
2692 SELECT t1.c1,t3.c1 FROM t1,t3 WHERE t1.c1 <=> t3.c1;
2693 DROP TABLE t1,t2,t3,t4,t5,t6;
2694 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2695 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2696 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2697 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2698 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2699 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2700 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2701 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2702 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2703 INSERT INTO t4 (c1) VALUES(10);
2704 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2705 -- sorted_result
2706 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
2707 DROP TABLE t1,t2,t3,t4,t5,t6;
2708 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2709 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2710 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2711 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2712 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2713 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2714 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2715 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2716 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2717 INSERT INTO t4 (c1) VALUES(10);
2718 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2719 -- sorted_result
2720 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
2721 DROP TABLE t1,t2,t3,t4,t5,t6;
2722 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2723 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2724 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2725 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2726 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2727 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2728 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2729 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2730 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2731 INSERT INTO t4 (c1) VALUES(10);
2732 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2733 -- sorted_result
2734 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
2735 DROP TABLE t1,t2,t3,t4,t5,t6;
2736 CREATE TABLE t1 (c1 INT NOT NULL);
2737 CREATE TABLE t2 (c1 INT NOT NULL);
2738 CREATE TABLE t3 (c1 INT NOT NULL);
2739 CREATE TABLE t4 (c1 INT NOT NULL);
2740 CREATE TABLE t5 (c1 INT NOT NULL);
2741 CREATE TABLE t6 (c1 INT NOT NULL);
2742 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2743 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2744 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2745 INSERT INTO t4 (c1) VALUES(10);
2746 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2747 -- sorted_result
2748 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
2749 DROP TABLE t1,t2,t3,t4,t5,t6;
2750 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2751 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2752 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2753 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2754 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2755 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2756 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2757 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2758 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2759 INSERT INTO t4 (c1) VALUES(10);
2760 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2761 -- sorted_result
2762 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
2763 DROP TABLE t1,t2,t3,t4,t5,t6;
2764 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2765 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2766 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2767 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2768 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2769 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2770 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2772 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2773 INSERT INTO t4 (c1) VALUES(10);
2774 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2775 -- sorted_result
2776 SELECT t1.c1,t4.c1 FROM t1,t4 WHERE t1.c1 <=> t4.c1;
2777 DROP TABLE t1,t2,t3,t4,t5,t6;
2778 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2779 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2780 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2781 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2782 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2783 CREATE TABLE t6 (c1 TINYINT 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,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
2791 DROP TABLE t1,t2,t3,t4,t5,t6;
2792 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2793 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2794 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2795 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2796 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2797 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2798 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2799 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2800 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2801 INSERT INTO t4 (c1) VALUES(10);
2802 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2803 -- sorted_result
2804 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
2805 DROP TABLE t1,t2,t3,t4,t5,t6;
2806 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2807 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2808 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2809 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2810 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2811 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2812 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2813 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2814 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2815 INSERT INTO t4 (c1) VALUES(10);
2816 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2817 -- sorted_result
2818 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
2819 DROP TABLE t1,t2,t3,t4,t5,t6;
2820 CREATE TABLE t1 (c1 INT NOT NULL);
2821 CREATE TABLE t2 (c1 INT NOT NULL);
2822 CREATE TABLE t3 (c1 INT NOT NULL);
2823 CREATE TABLE t4 (c1 INT NOT NULL);
2824 CREATE TABLE t5 (c1 INT NOT NULL);
2825 CREATE TABLE t6 (c1 INT NOT NULL);
2826 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2827 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2828 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2829 INSERT INTO t4 (c1) VALUES(10);
2830 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2831 -- sorted_result
2832 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
2833 DROP TABLE t1,t2,t3,t4,t5,t6;
2834 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2835 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2836 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2837 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2838 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2839 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2840 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2841 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2842 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2843 INSERT INTO t4 (c1) VALUES(10);
2844 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2845 -- sorted_result
2846 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
2847 DROP TABLE t1,t2,t3,t4,t5,t6;
2848 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2849 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2850 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2851 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2852 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2853 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2854 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2855 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2856 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2857 INSERT INTO t4 (c1) VALUES(10);
2858 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2859 -- sorted_result
2860 SELECT t1.c1,t5.c1 FROM t1,t5 WHERE t1.c1 <=> t5.c1;
2861 DROP TABLE t1,t2,t3,t4,t5,t6;
2862 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2863 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2864 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2865 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2866 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2867 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2868 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2869 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2870 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2871 INSERT INTO t4 (c1) VALUES(10);
2872 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2873 -- sorted_result
2874 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
2875 DROP TABLE t1,t2,t3,t4,t5,t6;
2876 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2877 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2878 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2879 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2880 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2881 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2882 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2883 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2884 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2885 INSERT INTO t4 (c1) VALUES(10);
2886 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2887 -- sorted_result
2888 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
2889 DROP TABLE t1,t2,t3,t4,t5,t6;
2890 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2891 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2892 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2893 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2894 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2895 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2896 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2897 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2898 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2899 INSERT INTO t4 (c1) VALUES(10);
2900 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2901 -- sorted_result
2902 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
2903 DROP TABLE t1,t2,t3,t4,t5,t6;
2904 CREATE TABLE t1 (c1 INT NOT NULL);
2905 CREATE TABLE t2 (c1 INT NOT NULL);
2906 CREATE TABLE t3 (c1 INT NOT NULL);
2907 CREATE TABLE t4 (c1 INT NOT NULL);
2908 CREATE TABLE t5 (c1 INT NOT NULL);
2909 CREATE TABLE t6 (c1 INT 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,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
2917 DROP TABLE t1,t2,t3,t4,t5,t6;
2918 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2919 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2920 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2921 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2922 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2923 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2924 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2925 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2926 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2927 INSERT INTO t4 (c1) VALUES(10);
2928 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2929 -- sorted_result
2930 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
2931 DROP TABLE t1,t2,t3,t4,t5,t6;
2932 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2933 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2934 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2935 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2936 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2937 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2938 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2939 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2940 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2941 INSERT INTO t4 (c1) VALUES(10);
2942 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2943 -- sorted_result
2944 SELECT t1.c1,t6.c1 FROM t1,t6 WHERE t1.c1 <=> t6.c1;
2945 DROP TABLE t1,t2,t3,t4,t5,t6;
2946