Debian Codegraph @

mysql-test/suite/engines/funcs/r/se_join_straight.result

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