Debian Codegraph @

mysql-test/suite/engines/funcs/r/se_join_cross.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 CROSS JOIN t2 USING (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 CROSS JOIN t2 ON t1.c1 = t2.c1;
26 c1 c1
27 0 0
28 1 1
29 2 2
30 3 3
31 4 4
32 5 5
33 6 6
34 7 7
35 8 8
36 9 9
37 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
38 c1 c1
39 0 0
40 1 1
41 2 2
42 3 3
43 4 4
44 DROP TABLE t1,t2,t3,t4,t5,t6;
45 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
46 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
47 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
48 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
49 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
50 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
51 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
52 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
53 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
54 INSERT INTO t4 (c1) VALUES(10);
55 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
56 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
57 c1 c1
58 0 0
59 1 1
60 2 2
61 3 3
62 4 4
63 5 5
64 6 6
65 7 7
66 8 8
67 9 9
68 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
69 c1 c1
70 0 0
71 1 1
72 2 2
73 3 3
74 4 4
75 5 5
76 6 6
77 7 7
78 8 8
79 9 9
80 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
81 c1 c1
82 0 0
83 1 1
84 2 2
85 3 3
86 4 4
87 DROP TABLE t1,t2,t3,t4,t5,t6;
88 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
89 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
90 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
91 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
92 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
93 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
94 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
95 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
96 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
97 INSERT INTO t4 (c1) VALUES(10);
98 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
99 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
100 c1 c1
101 0 0
102 1 1
103 2 2
104 3 3
105 4 4
106 5 5
107 6 6
108 7 7
109 8 8
110 9 9
111 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
112 c1 c1
113 0 0
114 1 1
115 2 2
116 3 3
117 4 4
118 5 5
119 6 6
120 7 7
121 8 8
122 9 9
123 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
124 c1 c1
125 0 0
126 1 1
127 2 2
128 3 3
129 4 4
130 DROP TABLE t1,t2,t3,t4,t5,t6;
131 CREATE TABLE t1 (c1 INT NOT NULL);
132 CREATE TABLE t2 (c1 INT NOT NULL);
133 CREATE TABLE t3 (c1 INT NOT NULL);
134 CREATE TABLE t4 (c1 INT NOT NULL);
135 CREATE TABLE t5 (c1 INT NOT NULL);
136 CREATE TABLE t6 (c1 INT NOT NULL);
137 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
138 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
139 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
140 INSERT INTO t4 (c1) VALUES(10);
141 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
142 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
143 c1 c1
144 0 0
145 1 1
146 2 2
147 3 3
148 4 4
149 5 5
150 6 6
151 7 7
152 8 8
153 9 9
154 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
155 c1 c1
156 0 0
157 1 1
158 2 2
159 3 3
160 4 4
161 5 5
162 6 6
163 7 7
164 8 8
165 9 9
166 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
167 c1 c1
168 0 0
169 1 1
170 2 2
171 3 3
172 4 4
173 DROP TABLE t1,t2,t3,t4,t5,t6;
174 CREATE TABLE t1 (c1 INTEGER NOT NULL);
175 CREATE TABLE t2 (c1 INTEGER NOT NULL);
176 CREATE TABLE t3 (c1 INTEGER NOT NULL);
177 CREATE TABLE t4 (c1 INTEGER NOT NULL);
178 CREATE TABLE t5 (c1 INTEGER NOT NULL);
179 CREATE TABLE t6 (c1 INTEGER NOT NULL);
180 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
181 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
182 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
183 INSERT INTO t4 (c1) VALUES(10);
184 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
185 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
186 c1 c1
187 0 0
188 1 1
189 2 2
190 3 3
191 4 4
192 5 5
193 6 6
194 7 7
195 8 8
196 9 9
197 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
198 c1 c1
199 0 0
200 1 1
201 2 2
202 3 3
203 4 4
204 5 5
205 6 6
206 7 7
207 8 8
208 9 9
209 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
210 c1 c1
211 0 0
212 1 1
213 2 2
214 3 3
215 4 4
216 DROP TABLE t1,t2,t3,t4,t5,t6;
217 CREATE TABLE t1 (c1 BIGINT NOT NULL);
218 CREATE TABLE t2 (c1 BIGINT NOT NULL);
219 CREATE TABLE t3 (c1 BIGINT NOT NULL);
220 CREATE TABLE t4 (c1 BIGINT NOT NULL);
221 CREATE TABLE t5 (c1 BIGINT NOT NULL);
222 CREATE TABLE t6 (c1 BIGINT NOT NULL);
223 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
224 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
225 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
226 INSERT INTO t4 (c1) VALUES(10);
227 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
228 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
229 c1 c1
230 0 0
231 1 1
232 2 2
233 3 3
234 4 4
235 5 5
236 6 6
237 7 7
238 8 8
239 9 9
240 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
241 c1 c1
242 0 0
243 1 1
244 2 2
245 3 3
246 4 4
247 5 5
248 6 6
249 7 7
250 8 8
251 9 9
252 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
253 c1 c1
254 0 0
255 1 1
256 2 2
257 3 3
258 4 4
259 DROP TABLE t1,t2,t3,t4,t5,t6;
260 CREATE TABLE t1 (c1 TINYINT NOT NULL);
261 CREATE TABLE t2 (c1 TINYINT NOT NULL);
262 CREATE TABLE t3 (c1 TINYINT NOT NULL);
263 CREATE TABLE t4 (c1 TINYINT NOT NULL);
264 CREATE TABLE t5 (c1 TINYINT NOT NULL);
265 CREATE TABLE t6 (c1 TINYINT NOT NULL);
266 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
267 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
268 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
269 INSERT INTO t4 (c1) VALUES(10);
270 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
271 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
272 c1 c1
273 1 1
274 3 3
275 5 5
276 7 7
277 9 9
278 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
279 c1 c1
280 1 1
281 3 3
282 5 5
283 7 7
284 9 9
285 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
286 c1 c1
287 1 1
288 3 3
289 DROP TABLE t1,t2,t3,t4,t5,t6;
290 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
291 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
292 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
293 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
294 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
295 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
296 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
297 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
298 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
299 INSERT INTO t4 (c1) VALUES(10);
300 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
301 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
302 c1 c1
303 1 1
304 3 3
305 5 5
306 7 7
307 9 9
308 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
309 c1 c1
310 1 1
311 3 3
312 5 5
313 7 7
314 9 9
315 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
316 c1 c1
317 1 1
318 3 3
319 DROP TABLE t1,t2,t3,t4,t5,t6;
320 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
321 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
322 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
323 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
324 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
325 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
326 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
327 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
328 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
329 INSERT INTO t4 (c1) VALUES(10);
330 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
331 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
332 c1 c1
333 1 1
334 3 3
335 5 5
336 7 7
337 9 9
338 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
339 c1 c1
340 1 1
341 3 3
342 5 5
343 7 7
344 9 9
345 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
346 c1 c1
347 1 1
348 3 3
349 DROP TABLE t1,t2,t3,t4,t5,t6;
350 CREATE TABLE t1 (c1 INT NOT NULL);
351 CREATE TABLE t2 (c1 INT NOT NULL);
352 CREATE TABLE t3 (c1 INT NOT NULL);
353 CREATE TABLE t4 (c1 INT NOT NULL);
354 CREATE TABLE t5 (c1 INT NOT NULL);
355 CREATE TABLE t6 (c1 INT NOT NULL);
356 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
357 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
358 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
359 INSERT INTO t4 (c1) VALUES(10);
360 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
361 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
362 c1 c1
363 1 1
364 3 3
365 5 5
366 7 7
367 9 9
368 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
369 c1 c1
370 1 1
371 3 3
372 5 5
373 7 7
374 9 9
375 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
376 c1 c1
377 1 1
378 3 3
379 DROP TABLE t1,t2,t3,t4,t5,t6;
380 CREATE TABLE t1 (c1 INTEGER NOT NULL);
381 CREATE TABLE t2 (c1 INTEGER NOT NULL);
382 CREATE TABLE t3 (c1 INTEGER NOT NULL);
383 CREATE TABLE t4 (c1 INTEGER NOT NULL);
384 CREATE TABLE t5 (c1 INTEGER NOT NULL);
385 CREATE TABLE t6 (c1 INTEGER NOT NULL);
386 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
387 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
388 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
389 INSERT INTO t4 (c1) VALUES(10);
390 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
391 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
392 c1 c1
393 1 1
394 3 3
395 5 5
396 7 7
397 9 9
398 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
399 c1 c1
400 1 1
401 3 3
402 5 5
403 7 7
404 9 9
405 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
406 c1 c1
407 1 1
408 3 3
409 DROP TABLE t1,t2,t3,t4,t5,t6;
410 CREATE TABLE t1 (c1 BIGINT NOT NULL);
411 CREATE TABLE t2 (c1 BIGINT NOT NULL);
412 CREATE TABLE t3 (c1 BIGINT NOT NULL);
413 CREATE TABLE t4 (c1 BIGINT NOT NULL);
414 CREATE TABLE t5 (c1 BIGINT NOT NULL);
415 CREATE TABLE t6 (c1 BIGINT NOT NULL);
416 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
417 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
418 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
419 INSERT INTO t4 (c1) VALUES(10);
420 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
421 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
422 c1 c1
423 1 1
424 3 3
425 5 5
426 7 7
427 9 9
428 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
429 c1 c1
430 1 1
431 3 3
432 5 5
433 7 7
434 9 9
435 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
436 c1 c1
437 1 1
438 3 3
439 DROP TABLE t1,t2,t3,t4,t5,t6;
440 CREATE TABLE t1 (c1 TINYINT NOT NULL);
441 CREATE TABLE t2 (c1 TINYINT NOT NULL);
442 CREATE TABLE t3 (c1 TINYINT NOT NULL);
443 CREATE TABLE t4 (c1 TINYINT NOT NULL);
444 CREATE TABLE t5 (c1 TINYINT NOT NULL);
445 CREATE TABLE t6 (c1 TINYINT NOT NULL);
446 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
447 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
448 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
449 INSERT INTO t4 (c1) VALUES(10);
450 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
451 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
452 c1 c1
453 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
454 c1 c1
455 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
456 c1 c1
457 DROP TABLE t1,t2,t3,t4,t5,t6;
458 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
459 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
460 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
461 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
462 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
463 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
464 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
465 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
466 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
467 INSERT INTO t4 (c1) VALUES(10);
468 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
469 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
470 c1 c1
471 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
472 c1 c1
473 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
474 c1 c1
475 DROP TABLE t1,t2,t3,t4,t5,t6;
476 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
477 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
478 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
479 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
480 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
481 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
482 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
483 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
484 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
485 INSERT INTO t4 (c1) VALUES(10);
486 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
487 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
488 c1 c1
489 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
490 c1 c1
491 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
492 c1 c1
493 DROP TABLE t1,t2,t3,t4,t5,t6;
494 CREATE TABLE t1 (c1 INT NOT NULL);
495 CREATE TABLE t2 (c1 INT NOT NULL);
496 CREATE TABLE t3 (c1 INT NOT NULL);
497 CREATE TABLE t4 (c1 INT NOT NULL);
498 CREATE TABLE t5 (c1 INT NOT NULL);
499 CREATE TABLE t6 (c1 INT NOT NULL);
500 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
501 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
502 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
503 INSERT INTO t4 (c1) VALUES(10);
504 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
505 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
506 c1 c1
507 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
508 c1 c1
509 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
510 c1 c1
511 DROP TABLE t1,t2,t3,t4,t5,t6;
512 CREATE TABLE t1 (c1 INTEGER NOT NULL);
513 CREATE TABLE t2 (c1 INTEGER NOT NULL);
514 CREATE TABLE t3 (c1 INTEGER NOT NULL);
515 CREATE TABLE t4 (c1 INTEGER NOT NULL);
516 CREATE TABLE t5 (c1 INTEGER NOT NULL);
517 CREATE TABLE t6 (c1 INTEGER NOT NULL);
518 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
519 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
520 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
521 INSERT INTO t4 (c1) VALUES(10);
522 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
523 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
524 c1 c1
525 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
526 c1 c1
527 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
528 c1 c1
529 DROP TABLE t1,t2,t3,t4,t5,t6;
530 CREATE TABLE t1 (c1 BIGINT NOT NULL);
531 CREATE TABLE t2 (c1 BIGINT NOT NULL);
532 CREATE TABLE t3 (c1 BIGINT NOT NULL);
533 CREATE TABLE t4 (c1 BIGINT NOT NULL);
534 CREATE TABLE t5 (c1 BIGINT NOT NULL);
535 CREATE TABLE t6 (c1 BIGINT NOT NULL);
536 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
538 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
539 INSERT INTO t4 (c1) VALUES(10);
540 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
541 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
542 c1 c1
543 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
544 c1 c1
545 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
546 c1 c1
547 DROP TABLE t1,t2,t3,t4,t5,t6;
548 CREATE TABLE t1 (c1 TINYINT NOT NULL);
549 CREATE TABLE t2 (c1 TINYINT NOT NULL);
550 CREATE TABLE t3 (c1 TINYINT NOT NULL);
551 CREATE TABLE t4 (c1 TINYINT NOT NULL);
552 CREATE TABLE t5 (c1 TINYINT NOT NULL);
553 CREATE TABLE t6 (c1 TINYINT NOT NULL);
554 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
555 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
556 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
557 INSERT INTO t4 (c1) VALUES(10);
558 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
559 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
560 c1 c1
561 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
562 c1 c1
563 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
564 c1 c1
565 DROP TABLE t1,t2,t3,t4,t5,t6;
566 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
567 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
568 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
569 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
570 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
571 CREATE TABLE t6 (c1 SMALLINT 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
578 c1 c1
579 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
580 c1 c1
581 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
582 c1 c1
583 DROP TABLE t1,t2,t3,t4,t5,t6;
584 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
585 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
586 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
587 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
588 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
589 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
590 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
591 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
592 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
593 INSERT INTO t4 (c1) VALUES(10);
594 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
595 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
596 c1 c1
597 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
598 c1 c1
599 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
600 c1 c1
601 DROP TABLE t1,t2,t3,t4,t5,t6;
602 CREATE TABLE t1 (c1 INT NOT NULL);
603 CREATE TABLE t2 (c1 INT NOT NULL);
604 CREATE TABLE t3 (c1 INT NOT NULL);
605 CREATE TABLE t4 (c1 INT NOT NULL);
606 CREATE TABLE t5 (c1 INT NOT NULL);
607 CREATE TABLE t6 (c1 INT NOT NULL);
608 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
609 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
610 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
611 INSERT INTO t4 (c1) VALUES(10);
612 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
613 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
614 c1 c1
615 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
616 c1 c1
617 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
618 c1 c1
619 DROP TABLE t1,t2,t3,t4,t5,t6;
620 CREATE TABLE t1 (c1 INTEGER NOT NULL);
621 CREATE TABLE t2 (c1 INTEGER NOT NULL);
622 CREATE TABLE t3 (c1 INTEGER NOT NULL);
623 CREATE TABLE t4 (c1 INTEGER NOT NULL);
624 CREATE TABLE t5 (c1 INTEGER NOT NULL);
625 CREATE TABLE t6 (c1 INTEGER NOT NULL);
626 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
627 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
628 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
629 INSERT INTO t4 (c1) VALUES(10);
630 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
631 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
632 c1 c1
633 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
634 c1 c1
635 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
636 c1 c1
637 DROP TABLE t1,t2,t3,t4,t5,t6;
638 CREATE TABLE t1 (c1 BIGINT NOT NULL);
639 CREATE TABLE t2 (c1 BIGINT NOT NULL);
640 CREATE TABLE t3 (c1 BIGINT NOT NULL);
641 CREATE TABLE t4 (c1 BIGINT NOT NULL);
642 CREATE TABLE t5 (c1 BIGINT NOT NULL);
643 CREATE TABLE t6 (c1 BIGINT NOT NULL);
644 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
645 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
646 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
647 INSERT INTO t4 (c1) VALUES(10);
648 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
649 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
650 c1 c1
651 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
652 c1 c1
653 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
654 c1 c1
655 DROP TABLE t1,t2,t3,t4,t5,t6;
656 CREATE TABLE t1 (c1 TINYINT NOT NULL);
657 CREATE TABLE t2 (c1 TINYINT NOT NULL);
658 CREATE TABLE t3 (c1 TINYINT NOT NULL);
659 CREATE TABLE t4 (c1 TINYINT NOT NULL);
660 CREATE TABLE t5 (c1 TINYINT NOT NULL);
661 CREATE TABLE t6 (c1 TINYINT NOT NULL);
662 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
663 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
664 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
665 INSERT INTO t4 (c1) VALUES(10);
666 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
667 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
668 c1 c1
669 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
670 c1 c1
671 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
672 c1 c1
673 DROP TABLE t1,t2,t3,t4,t5,t6;
674 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
675 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
676 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
677 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
678 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
679 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
680 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
681 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
682 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
683 INSERT INTO t4 (c1) VALUES(10);
684 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
685 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
686 c1 c1
687 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
688 c1 c1
689 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
690 c1 c1
691 DROP TABLE t1,t2,t3,t4,t5,t6;
692 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
693 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
694 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
695 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
696 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
697 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
698 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
699 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
700 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
701 INSERT INTO t4 (c1) VALUES(10);
702 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
703 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
704 c1 c1
705 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
706 c1 c1
707 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
708 c1 c1
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,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
722 c1 c1
723 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
724 c1 c1
725 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
726 c1 c1
727 DROP TABLE t1,t2,t3,t4,t5,t6;
728 CREATE TABLE t1 (c1 INTEGER NOT NULL);
729 CREATE TABLE t2 (c1 INTEGER NOT NULL);
730 CREATE TABLE t3 (c1 INTEGER NOT NULL);
731 CREATE TABLE t4 (c1 INTEGER NOT NULL);
732 CREATE TABLE t5 (c1 INTEGER NOT NULL);
733 CREATE TABLE t6 (c1 INTEGER NOT NULL);
734 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
735 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
736 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
737 INSERT INTO t4 (c1) VALUES(10);
738 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
739 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
740 c1 c1
741 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
742 c1 c1
743 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
744 c1 c1
745 DROP TABLE t1,t2,t3,t4,t5,t6;
746 CREATE TABLE t1 (c1 BIGINT NOT NULL);
747 CREATE TABLE t2 (c1 BIGINT NOT NULL);
748 CREATE TABLE t3 (c1 BIGINT NOT NULL);
749 CREATE TABLE t4 (c1 BIGINT NOT NULL);
750 CREATE TABLE t5 (c1 BIGINT NOT NULL);
751 CREATE TABLE t6 (c1 BIGINT NOT NULL);
752 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
753 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
754 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
755 INSERT INTO t4 (c1) VALUES(10);
756 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
757 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
758 c1 c1
759 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
760 c1 c1
761 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
762 c1 c1
763 DROP TABLE t1,t2,t3,t4,t5,t6;
764 CREATE TABLE t1 (c1 TINYINT NOT NULL);
765 CREATE TABLE t2 (c1 TINYINT NOT NULL);
766 CREATE TABLE t3 (c1 TINYINT NOT NULL);
767 CREATE TABLE t4 (c1 TINYINT NOT NULL);
768 CREATE TABLE t5 (c1 TINYINT NOT NULL);
769 CREATE TABLE t6 (c1 TINYINT NOT NULL);
770 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
772 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
773 INSERT INTO t4 (c1) VALUES(10);
774 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
775 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
776 c1 c1
777 0 0
778 1 1
779 2 2
780 3 3
781 4 4
782 5 5
783 6 6
784 7 7
785 8 8
786 9 9
787 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
788 c1 c1
789 0 0
790 1 1
791 2 2
792 3 3
793 4 4
794 5 5
795 6 6
796 7 7
797 8 8
798 9 9
799 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
800 c1 c1
801 0 0
802 1 1
803 2 2
804 3 3
805 4 4
806 5 5
807 DROP TABLE t1,t2,t3,t4,t5,t6;
808 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
809 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
810 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
811 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
812 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
813 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
814 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
815 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
816 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
817 INSERT INTO t4 (c1) VALUES(10);
818 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
819 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
820 c1 c1
821 0 0
822 1 1
823 2 2
824 3 3
825 4 4
826 5 5
827 6 6
828 7 7
829 8 8
830 9 9
831 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
832 c1 c1
833 0 0
834 1 1
835 2 2
836 3 3
837 4 4
838 5 5
839 6 6
840 7 7
841 8 8
842 9 9
843 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
844 c1 c1
845 0 0
846 1 1
847 2 2
848 3 3
849 4 4
850 5 5
851 DROP TABLE t1,t2,t3,t4,t5,t6;
852 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
853 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
854 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
855 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
856 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
857 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
858 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
859 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
860 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
861 INSERT INTO t4 (c1) VALUES(10);
862 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
863 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
864 c1 c1
865 0 0
866 1 1
867 2 2
868 3 3
869 4 4
870 5 5
871 6 6
872 7 7
873 8 8
874 9 9
875 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
876 c1 c1
877 0 0
878 1 1
879 2 2
880 3 3
881 4 4
882 5 5
883 6 6
884 7 7
885 8 8
886 9 9
887 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
888 c1 c1
889 0 0
890 1 1
891 2 2
892 3 3
893 4 4
894 5 5
895 DROP TABLE t1,t2,t3,t4,t5,t6;
896 CREATE TABLE t1 (c1 INT NOT NULL);
897 CREATE TABLE t2 (c1 INT NOT NULL);
898 CREATE TABLE t3 (c1 INT NOT NULL);
899 CREATE TABLE t4 (c1 INT NOT NULL);
900 CREATE TABLE t5 (c1 INT NOT NULL);
901 CREATE TABLE t6 (c1 INT NOT NULL);
902 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
903 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
904 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
905 INSERT INTO t4 (c1) VALUES(10);
906 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
907 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
908 c1 c1
909 0 0
910 1 1
911 2 2
912 3 3
913 4 4
914 5 5
915 6 6
916 7 7
917 8 8
918 9 9
919 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
920 c1 c1
921 0 0
922 1 1
923 2 2
924 3 3
925 4 4
926 5 5
927 6 6
928 7 7
929 8 8
930 9 9
931 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
932 c1 c1
933 0 0
934 1 1
935 2 2
936 3 3
937 4 4
938 5 5
939 DROP TABLE t1,t2,t3,t4,t5,t6;
940 CREATE TABLE t1 (c1 INTEGER NOT NULL);
941 CREATE TABLE t2 (c1 INTEGER NOT NULL);
942 CREATE TABLE t3 (c1 INTEGER NOT NULL);
943 CREATE TABLE t4 (c1 INTEGER NOT NULL);
944 CREATE TABLE t5 (c1 INTEGER NOT NULL);
945 CREATE TABLE t6 (c1 INTEGER NOT NULL);
946 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
947 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
948 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
949 INSERT INTO t4 (c1) VALUES(10);
950 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
951 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
952 c1 c1
953 0 0
954 1 1
955 2 2
956 3 3
957 4 4
958 5 5
959 6 6
960 7 7
961 8 8
962 9 9
963 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
964 c1 c1
965 0 0
966 1 1
967 2 2
968 3 3
969 4 4
970 5 5
971 6 6
972 7 7
973 8 8
974 9 9
975 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
976 c1 c1
977 0 0
978 1 1
979 2 2
980 3 3
981 4 4
982 5 5
983 DROP TABLE t1,t2,t3,t4,t5,t6;
984 CREATE TABLE t1 (c1 BIGINT NOT NULL);
985 CREATE TABLE t2 (c1 BIGINT NOT NULL);
986 CREATE TABLE t3 (c1 BIGINT NOT NULL);
987 CREATE TABLE t4 (c1 BIGINT NOT NULL);
988 CREATE TABLE t5 (c1 BIGINT NOT NULL);
989 CREATE TABLE t6 (c1 BIGINT NOT NULL);
990 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
991 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
992 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
993 INSERT INTO t4 (c1) VALUES(10);
994 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
995 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
996 c1 c1
997 0 0
998 1 1
999 2 2
1000 3 3
1001 4 4
1002 5 5
1003 6 6
1004 7 7
1005 8 8
1006 9 9
1007 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1008 c1 c1
1009 0 0
1010 1 1
1011 2 2
1012 3 3
1013 4 4
1014 5 5
1015 6 6
1016 7 7
1017 8 8
1018 9 9
1019 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
1020 c1 c1
1021 0 0
1022 1 1
1023 2 2
1024 3 3
1025 4 4
1026 5 5
1027 DROP TABLE t1,t2,t3,t4,t5,t6;
1028 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1029 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1030 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1031 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1032 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1033 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1034 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1035 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1036 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1037 INSERT INTO t4 (c1) VALUES(10);
1038 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1039 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1040 c1 c1
1041 1 1
1042 3 3
1043 5 5
1044 7 7
1045 9 9
1046 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1047 c1 c1
1048 1 1
1049 3 3
1050 5 5
1051 7 7
1052 9 9
1053 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1054 c1 c1
1055 1 1
1056 3 3
1057 5 5
1058 DROP TABLE t1,t2,t3,t4,t5,t6;
1059 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1060 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1061 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1062 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1063 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1064 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1065 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1066 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1067 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1068 INSERT INTO t4 (c1) VALUES(10);
1069 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1070 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1071 c1 c1
1072 1 1
1073 3 3
1074 5 5
1075 7 7
1076 9 9
1077 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1078 c1 c1
1079 1 1
1080 3 3
1081 5 5
1082 7 7
1083 9 9
1084 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1085 c1 c1
1086 1 1
1087 3 3
1088 5 5
1089 DROP TABLE t1,t2,t3,t4,t5,t6;
1090 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1091 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1092 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1093 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1094 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1095 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1096 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1097 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1098 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1099 INSERT INTO t4 (c1) VALUES(10);
1100 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1101 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1102 c1 c1
1103 1 1
1104 3 3
1105 5 5
1106 7 7
1107 9 9
1108 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1109 c1 c1
1110 1 1
1111 3 3
1112 5 5
1113 7 7
1114 9 9
1115 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1116 c1 c1
1117 1 1
1118 3 3
1119 5 5
1120 DROP TABLE t1,t2,t3,t4,t5,t6;
1121 CREATE TABLE t1 (c1 INT NOT NULL);
1122 CREATE TABLE t2 (c1 INT NOT NULL);
1123 CREATE TABLE t3 (c1 INT NOT NULL);
1124 CREATE TABLE t4 (c1 INT NOT NULL);
1125 CREATE TABLE t5 (c1 INT NOT NULL);
1126 CREATE TABLE t6 (c1 INT NOT NULL);
1127 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1128 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1129 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1130 INSERT INTO t4 (c1) VALUES(10);
1131 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1132 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1133 c1 c1
1134 1 1
1135 3 3
1136 5 5
1137 7 7
1138 9 9
1139 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1140 c1 c1
1141 1 1
1142 3 3
1143 5 5
1144 7 7
1145 9 9
1146 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1147 c1 c1
1148 1 1
1149 3 3
1150 5 5
1151 DROP TABLE t1,t2,t3,t4,t5,t6;
1152 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1153 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1154 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1155 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1156 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1157 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1158 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1159 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1160 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1161 INSERT INTO t4 (c1) VALUES(10);
1162 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1163 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1164 c1 c1
1165 1 1
1166 3 3
1167 5 5
1168 7 7
1169 9 9
1170 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1171 c1 c1
1172 1 1
1173 3 3
1174 5 5
1175 7 7
1176 9 9
1177 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1178 c1 c1
1179 1 1
1180 3 3
1181 5 5
1182 DROP TABLE t1,t2,t3,t4,t5,t6;
1183 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1184 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1185 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1186 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1187 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1188 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1189 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1190 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1191 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1192 INSERT INTO t4 (c1) VALUES(10);
1193 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1194 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1195 c1 c1
1196 1 1
1197 3 3
1198 5 5
1199 7 7
1200 9 9
1201 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1202 c1 c1
1203 1 1
1204 3 3
1205 5 5
1206 7 7
1207 9 9
1208 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
1209 c1 c1
1210 1 1
1211 3 3
1212 5 5
1213 DROP TABLE t1,t2,t3,t4,t5,t6;
1214 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1215 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1216 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1217 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1218 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1219 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1220 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1221 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1222 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1223 INSERT INTO t4 (c1) VALUES(10);
1224 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1225 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1226 c1 c1
1227 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1228 c1 c1
1229 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1230 c1 c1
1231 DROP TABLE t1,t2,t3,t4,t5,t6;
1232 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1233 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1234 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1235 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1236 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1237 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1238 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1239 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1240 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1241 INSERT INTO t4 (c1) VALUES(10);
1242 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1243 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1244 c1 c1
1245 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1246 c1 c1
1247 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1248 c1 c1
1249 DROP TABLE t1,t2,t3,t4,t5,t6;
1250 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1251 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1252 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1253 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1254 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1255 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1256 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1257 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1258 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1259 INSERT INTO t4 (c1) VALUES(10);
1260 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1261 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1262 c1 c1
1263 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1264 c1 c1
1265 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1266 c1 c1
1267 DROP TABLE t1,t2,t3,t4,t5,t6;
1268 CREATE TABLE t1 (c1 INT NOT NULL);
1269 CREATE TABLE t2 (c1 INT NOT NULL);
1270 CREATE TABLE t3 (c1 INT NOT NULL);
1271 CREATE TABLE t4 (c1 INT NOT NULL);
1272 CREATE TABLE t5 (c1 INT NOT NULL);
1273 CREATE TABLE t6 (c1 INT NOT NULL);
1274 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1275 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1276 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1277 INSERT INTO t4 (c1) VALUES(10);
1278 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1279 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1280 c1 c1
1281 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1282 c1 c1
1283 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1284 c1 c1
1285 DROP TABLE t1,t2,t3,t4,t5,t6;
1286 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1287 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1288 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1289 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1290 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1291 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1292 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1293 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1294 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1295 INSERT INTO t4 (c1) VALUES(10);
1296 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1297 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1298 c1 c1
1299 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1300 c1 c1
1301 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1302 c1 c1
1303 DROP TABLE t1,t2,t3,t4,t5,t6;
1304 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1305 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1306 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1307 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1308 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1309 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1310 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1311 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1312 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1313 INSERT INTO t4 (c1) VALUES(10);
1314 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1315 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1316 c1 c1
1317 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1318 c1 c1
1319 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
1320 c1 c1
1321 DROP TABLE t1,t2,t3,t4,t5,t6;
1322 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1323 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1324 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1325 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1326 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1327 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1328 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1329 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1330 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1331 INSERT INTO t4 (c1) VALUES(10);
1332 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1333 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
1334 c1 c1
1335 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
1336 c1 c1
1337 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1338 c1 c1
1339 DROP TABLE t1,t2,t3,t4,t5,t6;
1340 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1341 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1342 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1343 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1344 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1345 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1346 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1347 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1348 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1349 INSERT INTO t4 (c1) VALUES(10);
1350 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1351 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
1352 c1 c1
1353 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
1354 c1 c1
1355 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1356 c1 c1
1357 DROP TABLE t1,t2,t3,t4,t5,t6;
1358 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1359 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1360 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1361 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1362 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1363 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1364 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1365 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1366 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1367 INSERT INTO t4 (c1) VALUES(10);
1368 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1369 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
1370 c1 c1
1371 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
1372 c1 c1
1373 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1374 c1 c1
1375 DROP TABLE t1,t2,t3,t4,t5,t6;
1376 CREATE TABLE t1 (c1 INT NOT NULL);
1377 CREATE TABLE t2 (c1 INT NOT NULL);
1378 CREATE TABLE t3 (c1 INT NOT NULL);
1379 CREATE TABLE t4 (c1 INT NOT NULL);
1380 CREATE TABLE t5 (c1 INT NOT NULL);
1381 CREATE TABLE t6 (c1 INT NOT NULL);
1382 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1383 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1384 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1385 INSERT INTO t4 (c1) VALUES(10);
1386 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1387 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
1388 c1 c1
1389 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
1390 c1 c1
1391 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1392 c1 c1
1393 DROP TABLE t1,t2,t3,t4,t5,t6;
1394 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1395 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1396 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1397 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1398 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1399 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1400 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1401 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1402 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1403 INSERT INTO t4 (c1) VALUES(10);
1404 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1405 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
1406 c1 c1
1407 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
1408 c1 c1
1409 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1410 c1 c1
1411 DROP TABLE t1,t2,t3,t4,t5,t6;
1412 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1413 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1414 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1415 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1416 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1417 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1418 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1419 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1420 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1421 INSERT INTO t4 (c1) VALUES(10);
1422 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1423 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
1424 c1 c1
1425 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
1426 c1 c1
1427 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
1428 c1 c1
1429 DROP TABLE t1,t2,t3,t4,t5,t6;
1430 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1431 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1432 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1433 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1434 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1435 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1436 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1437 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1438 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1439 INSERT INTO t4 (c1) VALUES(10);
1440 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1441 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
1442 c1 c1
1443 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
1444 c1 c1
1445 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1446 c1 c1
1447 DROP TABLE t1,t2,t3,t4,t5,t6;
1448 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1449 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1450 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1451 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1452 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1453 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1454 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1455 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1456 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1457 INSERT INTO t4 (c1) VALUES(10);
1458 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1459 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
1460 c1 c1
1461 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
1462 c1 c1
1463 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1464 c1 c1
1465 DROP TABLE t1,t2,t3,t4,t5,t6;
1466 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1467 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1468 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1469 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1470 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1471 CREATE TABLE t6 (c1 MEDIUMINT 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,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
1478 c1 c1
1479 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
1480 c1 c1
1481 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1482 c1 c1
1483 DROP TABLE t1,t2,t3,t4,t5,t6;
1484 CREATE TABLE t1 (c1 INT NOT NULL);
1485 CREATE TABLE t2 (c1 INT NOT NULL);
1486 CREATE TABLE t3 (c1 INT NOT NULL);
1487 CREATE TABLE t4 (c1 INT NOT NULL);
1488 CREATE TABLE t5 (c1 INT NOT NULL);
1489 CREATE TABLE t6 (c1 INT NOT NULL);
1490 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1491 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1492 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1493 INSERT INTO t4 (c1) VALUES(10);
1494 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1495 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
1496 c1 c1
1497 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
1498 c1 c1
1499 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1500 c1 c1
1501 DROP TABLE t1,t2,t3,t4,t5,t6;
1502 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1503 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1504 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1505 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1506 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1507 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1508 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1509 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1510 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1511 INSERT INTO t4 (c1) VALUES(10);
1512 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1513 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
1514 c1 c1
1515 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
1516 c1 c1
1517 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1518 c1 c1
1519 DROP TABLE t1,t2,t3,t4,t5,t6;
1520 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1521 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1522 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1523 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1524 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1525 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1526 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1527 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1528 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1529 INSERT INTO t4 (c1) VALUES(10);
1530 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1531 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
1532 c1 c1
1533 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
1534 c1 c1
1535 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
1536 c1 c1
1537 DROP TABLE t1,t2,t3,t4,t5,t6;
1538 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1539 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1540 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1541 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1542 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1543 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1544 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1545 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1546 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1547 INSERT INTO t4 (c1) VALUES(10);
1548 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1549 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
1550 c1 c1
1551 0 0
1552 1 1
1553 2 2
1554 3 3
1555 4 4
1556 5 5
1557 6 6
1558 7 7
1559 8 8
1560 9 9
1561 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1562 c1 c1
1563 0 0
1564 1 1
1565 2 2
1566 3 3
1567 4 4
1568 5 5
1569 6 6
1570 7 7
1571 8 8
1572 9 9
1573 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1574 c1 c1
1575 5 5
1576 DROP TABLE t1,t2,t3,t4,t5,t6;
1577 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1578 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1579 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1580 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1581 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1582 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1583 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1584 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1585 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1586 INSERT INTO t4 (c1) VALUES(10);
1587 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1588 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
1589 c1 c1
1590 0 0
1591 1 1
1592 2 2
1593 3 3
1594 4 4
1595 5 5
1596 6 6
1597 7 7
1598 8 8
1599 9 9
1600 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1601 c1 c1
1602 0 0
1603 1 1
1604 2 2
1605 3 3
1606 4 4
1607 5 5
1608 6 6
1609 7 7
1610 8 8
1611 9 9
1612 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1613 c1 c1
1614 5 5
1615 DROP TABLE t1,t2,t3,t4,t5,t6;
1616 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1617 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1618 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1619 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1620 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1621 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1622 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1623 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1624 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1625 INSERT INTO t4 (c1) VALUES(10);
1626 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1627 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
1628 c1 c1
1629 0 0
1630 1 1
1631 2 2
1632 3 3
1633 4 4
1634 5 5
1635 6 6
1636 7 7
1637 8 8
1638 9 9
1639 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1640 c1 c1
1641 0 0
1642 1 1
1643 2 2
1644 3 3
1645 4 4
1646 5 5
1647 6 6
1648 7 7
1649 8 8
1650 9 9
1651 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1652 c1 c1
1653 5 5
1654 DROP TABLE t1,t2,t3,t4,t5,t6;
1655 CREATE TABLE t1 (c1 INT NOT NULL);
1656 CREATE TABLE t2 (c1 INT NOT NULL);
1657 CREATE TABLE t3 (c1 INT NOT NULL);
1658 CREATE TABLE t4 (c1 INT NOT NULL);
1659 CREATE TABLE t5 (c1 INT NOT NULL);
1660 CREATE TABLE t6 (c1 INT NOT NULL);
1661 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1662 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1663 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1664 INSERT INTO t4 (c1) VALUES(10);
1665 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1666 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
1667 c1 c1
1668 0 0
1669 1 1
1670 2 2
1671 3 3
1672 4 4
1673 5 5
1674 6 6
1675 7 7
1676 8 8
1677 9 9
1678 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1679 c1 c1
1680 0 0
1681 1 1
1682 2 2
1683 3 3
1684 4 4
1685 5 5
1686 6 6
1687 7 7
1688 8 8
1689 9 9
1690 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1691 c1 c1
1692 5 5
1693 DROP TABLE t1,t2,t3,t4,t5,t6;
1694 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1695 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1696 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1697 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1698 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1699 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1700 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1701 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1702 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1703 INSERT INTO t4 (c1) VALUES(10);
1704 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1705 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
1706 c1 c1
1707 0 0
1708 1 1
1709 2 2
1710 3 3
1711 4 4
1712 5 5
1713 6 6
1714 7 7
1715 8 8
1716 9 9
1717 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1718 c1 c1
1719 0 0
1720 1 1
1721 2 2
1722 3 3
1723 4 4
1724 5 5
1725 6 6
1726 7 7
1727 8 8
1728 9 9
1729 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1730 c1 c1
1731 5 5
1732 DROP TABLE t1,t2,t3,t4,t5,t6;
1733 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1734 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1735 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1736 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1737 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1738 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1739 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1740 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1741 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1742 INSERT INTO t4 (c1) VALUES(10);
1743 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1744 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
1745 c1 c1
1746 0 0
1747 1 1
1748 2 2
1749 3 3
1750 4 4
1751 5 5
1752 6 6
1753 7 7
1754 8 8
1755 9 9
1756 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
1757 c1 c1
1758 0 0
1759 1 1
1760 2 2
1761 3 3
1762 4 4
1763 5 5
1764 6 6
1765 7 7
1766 8 8
1767 9 9
1768 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
1769 c1 c1
1770 5 5
1771 DROP TABLE t1,t2,t3,t4,t5,t6;
1772 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1773 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1774 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1775 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1776 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1777 CREATE TABLE t6 (c1 TINYINT 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,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1784 c1 c1
1785 1 1
1786 3 3
1787 5 5
1788 7 7
1789 9 9
1790 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1791 c1 c1
1792 1 1
1793 3 3
1794 5 5
1795 7 7
1796 9 9
1797 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1798 c1 c1
1799 5 5
1800 DROP TABLE t1,t2,t3,t4,t5,t6;
1801 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1802 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1803 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1804 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1805 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1806 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1807 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1808 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1809 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1810 INSERT INTO t4 (c1) VALUES(10);
1811 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1812 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1813 c1 c1
1814 1 1
1815 3 3
1816 5 5
1817 7 7
1818 9 9
1819 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1820 c1 c1
1821 1 1
1822 3 3
1823 5 5
1824 7 7
1825 9 9
1826 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1827 c1 c1
1828 5 5
1829 DROP TABLE t1,t2,t3,t4,t5,t6;
1830 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1831 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1832 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1833 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1834 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1835 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1836 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1837 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1838 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1839 INSERT INTO t4 (c1) VALUES(10);
1840 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1841 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1842 c1 c1
1843 1 1
1844 3 3
1845 5 5
1846 7 7
1847 9 9
1848 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1849 c1 c1
1850 1 1
1851 3 3
1852 5 5
1853 7 7
1854 9 9
1855 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1856 c1 c1
1857 5 5
1858 DROP TABLE t1,t2,t3,t4,t5,t6;
1859 CREATE TABLE t1 (c1 INT NOT NULL);
1860 CREATE TABLE t2 (c1 INT NOT NULL);
1861 CREATE TABLE t3 (c1 INT NOT NULL);
1862 CREATE TABLE t4 (c1 INT NOT NULL);
1863 CREATE TABLE t5 (c1 INT NOT NULL);
1864 CREATE TABLE t6 (c1 INT NOT NULL);
1865 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1866 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1867 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1868 INSERT INTO t4 (c1) VALUES(10);
1869 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1870 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1871 c1 c1
1872 1 1
1873 3 3
1874 5 5
1875 7 7
1876 9 9
1877 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1878 c1 c1
1879 1 1
1880 3 3
1881 5 5
1882 7 7
1883 9 9
1884 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1885 c1 c1
1886 5 5
1887 DROP TABLE t1,t2,t3,t4,t5,t6;
1888 CREATE TABLE t1 (c1 INTEGER NOT NULL);
1889 CREATE TABLE t2 (c1 INTEGER NOT NULL);
1890 CREATE TABLE t3 (c1 INTEGER NOT NULL);
1891 CREATE TABLE t4 (c1 INTEGER NOT NULL);
1892 CREATE TABLE t5 (c1 INTEGER NOT NULL);
1893 CREATE TABLE t6 (c1 INTEGER NOT NULL);
1894 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1895 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1896 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1897 INSERT INTO t4 (c1) VALUES(10);
1898 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1899 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1900 c1 c1
1901 1 1
1902 3 3
1903 5 5
1904 7 7
1905 9 9
1906 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1907 c1 c1
1908 1 1
1909 3 3
1910 5 5
1911 7 7
1912 9 9
1913 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1914 c1 c1
1915 5 5
1916 DROP TABLE t1,t2,t3,t4,t5,t6;
1917 CREATE TABLE t1 (c1 BIGINT NOT NULL);
1918 CREATE TABLE t2 (c1 BIGINT NOT NULL);
1919 CREATE TABLE t3 (c1 BIGINT NOT NULL);
1920 CREATE TABLE t4 (c1 BIGINT NOT NULL);
1921 CREATE TABLE t5 (c1 BIGINT NOT NULL);
1922 CREATE TABLE t6 (c1 BIGINT NOT NULL);
1923 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1924 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1925 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1926 INSERT INTO t4 (c1) VALUES(10);
1927 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1928 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
1929 c1 c1
1930 1 1
1931 3 3
1932 5 5
1933 7 7
1934 9 9
1935 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
1936 c1 c1
1937 1 1
1938 3 3
1939 5 5
1940 7 7
1941 9 9
1942 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1943 c1 c1
1944 5 5
1945 DROP TABLE t1,t2,t3,t4,t5,t6;
1946 CREATE TABLE t1 (c1 TINYINT NOT NULL);
1947 CREATE TABLE t2 (c1 TINYINT NOT NULL);
1948 CREATE TABLE t3 (c1 TINYINT NOT NULL);
1949 CREATE TABLE t4 (c1 TINYINT NOT NULL);
1950 CREATE TABLE t5 (c1 TINYINT NOT NULL);
1951 CREATE TABLE t6 (c1 TINYINT NOT NULL);
1952 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1953 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1954 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1955 INSERT INTO t4 (c1) VALUES(10);
1956 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1957 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1958 c1 c1
1959 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1960 c1 c1
1961 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1962 c1 c1
1963 DROP TABLE t1,t2,t3,t4,t5,t6;
1964 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1965 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1966 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1967 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1968 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1969 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1970 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1971 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1972 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1973 INSERT INTO t4 (c1) VALUES(10);
1974 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1975 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1976 c1 c1
1977 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1978 c1 c1
1979 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1980 c1 c1
1981 DROP TABLE t1,t2,t3,t4,t5,t6;
1982 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1983 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1984 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1985 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1986 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1987 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1988 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1989 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1990 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1991 INSERT INTO t4 (c1) VALUES(10);
1992 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1993 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
1994 c1 c1
1995 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
1996 c1 c1
1997 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1998 c1 c1
1999 DROP TABLE t1,t2,t3,t4,t5,t6;
2000 CREATE TABLE t1 (c1 INT NOT NULL);
2001 CREATE TABLE t2 (c1 INT NOT NULL);
2002 CREATE TABLE t3 (c1 INT NOT NULL);
2003 CREATE TABLE t4 (c1 INT NOT NULL);
2004 CREATE TABLE t5 (c1 INT NOT NULL);
2005 CREATE TABLE t6 (c1 INT NOT NULL);
2006 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2007 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2008 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2009 INSERT INTO t4 (c1) VALUES(10);
2010 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2011 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2012 c1 c1
2013 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2014 c1 c1
2015 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
2016 c1 c1
2017 DROP TABLE t1,t2,t3,t4,t5,t6;
2018 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2019 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2020 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2021 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2022 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2023 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2024 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2025 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2026 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2027 INSERT INTO t4 (c1) VALUES(10);
2028 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2029 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2030 c1 c1
2031 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2032 c1 c1
2033 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
2034 c1 c1
2035 DROP TABLE t1,t2,t3,t4,t5,t6;
2036 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2037 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2038 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2039 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2040 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2041 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2042 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2043 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2044 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2045 INSERT INTO t4 (c1) VALUES(10);
2046 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2047 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2048 c1 c1
2049 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2050 c1 c1
2051 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
2052 c1 c1
2053 DROP TABLE t1,t2,t3,t4,t5,t6;
2054 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2055 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2056 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2057 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2058 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2059 CREATE TABLE t6 (c1 TINYINT 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2066 c1 c1
2067 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2068 c1 c1
2069 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2070 c1 c1
2071 DROP TABLE t1,t2,t3,t4,t5,t6;
2072 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2073 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2074 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2075 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2076 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2077 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2078 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2079 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2080 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2081 INSERT INTO t4 (c1) VALUES(10);
2082 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2083 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2084 c1 c1
2085 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2086 c1 c1
2087 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2088 c1 c1
2089 DROP TABLE t1,t2,t3,t4,t5,t6;
2090 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2091 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2092 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2093 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2094 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2095 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2096 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2097 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2098 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2099 INSERT INTO t4 (c1) VALUES(10);
2100 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2101 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2102 c1 c1
2103 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2104 c1 c1
2105 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2106 c1 c1
2107 DROP TABLE t1,t2,t3,t4,t5,t6;
2108 CREATE TABLE t1 (c1 INT NOT NULL);
2109 CREATE TABLE t2 (c1 INT NOT NULL);
2110 CREATE TABLE t3 (c1 INT NOT NULL);
2111 CREATE TABLE t4 (c1 INT NOT NULL);
2112 CREATE TABLE t5 (c1 INT NOT NULL);
2113 CREATE TABLE t6 (c1 INT NOT NULL);
2114 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2115 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2116 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2117 INSERT INTO t4 (c1) VALUES(10);
2118 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2119 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2120 c1 c1
2121 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2122 c1 c1
2123 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2124 c1 c1
2125 DROP TABLE t1,t2,t3,t4,t5,t6;
2126 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2127 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2128 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2129 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2130 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2131 CREATE TABLE t6 (c1 INTEGER 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2138 c1 c1
2139 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2140 c1 c1
2141 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2142 c1 c1
2143 DROP TABLE t1,t2,t3,t4,t5,t6;
2144 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2145 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2146 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2147 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2148 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2149 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2150 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2151 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2152 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2153 INSERT INTO t4 (c1) VALUES(10);
2154 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2155 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2156 c1 c1
2157 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2158 c1 c1
2159 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
2160 c1 c1
2161 DROP TABLE t1,t2,t3,t4,t5,t6;
2162 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2163 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2164 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2165 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2166 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2167 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2168 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2169 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2170 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2171 INSERT INTO t4 (c1) VALUES(10);
2172 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2173 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2174 c1 c1
2175 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2176 c1 c1
2177 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2178 c1 c1
2179 DROP TABLE t1,t2,t3,t4,t5,t6;
2180 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2181 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2182 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2183 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2184 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2185 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2186 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2187 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2188 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2189 INSERT INTO t4 (c1) VALUES(10);
2190 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2191 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2192 c1 c1
2193 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2194 c1 c1
2195 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2196 c1 c1
2197 DROP TABLE t1,t2,t3,t4,t5,t6;
2198 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2199 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2200 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2201 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2202 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2203 CREATE TABLE t6 (c1 MEDIUMINT 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,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2210 c1 c1
2211 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2212 c1 c1
2213 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2214 c1 c1
2215 DROP TABLE t1,t2,t3,t4,t5,t6;
2216 CREATE TABLE t1 (c1 INT NOT NULL);
2217 CREATE TABLE t2 (c1 INT NOT NULL);
2218 CREATE TABLE t3 (c1 INT NOT NULL);
2219 CREATE TABLE t4 (c1 INT NOT NULL);
2220 CREATE TABLE t5 (c1 INT NOT NULL);
2221 CREATE TABLE t6 (c1 INT NOT NULL);
2222 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2223 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2224 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2225 INSERT INTO t4 (c1) VALUES(10);
2226 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2227 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2228 c1 c1
2229 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2230 c1 c1
2231 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2232 c1 c1
2233 DROP TABLE t1,t2,t3,t4,t5,t6;
2234 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2235 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2236 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2237 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2238 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2239 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2240 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2241 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2242 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2243 INSERT INTO t4 (c1) VALUES(10);
2244 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2245 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2246 c1 c1
2247 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2248 c1 c1
2249 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2250 c1 c1
2251 DROP TABLE t1,t2,t3,t4,t5,t6;
2252 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2253 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2254 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2255 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2256 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2257 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2258 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2259 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2260 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2261 INSERT INTO t4 (c1) VALUES(10);
2262 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2263 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2264 c1 c1
2265 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2266 c1 c1
2267 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
2268 c1 c1
2269 DROP TABLE t1,t2,t3,t4,t5,t6;
2270 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2271 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2272 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2273 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2274 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2275 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2276 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2277 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2278 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2279 INSERT INTO t4 (c1) VALUES(10);
2280 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2281 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
2282 c1 c1
2283 0 0
2284 1 1
2285 2 2
2286 3 3
2287 4 4
2288 5 5
2289 6 6
2290 7 7
2291 8 8
2292 9 9
2293 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
2294 c1 c1
2295 0 0
2296 1 1
2297 2 2
2298 3 3
2299 4 4
2300 5 5
2301 6 6
2302 7 7
2303 8 8
2304 9 9
2305 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2306 c1 c1
2307 5 5
2308 6 6
2309 7 7
2310 8 8
2311 9 9
2312 DROP TABLE t1,t2,t3,t4,t5,t6;
2313 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2314 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2315 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2316 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2317 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2318 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2319 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2320 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2321 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2322 INSERT INTO t4 (c1) VALUES(10);
2323 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2324 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
2325 c1 c1
2326 0 0
2327 1 1
2328 2 2
2329 3 3
2330 4 4
2331 5 5
2332 6 6
2333 7 7
2334 8 8
2335 9 9
2336 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
2337 c1 c1
2338 0 0
2339 1 1
2340 2 2
2341 3 3
2342 4 4
2343 5 5
2344 6 6
2345 7 7
2346 8 8
2347 9 9
2348 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2349 c1 c1
2350 5 5
2351 6 6
2352 7 7
2353 8 8
2354 9 9
2355 DROP TABLE t1,t2,t3,t4,t5,t6;
2356 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2357 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2358 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2359 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2360 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2361 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2362 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2363 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2364 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2365 INSERT INTO t4 (c1) VALUES(10);
2366 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2367 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
2368 c1 c1
2369 0 0
2370 1 1
2371 2 2
2372 3 3
2373 4 4
2374 5 5
2375 6 6
2376 7 7
2377 8 8
2378 9 9
2379 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
2380 c1 c1
2381 0 0
2382 1 1
2383 2 2
2384 3 3
2385 4 4
2386 5 5
2387 6 6
2388 7 7
2389 8 8
2390 9 9
2391 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2392 c1 c1
2393 5 5
2394 6 6
2395 7 7
2396 8 8
2397 9 9
2398 DROP TABLE t1,t2,t3,t4,t5,t6;
2399 CREATE TABLE t1 (c1 INT NOT NULL);
2400 CREATE TABLE t2 (c1 INT NOT NULL);
2401 CREATE TABLE t3 (c1 INT NOT NULL);
2402 CREATE TABLE t4 (c1 INT NOT NULL);
2403 CREATE TABLE t5 (c1 INT NOT NULL);
2404 CREATE TABLE t6 (c1 INT NOT NULL);
2405 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2406 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2407 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2408 INSERT INTO t4 (c1) VALUES(10);
2409 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2410 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
2411 c1 c1
2412 0 0
2413 1 1
2414 2 2
2415 3 3
2416 4 4
2417 5 5
2418 6 6
2419 7 7
2420 8 8
2421 9 9
2422 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
2423 c1 c1
2424 0 0
2425 1 1
2426 2 2
2427 3 3
2428 4 4
2429 5 5
2430 6 6
2431 7 7
2432 8 8
2433 9 9
2434 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2435 c1 c1
2436 5 5
2437 6 6
2438 7 7
2439 8 8
2440 9 9
2441 DROP TABLE t1,t2,t3,t4,t5,t6;
2442 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2443 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2444 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2445 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2446 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2447 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2448 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2449 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2450 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2451 INSERT INTO t4 (c1) VALUES(10);
2452 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2453 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
2454 c1 c1
2455 0 0
2456 1 1
2457 2 2
2458 3 3
2459 4 4
2460 5 5
2461 6 6
2462 7 7
2463 8 8
2464 9 9
2465 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
2466 c1 c1
2467 0 0
2468 1 1
2469 2 2
2470 3 3
2471 4 4
2472 5 5
2473 6 6
2474 7 7
2475 8 8
2476 9 9
2477 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2478 c1 c1
2479 5 5
2480 6 6
2481 7 7
2482 8 8
2483 9 9
2484 DROP TABLE t1,t2,t3,t4,t5,t6;
2485 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2486 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2487 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2488 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2489 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2490 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2491 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2492 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2493 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2494 INSERT INTO t4 (c1) VALUES(10);
2495 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2496 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
2497 c1 c1
2498 0 0
2499 1 1
2500 2 2
2501 3 3
2502 4 4
2503 5 5
2504 6 6
2505 7 7
2506 8 8
2507 9 9
2508 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
2509 c1 c1
2510 0 0
2511 1 1
2512 2 2
2513 3 3
2514 4 4
2515 5 5
2516 6 6
2517 7 7
2518 8 8
2519 9 9
2520 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
2521 c1 c1
2522 5 5
2523 6 6
2524 7 7
2525 8 8
2526 9 9
2527 DROP TABLE t1,t2,t3,t4,t5,t6;
2528 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2529 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2530 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2531 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2532 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2533 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2534 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2535 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2536 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2537 INSERT INTO t4 (c1) VALUES(10);
2538 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2539 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
2540 c1 c1
2541 1 1
2542 3 3
2543 5 5
2544 7 7
2545 9 9
2546 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
2547 c1 c1
2548 1 1
2549 3 3
2550 5 5
2551 7 7
2552 9 9
2553 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2554 c1 c1
2555 5 5
2556 7 7
2557 9 9
2558 DROP TABLE t1,t2,t3,t4,t5,t6;
2559 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2560 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2561 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2562 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2563 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2564 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2565 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2566 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2567 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2568 INSERT INTO t4 (c1) VALUES(10);
2569 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2570 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
2571 c1 c1
2572 1 1
2573 3 3
2574 5 5
2575 7 7
2576 9 9
2577 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
2578 c1 c1
2579 1 1
2580 3 3
2581 5 5
2582 7 7
2583 9 9
2584 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2585 c1 c1
2586 5 5
2587 7 7
2588 9 9
2589 DROP TABLE t1,t2,t3,t4,t5,t6;
2590 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2591 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2592 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2593 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2594 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2595 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2596 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2597 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2598 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2599 INSERT INTO t4 (c1) VALUES(10);
2600 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2601 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
2602 c1 c1
2603 1 1
2604 3 3
2605 5 5
2606 7 7
2607 9 9
2608 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
2609 c1 c1
2610 1 1
2611 3 3
2612 5 5
2613 7 7
2614 9 9
2615 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2616 c1 c1
2617 5 5
2618 7 7
2619 9 9
2620 DROP TABLE t1,t2,t3,t4,t5,t6;
2621 CREATE TABLE t1 (c1 INT NOT NULL);
2622 CREATE TABLE t2 (c1 INT NOT NULL);
2623 CREATE TABLE t3 (c1 INT NOT NULL);
2624 CREATE TABLE t4 (c1 INT NOT NULL);
2625 CREATE TABLE t5 (c1 INT NOT NULL);
2626 CREATE TABLE t6 (c1 INT NOT NULL);
2627 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2628 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2629 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2630 INSERT INTO t4 (c1) VALUES(10);
2631 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2632 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
2633 c1 c1
2634 1 1
2635 3 3
2636 5 5
2637 7 7
2638 9 9
2639 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
2640 c1 c1
2641 1 1
2642 3 3
2643 5 5
2644 7 7
2645 9 9
2646 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2647 c1 c1
2648 5 5
2649 7 7
2650 9 9
2651 DROP TABLE t1,t2,t3,t4,t5,t6;
2652 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2653 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2654 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2655 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2656 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2657 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2658 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2659 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2660 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2661 INSERT INTO t4 (c1) VALUES(10);
2662 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2663 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
2664 c1 c1
2665 1 1
2666 3 3
2667 5 5
2668 7 7
2669 9 9
2670 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
2671 c1 c1
2672 1 1
2673 3 3
2674 5 5
2675 7 7
2676 9 9
2677 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2678 c1 c1
2679 5 5
2680 7 7
2681 9 9
2682 DROP TABLE t1,t2,t3,t4,t5,t6;
2683 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2684 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2685 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2686 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2687 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2688 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2689 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2690 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2691 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2692 INSERT INTO t4 (c1) VALUES(10);
2693 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2694 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
2695 c1 c1
2696 1 1
2697 3 3
2698 5 5
2699 7 7
2700 9 9
2701 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
2702 c1 c1
2703 1 1
2704 3 3
2705 5 5
2706 7 7
2707 9 9
2708 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
2709 c1 c1
2710 5 5
2711 7 7
2712 9 9
2713 DROP TABLE t1,t2,t3,t4,t5,t6;
2714 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2715 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2716 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2717 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2718 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2719 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2720 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2721 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2722 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2723 INSERT INTO t4 (c1) VALUES(10);
2724 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2725 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2726 c1 c1
2727 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2728 c1 c1
2729 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2730 c1 c1
2731 DROP TABLE t1,t2,t3,t4,t5,t6;
2732 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2733 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2734 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2735 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2736 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2737 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2738 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2739 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2740 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2741 INSERT INTO t4 (c1) VALUES(10);
2742 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2743 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2744 c1 c1
2745 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2746 c1 c1
2747 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2748 c1 c1
2749 DROP TABLE t1,t2,t3,t4,t5,t6;
2750 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2751 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2752 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2753 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2754 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2755 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2756 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2757 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2758 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2759 INSERT INTO t4 (c1) VALUES(10);
2760 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2761 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2762 c1 c1
2763 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2764 c1 c1
2765 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2766 c1 c1
2767 DROP TABLE t1,t2,t3,t4,t5,t6;
2768 CREATE TABLE t1 (c1 INT NOT NULL);
2769 CREATE TABLE t2 (c1 INT NOT NULL);
2770 CREATE TABLE t3 (c1 INT NOT NULL);
2771 CREATE TABLE t4 (c1 INT NOT NULL);
2772 CREATE TABLE t5 (c1 INT NOT NULL);
2773 CREATE TABLE t6 (c1 INT NOT NULL);
2774 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2775 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2776 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2777 INSERT INTO t4 (c1) VALUES(10);
2778 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2779 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2780 c1 c1
2781 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2782 c1 c1
2783 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2784 c1 c1
2785 DROP TABLE t1,t2,t3,t4,t5,t6;
2786 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2787 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2788 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2789 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2790 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2791 CREATE TABLE t6 (c1 INTEGER NOT NULL);
2792 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2793 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2794 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2795 INSERT INTO t4 (c1) VALUES(10);
2796 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2797 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2798 c1 c1
2799 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2800 c1 c1
2801 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2802 c1 c1
2803 DROP TABLE t1,t2,t3,t4,t5,t6;
2804 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2805 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2806 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2807 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2808 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2809 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2810 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2811 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2812 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2813 INSERT INTO t4 (c1) VALUES(10);
2814 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2815 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
2816 c1 c1
2817 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
2818 c1 c1
2819 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
2820 c1 c1
2821 DROP TABLE t1,t2,t3,t4,t5,t6;
2822 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2823 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2824 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2825 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2826 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2827 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2828 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2829 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2830 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2831 INSERT INTO t4 (c1) VALUES(10);
2832 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2833 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2834 c1 c1
2835 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2836 c1 c1
2837 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2838 c1 c1
2839 DROP TABLE t1,t2,t3,t4,t5,t6;
2840 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2841 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2842 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2843 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2844 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2845 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2846 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2847 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2848 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2849 INSERT INTO t4 (c1) VALUES(10);
2850 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2851 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2852 c1 c1
2853 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2854 c1 c1
2855 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2856 c1 c1
2857 DROP TABLE t1,t2,t3,t4,t5,t6;
2858 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2859 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2860 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2861 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2862 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2863 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2864 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2865 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2866 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2867 INSERT INTO t4 (c1) VALUES(10);
2868 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2869 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2870 c1 c1
2871 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2872 c1 c1
2873 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2874 c1 c1
2875 DROP TABLE t1,t2,t3,t4,t5,t6;
2876 CREATE TABLE t1 (c1 INT NOT NULL);
2877 CREATE TABLE t2 (c1 INT NOT NULL);
2878 CREATE TABLE t3 (c1 INT NOT NULL);
2879 CREATE TABLE t4 (c1 INT NOT NULL);
2880 CREATE TABLE t5 (c1 INT NOT NULL);
2881 CREATE TABLE t6 (c1 INT NOT NULL);
2882 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2883 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2884 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2885 INSERT INTO t4 (c1) VALUES(10);
2886 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2887 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2888 c1 c1
2889 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2890 c1 c1
2891 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2892 c1 c1
2893 DROP TABLE t1,t2,t3,t4,t5,t6;
2894 CREATE TABLE t1 (c1 INTEGER NOT NULL);
2895 CREATE TABLE t2 (c1 INTEGER NOT NULL);
2896 CREATE TABLE t3 (c1 INTEGER NOT NULL);
2897 CREATE TABLE t4 (c1 INTEGER NOT NULL);
2898 CREATE TABLE t5 (c1 INTEGER NOT NULL);
2899 CREATE TABLE t6 (c1 INTEGER 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 CROSS JOIN t5 USING (c1);
2906 c1 c1
2907 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2908 c1 c1
2909 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2910 c1 c1
2911 DROP TABLE t1,t2,t3,t4,t5,t6;
2912 CREATE TABLE t1 (c1 BIGINT NOT NULL);
2913 CREATE TABLE t2 (c1 BIGINT NOT NULL);
2914 CREATE TABLE t3 (c1 BIGINT NOT NULL);
2915 CREATE TABLE t4 (c1 BIGINT NOT NULL);
2916 CREATE TABLE t5 (c1 BIGINT NOT NULL);
2917 CREATE TABLE t6 (c1 BIGINT NOT NULL);
2918 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2919 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2920 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2921 INSERT INTO t4 (c1) VALUES(10);
2922 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2923 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
2924 c1 c1
2925 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
2926 c1 c1
2927 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
2928 c1 c1
2929 DROP TABLE t1,t2,t3,t4,t5,t6;
2930 CREATE TABLE t1 (c1 TINYINT NOT NULL);
2931 CREATE TABLE t2 (c1 TINYINT NOT NULL);
2932 CREATE TABLE t3 (c1 TINYINT NOT NULL);
2933 CREATE TABLE t4 (c1 TINYINT NOT NULL);
2934 CREATE TABLE t5 (c1 TINYINT NOT NULL);
2935 CREATE TABLE t6 (c1 TINYINT NOT NULL);
2936 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2937 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2938 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2939 INSERT INTO t4 (c1) VALUES(10);
2940 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2941 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2942 c1 c1
2943 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2944 c1 c1
2945 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2946 c1 c1
2947 DROP TABLE t1,t2,t3,t4,t5,t6;
2948 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2949 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2950 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2951 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2952 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2953 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2954 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2955 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2956 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2957 INSERT INTO t4 (c1) VALUES(10);
2958 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2959 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2960 c1 c1
2961 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2962 c1 c1
2963 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2964 c1 c1
2965 DROP TABLE t1,t2,t3,t4,t5,t6;
2966 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2967 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2968 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2969 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2970 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2971 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2972 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2973 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2974 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2975 INSERT INTO t4 (c1) VALUES(10);
2976 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2977 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2978 c1 c1
2979 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2980 c1 c1
2981 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
2982 c1 c1
2983 DROP TABLE t1,t2,t3,t4,t5,t6;
2984 CREATE TABLE t1 (c1 INT NOT NULL);
2985 CREATE TABLE t2 (c1 INT NOT NULL);
2986 CREATE TABLE t3 (c1 INT NOT NULL);
2987 CREATE TABLE t4 (c1 INT NOT NULL);
2988 CREATE TABLE t5 (c1 INT NOT NULL);
2989 CREATE TABLE t6 (c1 INT NOT NULL);
2990 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2991 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2992 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2993 INSERT INTO t4 (c1) VALUES(10);
2994 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2995 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
2996 c1 c1
2997 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
2998 c1 c1
2999 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
3000 c1 c1
3001 DROP TABLE t1,t2,t3,t4,t5,t6;
3002 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3003 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3004 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3005 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3006 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3007 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3008 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3009 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3010 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3011 INSERT INTO t4 (c1) VALUES(10);
3012 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3013 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3014 c1 c1
3015 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3016 c1 c1
3017 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
3018 c1 c1
3019 DROP TABLE t1,t2,t3,t4,t5,t6;
3020 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3021 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3022 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3023 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3024 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3025 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3026 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3027 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3028 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3029 INSERT INTO t4 (c1) VALUES(10);
3030 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3031 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3032 c1 c1
3033 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3034 c1 c1
3035 SELECT t1.c1,t6.c1 FROM t1 CROSS 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 TINYINT NOT NULL);
3039 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3040 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3041 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3042 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3043 CREATE TABLE t6 (c1 TINYINT 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,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3050 c1 c1
3051 0 0
3052 1 1
3053 2 2
3054 3 3
3055 4 4
3056 5 5
3057 6 6
3058 7 7
3059 8 8
3060 9 9
3061 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3062 c1 c1
3063 0 0
3064 1 1
3065 2 2
3066 3 3
3067 4 4
3068 5 5
3069 6 6
3070 7 7
3071 8 8
3072 9 9
3073 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3074 c1 c1
3075 0 0
3076 1 1
3077 2 2
3078 3 3
3079 4 4
3080 6 6
3081 7 7
3082 8 8
3083 9 9
3084 DROP TABLE t1,t2,t3,t4,t5,t6;
3085 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3086 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3087 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3088 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3089 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3090 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3091 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3092 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3093 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3094 INSERT INTO t4 (c1) VALUES(10);
3095 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3096 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3097 c1 c1
3098 0 0
3099 1 1
3100 2 2
3101 3 3
3102 4 4
3103 5 5
3104 6 6
3105 7 7
3106 8 8
3107 9 9
3108 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3109 c1 c1
3110 0 0
3111 1 1
3112 2 2
3113 3 3
3114 4 4
3115 5 5
3116 6 6
3117 7 7
3118 8 8
3119 9 9
3120 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3121 c1 c1
3122 0 0
3123 1 1
3124 2 2
3125 3 3
3126 4 4
3127 6 6
3128 7 7
3129 8 8
3130 9 9
3131 DROP TABLE t1,t2,t3,t4,t5,t6;
3132 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3133 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3134 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3135 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3136 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3137 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3138 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3139 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3140 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3141 INSERT INTO t4 (c1) VALUES(10);
3142 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3143 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3144 c1 c1
3145 0 0
3146 1 1
3147 2 2
3148 3 3
3149 4 4
3150 5 5
3151 6 6
3152 7 7
3153 8 8
3154 9 9
3155 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3156 c1 c1
3157 0 0
3158 1 1
3159 2 2
3160 3 3
3161 4 4
3162 5 5
3163 6 6
3164 7 7
3165 8 8
3166 9 9
3167 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3168 c1 c1
3169 0 0
3170 1 1
3171 2 2
3172 3 3
3173 4 4
3174 6 6
3175 7 7
3176 8 8
3177 9 9
3178 DROP TABLE t1,t2,t3,t4,t5,t6;
3179 CREATE TABLE t1 (c1 INT NOT NULL);
3180 CREATE TABLE t2 (c1 INT NOT NULL);
3181 CREATE TABLE t3 (c1 INT NOT NULL);
3182 CREATE TABLE t4 (c1 INT NOT NULL);
3183 CREATE TABLE t5 (c1 INT NOT NULL);
3184 CREATE TABLE t6 (c1 INT NOT NULL);
3185 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3186 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3187 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3188 INSERT INTO t4 (c1) VALUES(10);
3189 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3190 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3191 c1 c1
3192 0 0
3193 1 1
3194 2 2
3195 3 3
3196 4 4
3197 5 5
3198 6 6
3199 7 7
3200 8 8
3201 9 9
3202 SELECT t1.c1,t2.c1 FROM t1 CROSS 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 CROSS 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 CROSS JOIN t2 USING (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 CROSS JOIN t2 ON t1.c1 = t2.c1;
3250 c1 c1
3251 0 0
3252 1 1
3253 2 2
3254 3 3
3255 4 4
3256 5 5
3257 6 6
3258 7 7
3259 8 8
3260 9 9
3261 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3262 c1 c1
3263 0 0
3264 1 1
3265 2 2
3266 3 3
3267 4 4
3268 6 6
3269 7 7
3270 8 8
3271 9 9
3272 DROP TABLE t1,t2,t3,t4,t5,t6;
3273 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3274 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3275 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3276 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3277 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3278 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3279 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3280 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3281 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3282 INSERT INTO t4 (c1) VALUES(10);
3283 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3284 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3285 c1 c1
3286 0 0
3287 1 1
3288 2 2
3289 3 3
3290 4 4
3291 5 5
3292 6 6
3293 7 7
3294 8 8
3295 9 9
3296 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3297 c1 c1
3298 0 0
3299 1 1
3300 2 2
3301 3 3
3302 4 4
3303 5 5
3304 6 6
3305 7 7
3306 8 8
3307 9 9
3308 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
3309 c1 c1
3310 0 0
3311 1 1
3312 2 2
3313 3 3
3314 4 4
3315 6 6
3316 7 7
3317 8 8
3318 9 9
3319 DROP TABLE t1,t2,t3,t4,t5,t6;
3320 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3321 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3322 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3323 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3324 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3325 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3326 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3327 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3328 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3329 INSERT INTO t4 (c1) VALUES(10);
3330 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3331 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
3332 c1 c1
3333 1 1
3334 3 3
3335 5 5
3336 7 7
3337 9 9
3338 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
3339 c1 c1
3340 1 1
3341 3 3
3342 5 5
3343 7 7
3344 9 9
3345 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3346 c1 c1
3347 1 1
3348 3 3
3349 7 7
3350 9 9
3351 DROP TABLE t1,t2,t3,t4,t5,t6;
3352 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3353 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3354 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3355 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3356 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3357 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3358 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3359 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3360 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3361 INSERT INTO t4 (c1) VALUES(10);
3362 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3363 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
3364 c1 c1
3365 1 1
3366 3 3
3367 5 5
3368 7 7
3369 9 9
3370 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
3371 c1 c1
3372 1 1
3373 3 3
3374 5 5
3375 7 7
3376 9 9
3377 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3378 c1 c1
3379 1 1
3380 3 3
3381 7 7
3382 9 9
3383 DROP TABLE t1,t2,t3,t4,t5,t6;
3384 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3385 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3386 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3387 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3388 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3389 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3390 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3391 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3392 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3393 INSERT INTO t4 (c1) VALUES(10);
3394 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3395 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
3396 c1 c1
3397 1 1
3398 3 3
3399 5 5
3400 7 7
3401 9 9
3402 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
3403 c1 c1
3404 1 1
3405 3 3
3406 5 5
3407 7 7
3408 9 9
3409 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3410 c1 c1
3411 1 1
3412 3 3
3413 7 7
3414 9 9
3415 DROP TABLE t1,t2,t3,t4,t5,t6;
3416 CREATE TABLE t1 (c1 INT NOT NULL);
3417 CREATE TABLE t2 (c1 INT NOT NULL);
3418 CREATE TABLE t3 (c1 INT NOT NULL);
3419 CREATE TABLE t4 (c1 INT NOT NULL);
3420 CREATE TABLE t5 (c1 INT NOT NULL);
3421 CREATE TABLE t6 (c1 INT NOT NULL);
3422 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3423 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3424 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3425 INSERT INTO t4 (c1) VALUES(10);
3426 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3427 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
3428 c1 c1
3429 1 1
3430 3 3
3431 5 5
3432 7 7
3433 9 9
3434 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
3435 c1 c1
3436 1 1
3437 3 3
3438 5 5
3439 7 7
3440 9 9
3441 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3442 c1 c1
3443 1 1
3444 3 3
3445 7 7
3446 9 9
3447 DROP TABLE t1,t2,t3,t4,t5,t6;
3448 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3449 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3450 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3451 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3452 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3453 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3454 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3455 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3456 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3457 INSERT INTO t4 (c1) VALUES(10);
3458 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3459 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
3460 c1 c1
3461 1 1
3462 3 3
3463 5 5
3464 7 7
3465 9 9
3466 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
3467 c1 c1
3468 1 1
3469 3 3
3470 5 5
3471 7 7
3472 9 9
3473 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3474 c1 c1
3475 1 1
3476 3 3
3477 7 7
3478 9 9
3479 DROP TABLE t1,t2,t3,t4,t5,t6;
3480 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3481 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3482 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3483 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3484 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3485 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3486 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3487 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3488 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3489 INSERT INTO t4 (c1) VALUES(10);
3490 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3491 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
3492 c1 c1
3493 1 1
3494 3 3
3495 5 5
3496 7 7
3497 9 9
3498 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
3499 c1 c1
3500 1 1
3501 3 3
3502 5 5
3503 7 7
3504 9 9
3505 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
3506 c1 c1
3507 1 1
3508 3 3
3509 7 7
3510 9 9
3511 DROP TABLE t1,t2,t3,t4,t5,t6;
3512 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3513 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3514 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3515 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3516 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3517 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3518 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3519 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3520 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3521 INSERT INTO t4 (c1) VALUES(10);
3522 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3523 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
3524 c1 c1
3525 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
3526 c1 c1
3527 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3528 c1 c1
3529 DROP TABLE t1,t2,t3,t4,t5,t6;
3530 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3531 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3532 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3533 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3534 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3535 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3536 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3537 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3538 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3539 INSERT INTO t4 (c1) VALUES(10);
3540 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3541 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
3542 c1 c1
3543 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
3544 c1 c1
3545 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3546 c1 c1
3547 DROP TABLE t1,t2,t3,t4,t5,t6;
3548 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3549 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3550 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3551 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3552 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3553 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3554 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3555 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3556 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3557 INSERT INTO t4 (c1) VALUES(10);
3558 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3559 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
3560 c1 c1
3561 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
3562 c1 c1
3563 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3564 c1 c1
3565 DROP TABLE t1,t2,t3,t4,t5,t6;
3566 CREATE TABLE t1 (c1 INT NOT NULL);
3567 CREATE TABLE t2 (c1 INT NOT NULL);
3568 CREATE TABLE t3 (c1 INT NOT NULL);
3569 CREATE TABLE t4 (c1 INT NOT NULL);
3570 CREATE TABLE t5 (c1 INT NOT NULL);
3571 CREATE TABLE t6 (c1 INT NOT NULL);
3572 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3573 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3574 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3575 INSERT INTO t4 (c1) VALUES(10);
3576 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3577 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
3578 c1 c1
3579 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
3580 c1 c1
3581 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3582 c1 c1
3583 DROP TABLE t1,t2,t3,t4,t5,t6;
3584 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3585 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3586 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3587 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3588 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3589 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3590 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3591 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3592 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3593 INSERT INTO t4 (c1) VALUES(10);
3594 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3595 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
3596 c1 c1
3597 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
3598 c1 c1
3599 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3600 c1 c1
3601 DROP TABLE t1,t2,t3,t4,t5,t6;
3602 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3603 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3604 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3605 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3606 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3607 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3608 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3609 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3610 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3611 INSERT INTO t4 (c1) VALUES(10);
3612 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3613 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
3614 c1 c1
3615 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
3616 c1 c1
3617 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
3618 c1 c1
3619 DROP TABLE t1,t2,t3,t4,t5,t6;
3620 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3621 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3622 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3623 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3624 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3625 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3626 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3627 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3628 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3629 INSERT INTO t4 (c1) VALUES(10);
3630 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3631 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
3632 c1 c1
3633 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
3634 c1 c1
3635 SELECT t1.c1,t5.c1 FROM t1 CROSS 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 SMALLINT NOT NULL);
3639 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3640 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3641 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3642 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3643 CREATE TABLE t6 (c1 SMALLINT 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,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
3650 c1 c1
3651 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
3652 c1 c1
3653 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3654 c1 c1
3655 DROP TABLE t1,t2,t3,t4,t5,t6;
3656 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3657 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3658 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3659 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3660 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3661 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3662 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3663 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3664 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3665 INSERT INTO t4 (c1) VALUES(10);
3666 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3667 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
3668 c1 c1
3669 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
3670 c1 c1
3671 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3672 c1 c1
3673 DROP TABLE t1,t2,t3,t4,t5,t6;
3674 CREATE TABLE t1 (c1 INT NOT NULL);
3675 CREATE TABLE t2 (c1 INT NOT NULL);
3676 CREATE TABLE t3 (c1 INT NOT NULL);
3677 CREATE TABLE t4 (c1 INT NOT NULL);
3678 CREATE TABLE t5 (c1 INT NOT NULL);
3679 CREATE TABLE t6 (c1 INT NOT NULL);
3680 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3681 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3682 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3683 INSERT INTO t4 (c1) VALUES(10);
3684 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3685 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
3686 c1 c1
3687 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
3688 c1 c1
3689 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3690 c1 c1
3691 DROP TABLE t1,t2,t3,t4,t5,t6;
3692 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3693 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3694 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3695 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3696 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3697 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3698 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3699 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3700 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3701 INSERT INTO t4 (c1) VALUES(10);
3702 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3703 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
3704 c1 c1
3705 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
3706 c1 c1
3707 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3708 c1 c1
3709 DROP TABLE t1,t2,t3,t4,t5,t6;
3710 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3711 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3712 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3713 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3714 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3715 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3716 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3717 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3718 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3719 INSERT INTO t4 (c1) VALUES(10);
3720 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3721 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
3722 c1 c1
3723 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
3724 c1 c1
3725 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
3726 c1 c1
3727 DROP TABLE t1,t2,t3,t4,t5,t6;
3728 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3729 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3730 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3731 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3732 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3733 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3734 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3735 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3736 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3737 INSERT INTO t4 (c1) VALUES(10);
3738 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3739 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3740 c1 c1
3741 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3742 c1 c1
3743 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3744 c1 c1
3745 DROP TABLE t1,t2,t3,t4,t5,t6;
3746 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3747 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3748 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3749 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3750 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3751 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3752 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3753 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3754 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3755 INSERT INTO t4 (c1) VALUES(10);
3756 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3757 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3758 c1 c1
3759 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3760 c1 c1
3761 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3762 c1 c1
3763 DROP TABLE t1,t2,t3,t4,t5,t6;
3764 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3765 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3766 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3767 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3768 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3769 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3770 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3772 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3773 INSERT INTO t4 (c1) VALUES(10);
3774 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3775 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3776 c1 c1
3777 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3778 c1 c1
3779 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3780 c1 c1
3781 DROP TABLE t1,t2,t3,t4,t5,t6;
3782 CREATE TABLE t1 (c1 INT NOT NULL);
3783 CREATE TABLE t2 (c1 INT NOT NULL);
3784 CREATE TABLE t3 (c1 INT NOT NULL);
3785 CREATE TABLE t4 (c1 INT NOT NULL);
3786 CREATE TABLE t5 (c1 INT NOT NULL);
3787 CREATE TABLE t6 (c1 INT NOT NULL);
3788 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3789 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3790 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3791 INSERT INTO t4 (c1) VALUES(10);
3792 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3793 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3794 c1 c1
3795 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3796 c1 c1
3797 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3798 c1 c1
3799 DROP TABLE t1,t2,t3,t4,t5,t6;
3800 CREATE TABLE t1 (c1 INTEGER NOT NULL);
3801 CREATE TABLE t2 (c1 INTEGER NOT NULL);
3802 CREATE TABLE t3 (c1 INTEGER NOT NULL);
3803 CREATE TABLE t4 (c1 INTEGER NOT NULL);
3804 CREATE TABLE t5 (c1 INTEGER NOT NULL);
3805 CREATE TABLE t6 (c1 INTEGER NOT NULL);
3806 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3807 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3808 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3809 INSERT INTO t4 (c1) VALUES(10);
3810 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3811 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3812 c1 c1
3813 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3814 c1 c1
3815 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3816 c1 c1
3817 DROP TABLE t1,t2,t3,t4,t5,t6;
3818 CREATE TABLE t1 (c1 BIGINT NOT NULL);
3819 CREATE TABLE t2 (c1 BIGINT NOT NULL);
3820 CREATE TABLE t3 (c1 BIGINT NOT NULL);
3821 CREATE TABLE t4 (c1 BIGINT NOT NULL);
3822 CREATE TABLE t5 (c1 BIGINT NOT NULL);
3823 CREATE TABLE t6 (c1 BIGINT NOT NULL);
3824 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3825 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3826 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3827 INSERT INTO t4 (c1) VALUES(10);
3828 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3829 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
3830 c1 c1
3831 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
3832 c1 c1
3833 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
3834 c1 c1
3835 DROP TABLE t1,t2,t3,t4,t5,t6;
3836 CREATE TABLE t1 (c1 TINYINT NOT NULL);
3837 CREATE TABLE t2 (c1 TINYINT NOT NULL);
3838 CREATE TABLE t3 (c1 TINYINT NOT NULL);
3839 CREATE TABLE t4 (c1 TINYINT NOT NULL);
3840 CREATE TABLE t5 (c1 TINYINT NOT NULL);
3841 CREATE TABLE t6 (c1 TINYINT NOT NULL);
3842 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3843 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3844 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3845 INSERT INTO t4 (c1) VALUES(10);
3846 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3847 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3848 c1 c1
3849 0 0
3850 1 1
3851 2 2
3852 3 3
3853 4 4
3854 5 5
3855 6 6
3856 7 7
3857 8 8
3858 9 9
3859 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3860 c1 c1
3861 0 0
3862 1 1
3863 2 2
3864 3 3
3865 4 4
3866 5 5
3867 6 6
3868 7 7
3869 8 8
3870 9 9
3871 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
3872 c1 c1
3873 0 0
3874 1 1
3875 2 2
3876 3 3
3877 4 4
3878 6 6
3879 7 7
3880 8 8
3881 9 9
3882 DROP TABLE t1,t2,t3,t4,t5,t6;
3883 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3884 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3885 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3886 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3887 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3888 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3889 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3890 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3891 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3892 INSERT INTO t4 (c1) VALUES(10);
3893 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3894 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3895 c1 c1
3896 0 0
3897 1 1
3898 2 2
3899 3 3
3900 4 4
3901 5 5
3902 6 6
3903 7 7
3904 8 8
3905 9 9
3906 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3907 c1 c1
3908 0 0
3909 1 1
3910 2 2
3911 3 3
3912 4 4
3913 5 5
3914 6 6
3915 7 7
3916 8 8
3917 9 9
3918 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
3919 c1 c1
3920 0 0
3921 1 1
3922 2 2
3923 3 3
3924 4 4
3925 6 6
3926 7 7
3927 8 8
3928 9 9
3929 DROP TABLE t1,t2,t3,t4,t5,t6;
3930 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3931 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3932 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3933 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3934 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3935 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3936 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3937 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3938 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3939 INSERT INTO t4 (c1) VALUES(10);
3940 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3941 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3942 c1 c1
3943 0 0
3944 1 1
3945 2 2
3946 3 3
3947 4 4
3948 5 5
3949 6 6
3950 7 7
3951 8 8
3952 9 9
3953 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
3954 c1 c1
3955 0 0
3956 1 1
3957 2 2
3958 3 3
3959 4 4
3960 5 5
3961 6 6
3962 7 7
3963 8 8
3964 9 9
3965 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
3966 c1 c1
3967 0 0
3968 1 1
3969 2 2
3970 3 3
3971 4 4
3972 6 6
3973 7 7
3974 8 8
3975 9 9
3976 DROP TABLE t1,t2,t3,t4,t5,t6;
3977 CREATE TABLE t1 (c1 INT NOT NULL);
3978 CREATE TABLE t2 (c1 INT NOT NULL);
3979 CREATE TABLE t3 (c1 INT NOT NULL);
3980 CREATE TABLE t4 (c1 INT NOT NULL);
3981 CREATE TABLE t5 (c1 INT NOT NULL);
3982 CREATE TABLE t6 (c1 INT NOT NULL);
3983 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3984 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3985 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3986 INSERT INTO t4 (c1) VALUES(10);
3987 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3988 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
3989 c1 c1
3990 0 0
3991 1 1
3992 2 2
3993 3 3
3994 4 4
3995 5 5
3996 6 6
3997 7 7
3998 8 8
3999 9 9
4000 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4001 c1 c1
4002 0 0
4003 1 1
4004 2 2
4005 3 3
4006 4 4
4007 5 5
4008 6 6
4009 7 7
4010 8 8
4011 9 9
4012 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
4013 c1 c1
4014 0 0
4015 1 1
4016 2 2
4017 3 3
4018 4 4
4019 6 6
4020 7 7
4021 8 8
4022 9 9
4023 DROP TABLE t1,t2,t3,t4,t5,t6;
4024 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4025 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4026 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4027 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4028 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4029 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4030 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4031 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4032 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4033 INSERT INTO t4 (c1) VALUES(10);
4034 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4035 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4036 c1 c1
4037 0 0
4038 1 1
4039 2 2
4040 3 3
4041 4 4
4042 5 5
4043 6 6
4044 7 7
4045 8 8
4046 9 9
4047 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4048 c1 c1
4049 0 0
4050 1 1
4051 2 2
4052 3 3
4053 4 4
4054 5 5
4055 6 6
4056 7 7
4057 8 8
4058 9 9
4059 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
4060 c1 c1
4061 0 0
4062 1 1
4063 2 2
4064 3 3
4065 4 4
4066 6 6
4067 7 7
4068 8 8
4069 9 9
4070 DROP TABLE t1,t2,t3,t4,t5,t6;
4071 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4072 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4073 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4074 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4075 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4076 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4077 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4078 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4079 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4080 INSERT INTO t4 (c1) VALUES(10);
4081 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4082 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4083 c1 c1
4084 0 0
4085 1 1
4086 2 2
4087 3 3
4088 4 4
4089 5 5
4090 6 6
4091 7 7
4092 8 8
4093 9 9
4094 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4095 c1 c1
4096 0 0
4097 1 1
4098 2 2
4099 3 3
4100 4 4
4101 5 5
4102 6 6
4103 7 7
4104 8 8
4105 9 9
4106 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
4107 c1 c1
4108 0 0
4109 1 1
4110 2 2
4111 3 3
4112 4 4
4113 6 6
4114 7 7
4115 8 8
4116 9 9
4117 DROP TABLE t1,t2,t3,t4,t5,t6;
4118 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4119 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4120 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4121 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4122 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4123 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4124 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4125 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4126 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4127 INSERT INTO t4 (c1) VALUES(10);
4128 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4129 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4130 c1 c1
4131 1 1
4132 3 3
4133 5 5
4134 7 7
4135 9 9
4136 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4137 c1 c1
4138 1 1
4139 3 3
4140 5 5
4141 7 7
4142 9 9
4143 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4144 c1 c1
4145 1 1
4146 3 3
4147 7 7
4148 9 9
4149 DROP TABLE t1,t2,t3,t4,t5,t6;
4150 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4151 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4152 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4153 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4154 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4155 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4156 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4157 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4158 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4159 INSERT INTO t4 (c1) VALUES(10);
4160 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4161 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4162 c1 c1
4163 1 1
4164 3 3
4165 5 5
4166 7 7
4167 9 9
4168 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4169 c1 c1
4170 1 1
4171 3 3
4172 5 5
4173 7 7
4174 9 9
4175 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4176 c1 c1
4177 1 1
4178 3 3
4179 7 7
4180 9 9
4181 DROP TABLE t1,t2,t3,t4,t5,t6;
4182 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4183 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4184 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4185 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4186 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4187 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4188 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4189 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4190 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4191 INSERT INTO t4 (c1) VALUES(10);
4192 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4193 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4194 c1 c1
4195 1 1
4196 3 3
4197 5 5
4198 7 7
4199 9 9
4200 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4201 c1 c1
4202 1 1
4203 3 3
4204 5 5
4205 7 7
4206 9 9
4207 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4208 c1 c1
4209 1 1
4210 3 3
4211 7 7
4212 9 9
4213 DROP TABLE t1,t2,t3,t4,t5,t6;
4214 CREATE TABLE t1 (c1 INT NOT NULL);
4215 CREATE TABLE t2 (c1 INT NOT NULL);
4216 CREATE TABLE t3 (c1 INT NOT NULL);
4217 CREATE TABLE t4 (c1 INT NOT NULL);
4218 CREATE TABLE t5 (c1 INT NOT NULL);
4219 CREATE TABLE t6 (c1 INT NOT NULL);
4220 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4221 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4222 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4223 INSERT INTO t4 (c1) VALUES(10);
4224 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4225 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4226 c1 c1
4227 1 1
4228 3 3
4229 5 5
4230 7 7
4231 9 9
4232 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4233 c1 c1
4234 1 1
4235 3 3
4236 5 5
4237 7 7
4238 9 9
4239 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4240 c1 c1
4241 1 1
4242 3 3
4243 7 7
4244 9 9
4245 DROP TABLE t1,t2,t3,t4,t5,t6;
4246 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4247 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4248 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4249 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4250 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4251 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4252 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4253 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4254 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4255 INSERT INTO t4 (c1) VALUES(10);
4256 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4257 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4258 c1 c1
4259 1 1
4260 3 3
4261 5 5
4262 7 7
4263 9 9
4264 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4265 c1 c1
4266 1 1
4267 3 3
4268 5 5
4269 7 7
4270 9 9
4271 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4272 c1 c1
4273 1 1
4274 3 3
4275 7 7
4276 9 9
4277 DROP TABLE t1,t2,t3,t4,t5,t6;
4278 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4279 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4280 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4281 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4282 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4283 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4284 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4285 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4286 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4287 INSERT INTO t4 (c1) VALUES(10);
4288 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4289 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4290 c1 c1
4291 1 1
4292 3 3
4293 5 5
4294 7 7
4295 9 9
4296 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4297 c1 c1
4298 1 1
4299 3 3
4300 5 5
4301 7 7
4302 9 9
4303 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
4304 c1 c1
4305 1 1
4306 3 3
4307 7 7
4308 9 9
4309 DROP TABLE t1,t2,t3,t4,t5,t6;
4310 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4311 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4312 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4313 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4314 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4315 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4316 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4317 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4318 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4319 INSERT INTO t4 (c1) VALUES(10);
4320 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4321 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
4322 c1 c1
4323 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
4324 c1 c1
4325 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4326 c1 c1
4327 DROP TABLE t1,t2,t3,t4,t5,t6;
4328 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4329 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4330 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4331 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4332 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4333 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4334 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4335 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4336 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4337 INSERT INTO t4 (c1) VALUES(10);
4338 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4339 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
4340 c1 c1
4341 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
4342 c1 c1
4343 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4344 c1 c1
4345 DROP TABLE t1,t2,t3,t4,t5,t6;
4346 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4347 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4348 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4349 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4350 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4351 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4352 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4353 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4354 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4355 INSERT INTO t4 (c1) VALUES(10);
4356 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4357 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
4358 c1 c1
4359 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
4360 c1 c1
4361 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4362 c1 c1
4363 DROP TABLE t1,t2,t3,t4,t5,t6;
4364 CREATE TABLE t1 (c1 INT NOT NULL);
4365 CREATE TABLE t2 (c1 INT NOT NULL);
4366 CREATE TABLE t3 (c1 INT NOT NULL);
4367 CREATE TABLE t4 (c1 INT NOT NULL);
4368 CREATE TABLE t5 (c1 INT NOT NULL);
4369 CREATE TABLE t6 (c1 INT NOT NULL);
4370 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4371 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4372 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4373 INSERT INTO t4 (c1) VALUES(10);
4374 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4375 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
4376 c1 c1
4377 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
4378 c1 c1
4379 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4380 c1 c1
4381 DROP TABLE t1,t2,t3,t4,t5,t6;
4382 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4383 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4384 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4385 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4386 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4387 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4388 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4389 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4390 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4391 INSERT INTO t4 (c1) VALUES(10);
4392 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4393 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
4394 c1 c1
4395 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
4396 c1 c1
4397 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4398 c1 c1
4399 DROP TABLE t1,t2,t3,t4,t5,t6;
4400 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4401 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4402 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4403 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4404 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4405 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4406 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4407 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4408 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4409 INSERT INTO t4 (c1) VALUES(10);
4410 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4411 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
4412 c1 c1
4413 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
4414 c1 c1
4415 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
4416 c1 c1
4417 DROP TABLE t1,t2,t3,t4,t5,t6;
4418 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4419 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4420 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4421 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4422 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4423 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4424 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4425 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4426 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4427 INSERT INTO t4 (c1) VALUES(10);
4428 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4429 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
4430 c1 c1
4431 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
4432 c1 c1
4433 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4434 c1 c1
4435 DROP TABLE t1,t2,t3,t4,t5,t6;
4436 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4437 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4438 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4439 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4440 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4441 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4442 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4443 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4444 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4445 INSERT INTO t4 (c1) VALUES(10);
4446 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4447 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
4448 c1 c1
4449 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
4450 c1 c1
4451 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4452 c1 c1
4453 DROP TABLE t1,t2,t3,t4,t5,t6;
4454 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4455 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4456 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4457 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4458 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4459 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4460 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4461 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4462 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4463 INSERT INTO t4 (c1) VALUES(10);
4464 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4465 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
4466 c1 c1
4467 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
4468 c1 c1
4469 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4470 c1 c1
4471 DROP TABLE t1,t2,t3,t4,t5,t6;
4472 CREATE TABLE t1 (c1 INT NOT NULL);
4473 CREATE TABLE t2 (c1 INT NOT NULL);
4474 CREATE TABLE t3 (c1 INT NOT NULL);
4475 CREATE TABLE t4 (c1 INT NOT NULL);
4476 CREATE TABLE t5 (c1 INT NOT NULL);
4477 CREATE TABLE t6 (c1 INT NOT NULL);
4478 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4479 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4480 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4481 INSERT INTO t4 (c1) VALUES(10);
4482 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4483 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
4484 c1 c1
4485 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
4486 c1 c1
4487 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4488 c1 c1
4489 DROP TABLE t1,t2,t3,t4,t5,t6;
4490 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4491 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4492 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4493 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4494 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4495 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4496 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4497 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4498 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4499 INSERT INTO t4 (c1) VALUES(10);
4500 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4501 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
4502 c1 c1
4503 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
4504 c1 c1
4505 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4506 c1 c1
4507 DROP TABLE t1,t2,t3,t4,t5,t6;
4508 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4509 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4510 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4511 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4512 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4513 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4514 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4515 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4516 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4517 INSERT INTO t4 (c1) VALUES(10);
4518 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4519 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
4520 c1 c1
4521 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
4522 c1 c1
4523 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
4524 c1 c1
4525 DROP TABLE t1,t2,t3,t4,t5,t6;
4526 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4527 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4528 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4529 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4530 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4531 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4532 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4533 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4534 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4535 INSERT INTO t4 (c1) VALUES(10);
4536 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4537 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
4538 c1 c1
4539 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
4540 c1 c1
4541 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4542 c1 c1
4543 DROP TABLE t1,t2,t3,t4,t5,t6;
4544 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4545 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4546 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4547 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4548 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4549 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4550 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4551 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4552 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4553 INSERT INTO t4 (c1) VALUES(10);
4554 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4555 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
4556 c1 c1
4557 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
4558 c1 c1
4559 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4560 c1 c1
4561 DROP TABLE t1,t2,t3,t4,t5,t6;
4562 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4563 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4564 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4565 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4566 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4567 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4568 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4569 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4570 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4571 INSERT INTO t4 (c1) VALUES(10);
4572 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4573 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
4574 c1 c1
4575 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
4576 c1 c1
4577 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4578 c1 c1
4579 DROP TABLE t1,t2,t3,t4,t5,t6;
4580 CREATE TABLE t1 (c1 INT NOT NULL);
4581 CREATE TABLE t2 (c1 INT NOT NULL);
4582 CREATE TABLE t3 (c1 INT NOT NULL);
4583 CREATE TABLE t4 (c1 INT NOT NULL);
4584 CREATE TABLE t5 (c1 INT NOT NULL);
4585 CREATE TABLE t6 (c1 INT NOT NULL);
4586 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4587 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4588 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4589 INSERT INTO t4 (c1) VALUES(10);
4590 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4591 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
4592 c1 c1
4593 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
4594 c1 c1
4595 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4596 c1 c1
4597 DROP TABLE t1,t2,t3,t4,t5,t6;
4598 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4599 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4600 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4601 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4602 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4603 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4604 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4605 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4606 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4607 INSERT INTO t4 (c1) VALUES(10);
4608 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4609 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
4610 c1 c1
4611 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
4612 c1 c1
4613 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4614 c1 c1
4615 DROP TABLE t1,t2,t3,t4,t5,t6;
4616 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4617 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4618 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4619 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4620 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4621 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4622 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4623 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4624 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4625 INSERT INTO t4 (c1) VALUES(10);
4626 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4627 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
4628 c1 c1
4629 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
4630 c1 c1
4631 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
4632 c1 c1
4633 DROP TABLE t1,t2,t3,t4,t5,t6;
4634 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4635 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4636 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4637 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4638 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4639 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4640 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4641 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4642 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4643 INSERT INTO t4 (c1) VALUES(10);
4644 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4645 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4646 c1 c1
4647 0 0
4648 1 1
4649 2 2
4650 3 3
4651 4 4
4652 5 5
4653 6 6
4654 7 7
4655 8 8
4656 9 9
4657 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4658 c1 c1
4659 0 0
4660 1 1
4661 2 2
4662 3 3
4663 4 4
4664 5 5
4665 6 6
4666 7 7
4667 8 8
4668 9 9
4669 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4670 c1 c1
4671 5 5
4672 DROP TABLE t1,t2,t3,t4,t5,t6;
4673 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4674 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4675 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4676 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4677 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4678 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4679 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4680 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4681 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4682 INSERT INTO t4 (c1) VALUES(10);
4683 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4684 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4685 c1 c1
4686 0 0
4687 1 1
4688 2 2
4689 3 3
4690 4 4
4691 5 5
4692 6 6
4693 7 7
4694 8 8
4695 9 9
4696 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4697 c1 c1
4698 0 0
4699 1 1
4700 2 2
4701 3 3
4702 4 4
4703 5 5
4704 6 6
4705 7 7
4706 8 8
4707 9 9
4708 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4709 c1 c1
4710 5 5
4711 DROP TABLE t1,t2,t3,t4,t5,t6;
4712 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4713 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4714 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4715 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4716 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4717 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4718 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4719 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4720 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4721 INSERT INTO t4 (c1) VALUES(10);
4722 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4723 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4724 c1 c1
4725 0 0
4726 1 1
4727 2 2
4728 3 3
4729 4 4
4730 5 5
4731 6 6
4732 7 7
4733 8 8
4734 9 9
4735 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4736 c1 c1
4737 0 0
4738 1 1
4739 2 2
4740 3 3
4741 4 4
4742 5 5
4743 6 6
4744 7 7
4745 8 8
4746 9 9
4747 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4748 c1 c1
4749 5 5
4750 DROP TABLE t1,t2,t3,t4,t5,t6;
4751 CREATE TABLE t1 (c1 INT NOT NULL);
4752 CREATE TABLE t2 (c1 INT NOT NULL);
4753 CREATE TABLE t3 (c1 INT NOT NULL);
4754 CREATE TABLE t4 (c1 INT NOT NULL);
4755 CREATE TABLE t5 (c1 INT NOT NULL);
4756 CREATE TABLE t6 (c1 INT NOT NULL);
4757 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4758 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4759 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4760 INSERT INTO t4 (c1) VALUES(10);
4761 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4762 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4763 c1 c1
4764 0 0
4765 1 1
4766 2 2
4767 3 3
4768 4 4
4769 5 5
4770 6 6
4771 7 7
4772 8 8
4773 9 9
4774 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4775 c1 c1
4776 0 0
4777 1 1
4778 2 2
4779 3 3
4780 4 4
4781 5 5
4782 6 6
4783 7 7
4784 8 8
4785 9 9
4786 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4787 c1 c1
4788 5 5
4789 DROP TABLE t1,t2,t3,t4,t5,t6;
4790 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4791 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4792 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4793 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4794 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4795 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4796 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4797 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4798 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4799 INSERT INTO t4 (c1) VALUES(10);
4800 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4801 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4802 c1 c1
4803 0 0
4804 1 1
4805 2 2
4806 3 3
4807 4 4
4808 5 5
4809 6 6
4810 7 7
4811 8 8
4812 9 9
4813 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4814 c1 c1
4815 0 0
4816 1 1
4817 2 2
4818 3 3
4819 4 4
4820 5 5
4821 6 6
4822 7 7
4823 8 8
4824 9 9
4825 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4826 c1 c1
4827 5 5
4828 DROP TABLE t1,t2,t3,t4,t5,t6;
4829 CREATE TABLE t1 (c1 BIGINT NOT NULL);
4830 CREATE TABLE t2 (c1 BIGINT NOT NULL);
4831 CREATE TABLE t3 (c1 BIGINT NOT NULL);
4832 CREATE TABLE t4 (c1 BIGINT NOT NULL);
4833 CREATE TABLE t5 (c1 BIGINT NOT NULL);
4834 CREATE TABLE t6 (c1 BIGINT NOT NULL);
4835 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4836 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4837 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4838 INSERT INTO t4 (c1) VALUES(10);
4839 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4840 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
4841 c1 c1
4842 0 0
4843 1 1
4844 2 2
4845 3 3
4846 4 4
4847 5 5
4848 6 6
4849 7 7
4850 8 8
4851 9 9
4852 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
4853 c1 c1
4854 0 0
4855 1 1
4856 2 2
4857 3 3
4858 4 4
4859 5 5
4860 6 6
4861 7 7
4862 8 8
4863 9 9
4864 SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
4865 c1 c1
4866 5 5
4867 DROP TABLE t1,t2,t3,t4,t5,t6;
4868 CREATE TABLE t1 (c1 TINYINT NOT NULL);
4869 CREATE TABLE t2 (c1 TINYINT NOT NULL);
4870 CREATE TABLE t3 (c1 TINYINT NOT NULL);
4871 CREATE TABLE t4 (c1 TINYINT NOT NULL);
4872 CREATE TABLE t5 (c1 TINYINT NOT NULL);
4873 CREATE TABLE t6 (c1 TINYINT NOT NULL);
4874 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4875 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4876 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4877 INSERT INTO t4 (c1) VALUES(10);
4878 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4879 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4880 c1 c1
4881 1 1
4882 3 3
4883 5 5
4884 7 7
4885 9 9
4886 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4887 c1 c1
4888 1 1
4889 3 3
4890 5 5
4891 7 7
4892 9 9
4893 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4894 c1 c1
4895 5 5
4896 DROP TABLE t1,t2,t3,t4,t5,t6;
4897 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
4898 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
4899 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
4900 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
4901 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
4902 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
4903 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4904 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4905 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4906 INSERT INTO t4 (c1) VALUES(10);
4907 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4908 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4909 c1 c1
4910 1 1
4911 3 3
4912 5 5
4913 7 7
4914 9 9
4915 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4916 c1 c1
4917 1 1
4918 3 3
4919 5 5
4920 7 7
4921 9 9
4922 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4923 c1 c1
4924 5 5
4925 DROP TABLE t1,t2,t3,t4,t5,t6;
4926 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
4927 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
4928 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
4929 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
4930 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
4931 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
4932 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4933 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4934 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4935 INSERT INTO t4 (c1) VALUES(10);
4936 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4937 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4938 c1 c1
4939 1 1
4940 3 3
4941 5 5
4942 7 7
4943 9 9
4944 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4945 c1 c1
4946 1 1
4947 3 3
4948 5 5
4949 7 7
4950 9 9
4951 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4952 c1 c1
4953 5 5
4954 DROP TABLE t1,t2,t3,t4,t5,t6;
4955 CREATE TABLE t1 (c1 INT NOT NULL);
4956 CREATE TABLE t2 (c1 INT NOT NULL);
4957 CREATE TABLE t3 (c1 INT NOT NULL);
4958 CREATE TABLE t4 (c1 INT NOT NULL);
4959 CREATE TABLE t5 (c1 INT NOT NULL);
4960 CREATE TABLE t6 (c1 INT NOT NULL);
4961 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4962 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4963 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4964 INSERT INTO t4 (c1) VALUES(10);
4965 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4966 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4967 c1 c1
4968 1 1
4969 3 3
4970 5 5
4971 7 7
4972 9 9
4973 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
4974 c1 c1
4975 1 1
4976 3 3
4977 5 5
4978 7 7
4979 9 9
4980 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
4981 c1 c1
4982 5 5
4983 DROP TABLE t1,t2,t3,t4,t5,t6;
4984 CREATE TABLE t1 (c1 INTEGER NOT NULL);
4985 CREATE TABLE t2 (c1 INTEGER NOT NULL);
4986 CREATE TABLE t3 (c1 INTEGER NOT NULL);
4987 CREATE TABLE t4 (c1 INTEGER NOT NULL);
4988 CREATE TABLE t5 (c1 INTEGER NOT NULL);
4989 CREATE TABLE t6 (c1 INTEGER NOT NULL);
4990 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4991 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4992 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
4993 INSERT INTO t4 (c1) VALUES(10);
4994 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
4995 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
4996 c1 c1
4997 1 1
4998 3 3
4999 5 5
5000 7 7
5001 9 9
5002 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
5003 c1 c1
5004 1 1
5005 3 3
5006 5 5
5007 7 7
5008 9 9
5009 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
5010 c1 c1
5011 5 5
5012 DROP TABLE t1,t2,t3,t4,t5,t6;
5013 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5014 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5015 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5016 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5017 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5018 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5019 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5020 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5021 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5022 INSERT INTO t4 (c1) VALUES(10);
5023 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5024 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
5025 c1 c1
5026 1 1
5027 3 3
5028 5 5
5029 7 7
5030 9 9
5031 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
5032 c1 c1
5033 1 1
5034 3 3
5035 5 5
5036 7 7
5037 9 9
5038 SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
5039 c1 c1
5040 5 5
5041 DROP TABLE t1,t2,t3,t4,t5,t6;
5042 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5043 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5044 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5045 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5046 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5047 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5048 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5049 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5050 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5051 INSERT INTO t4 (c1) VALUES(10);
5052 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5053 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
5054 c1 c1
5055 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
5056 c1 c1
5057 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5058 c1 c1
5059 DROP TABLE t1,t2,t3,t4,t5,t6;
5060 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5061 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5062 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5063 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5064 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5065 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5066 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5067 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5068 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5069 INSERT INTO t4 (c1) VALUES(10);
5070 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5071 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
5072 c1 c1
5073 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
5074 c1 c1
5075 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5076 c1 c1
5077 DROP TABLE t1,t2,t3,t4,t5,t6;
5078 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5079 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5080 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5081 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5082 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5083 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5084 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5085 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5086 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5087 INSERT INTO t4 (c1) VALUES(10);
5088 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5089 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
5090 c1 c1
5091 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
5092 c1 c1
5093 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5094 c1 c1
5095 DROP TABLE t1,t2,t3,t4,t5,t6;
5096 CREATE TABLE t1 (c1 INT NOT NULL);
5097 CREATE TABLE t2 (c1 INT NOT NULL);
5098 CREATE TABLE t3 (c1 INT NOT NULL);
5099 CREATE TABLE t4 (c1 INT NOT NULL);
5100 CREATE TABLE t5 (c1 INT NOT NULL);
5101 CREATE TABLE t6 (c1 INT NOT NULL);
5102 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5103 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5104 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5105 INSERT INTO t4 (c1) VALUES(10);
5106 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5107 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
5108 c1 c1
5109 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
5110 c1 c1
5111 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5112 c1 c1
5113 DROP TABLE t1,t2,t3,t4,t5,t6;
5114 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5115 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5116 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5117 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5118 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5119 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5120 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5121 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5122 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5123 INSERT INTO t4 (c1) VALUES(10);
5124 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5125 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
5126 c1 c1
5127 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
5128 c1 c1
5129 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5130 c1 c1
5131 DROP TABLE t1,t2,t3,t4,t5,t6;
5132 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5133 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5134 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5135 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5136 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5137 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5138 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5139 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5140 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5141 INSERT INTO t4 (c1) VALUES(10);
5142 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5143 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
5144 c1 c1
5145 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
5146 c1 c1
5147 SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
5148 c1 c1
5149 DROP TABLE t1,t2,t3,t4,t5,t6;
5150 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5151 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5152 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5153 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5154 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5155 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5156 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5157 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5158 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5159 INSERT INTO t4 (c1) VALUES(10);
5160 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5161 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
5162 c1 c1
5163 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
5164 c1 c1
5165 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5166 c1 c1
5167 DROP TABLE t1,t2,t3,t4,t5,t6;
5168 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5169 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5170 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5171 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5172 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5173 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5174 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5175 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5176 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5177 INSERT INTO t4 (c1) VALUES(10);
5178 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5179 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
5180 c1 c1
5181 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
5182 c1 c1
5183 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5184 c1 c1
5185 DROP TABLE t1,t2,t3,t4,t5,t6;
5186 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5187 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5188 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5189 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5190 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5191 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5192 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5193 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5194 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5195 INSERT INTO t4 (c1) VALUES(10);
5196 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5197 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
5198 c1 c1
5199 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
5200 c1 c1
5201 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5202 c1 c1
5203 DROP TABLE t1,t2,t3,t4,t5,t6;
5204 CREATE TABLE t1 (c1 INT NOT NULL);
5205 CREATE TABLE t2 (c1 INT NOT NULL);
5206 CREATE TABLE t3 (c1 INT NOT NULL);
5207 CREATE TABLE t4 (c1 INT NOT NULL);
5208 CREATE TABLE t5 (c1 INT NOT NULL);
5209 CREATE TABLE t6 (c1 INT NOT NULL);
5210 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5211 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5212 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5213 INSERT INTO t4 (c1) VALUES(10);
5214 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5215 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
5216 c1 c1
5217 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
5218 c1 c1
5219 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5220 c1 c1
5221 DROP TABLE t1,t2,t3,t4,t5,t6;
5222 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5223 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5224 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5225 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5226 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5227 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5228 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5229 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5230 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5231 INSERT INTO t4 (c1) VALUES(10);
5232 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5233 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
5234 c1 c1
5235 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
5236 c1 c1
5237 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5238 c1 c1
5239 DROP TABLE t1,t2,t3,t4,t5,t6;
5240 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5241 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5242 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5243 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5244 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5245 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5246 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5247 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5248 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5249 INSERT INTO t4 (c1) VALUES(10);
5250 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5251 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
5252 c1 c1
5253 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
5254 c1 c1
5255 SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
5256 c1 c1
5257 DROP TABLE t1,t2,t3,t4,t5,t6;
5258 CREATE TABLE t1 (c1 TINYINT NOT NULL);
5259 CREATE TABLE t2 (c1 TINYINT NOT NULL);
5260 CREATE TABLE t3 (c1 TINYINT NOT NULL);
5261 CREATE TABLE t4 (c1 TINYINT NOT NULL);
5262 CREATE TABLE t5 (c1 TINYINT NOT NULL);
5263 CREATE TABLE t6 (c1 TINYINT NOT NULL);
5264 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5265 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5266 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5267 INSERT INTO t4 (c1) VALUES(10);
5268 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5269 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
5270 c1 c1
5271 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
5272 c1 c1
5273 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5274 c1 c1
5275 DROP TABLE t1,t2,t3,t4,t5,t6;
5276 CREATE TABLE t1 (c1 SMALLINT NOT NULL);
5277 CREATE TABLE t2 (c1 SMALLINT NOT NULL);
5278 CREATE TABLE t3 (c1 SMALLINT NOT NULL);
5279 CREATE TABLE t4 (c1 SMALLINT NOT NULL);
5280 CREATE TABLE t5 (c1 SMALLINT NOT NULL);
5281 CREATE TABLE t6 (c1 SMALLINT NOT NULL);
5282 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5283 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5284 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5285 INSERT INTO t4 (c1) VALUES(10);
5286 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5287 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
5288 c1 c1
5289 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
5290 c1 c1
5291 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5292 c1 c1
5293 DROP TABLE t1,t2,t3,t4,t5,t6;
5294 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
5295 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
5296 CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
5297 CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
5298 CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
5299 CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
5300 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5301 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5302 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5303 INSERT INTO t4 (c1) VALUES(10);
5304 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5305 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
5306 c1 c1
5307 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
5308 c1 c1
5309 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5310 c1 c1
5311 DROP TABLE t1,t2,t3,t4,t5,t6;
5312 CREATE TABLE t1 (c1 INT NOT NULL);
5313 CREATE TABLE t2 (c1 INT NOT NULL);
5314 CREATE TABLE t3 (c1 INT NOT NULL);
5315 CREATE TABLE t4 (c1 INT NOT NULL);
5316 CREATE TABLE t5 (c1 INT NOT NULL);
5317 CREATE TABLE t6 (c1 INT NOT NULL);
5318 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5319 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5320 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5321 INSERT INTO t4 (c1) VALUES(10);
5322 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5323 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
5324 c1 c1
5325 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
5326 c1 c1
5327 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5328 c1 c1
5329 DROP TABLE t1,t2,t3,t4,t5,t6;
5330 CREATE TABLE t1 (c1 INTEGER NOT NULL);
5331 CREATE TABLE t2 (c1 INTEGER NOT NULL);
5332 CREATE TABLE t3 (c1 INTEGER NOT NULL);
5333 CREATE TABLE t4 (c1 INTEGER NOT NULL);
5334 CREATE TABLE t5 (c1 INTEGER NOT NULL);
5335 CREATE TABLE t6 (c1 INTEGER NOT NULL);
5336 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5337 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5338 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5339 INSERT INTO t4 (c1) VALUES(10);
5340 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5341 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
5342 c1 c1
5343 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
5344 c1 c1
5345 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5346 c1 c1
5347 DROP TABLE t1,t2,t3,t4,t5,t6;
5348 CREATE TABLE t1 (c1 BIGINT NOT NULL);
5349 CREATE TABLE t2 (c1 BIGINT NOT NULL);
5350 CREATE TABLE t3 (c1 BIGINT NOT NULL);
5351 CREATE TABLE t4 (c1 BIGINT NOT NULL);
5352 CREATE TABLE t5 (c1 BIGINT NOT NULL);
5353 CREATE TABLE t6 (c1 BIGINT NOT NULL);
5354 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5355 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5356 INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
5357 INSERT INTO t4 (c1) VALUES(10);
5358 INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
5359 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
5360 c1 c1
5361 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
5362 c1 c1
5363 SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
5364 c1 c1
5365 DROP TABLE t1,t2,t3,t4,t5,t6;