PBXT

Merge lp:~vkolesnikov/pbxt/pbxt-bug-313176 into lp:pbxt

  1. pbxt-bug-313176
  2. Merge into trunk
Proposed by Vladimir Kolesnikov
Status: Merged
Merged at revision: not available
Proposed branch: lp:~vkolesnikov/pbxt/pbxt-bug-313176
Merge into: lp:pbxt
Diff against target: None lines
To merge this branch: bzr merge lp:~vkolesnikov/pbxt/pbxt-bug-313176
Reviewer Review Type Date Requested Status
PBXT Core Pending
Review via email: mp+7806@code.launchpad.net
To post a comment you must log in.

Preview Diff

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

Subscribers

People subscribed via source and target branches