Debian Codegraph @

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

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