Debian Codegraph @

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