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

[Vladimir Kolesnikov]

=== modified file 'ChangeLog'
--- ChangeLog	2009-06-17 14:18:18 +0000
+++ ChangeLog	2009-06-23 16:07:06 +0000
@@ -3,6 +3,8 @@
 
 ------- 1.0.08 RC - Not yet released
 
+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.
+
 RN248: PBXT now compiles and runs with MySQL 5.1.35. All tests pass.
 
 RN247: Fixed bug #369086: Incosistent/Incorrect Truncate behavior
 
=== modified file 'src/ha_pbxt.cc'
--- src/ha_pbxt.cc	2009-06-16 10:21:52 +0000
+++ src/ha_pbxt.cc	2009-06-23 16:07:06 +0000
@@ -3227,6 +3227,21 @@
 	XT_PRINT1(pb_open_tab->ot_thread, "ha_pbxt::rnd_init %s\n", pb_share->sh_table_path->ps_path);
 	XT_DISABLED_TRACE(("seq scan tx=%d\n", (int) pb_open_tab->ot_thread->st_xact_data->xd_start_xn_id));
 
+	/* Call xt_tab_seq_exit() to make sure the resources used by the previous
+	 * scan are freed. In particular make sure cache page ref count is decremented.
+	 * This is needed as rnd_init() can be called mulitple times w/o matching calls 
+	 * to rnd_end(). Our experience is that currently this is done in queries like:
+	 *
+	 * SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
+	 * UPDATE t1 LEFT JOIN t2 USING (c1) SET t1.c1 = t2.c1 WHERE t1.c1 = t2.c1;
+	 *
+	 * when scanning inner tables. It is important to understand that in such case
+	 * multiple calls to rnd_init() are not semantically equal to a new query. For
+	 * example we cannot make row locks permanent as we do in rnd_end(), as 
+	 * ha_pbxt::unlock_row still can be called.
+	 */
+	xt_tab_seq_exit(pb_open_tab);
+
 	/* The number of columns required: */
 	if (pb_open_tab->ot_is_modify)
 		pb_open_tab->ot_cols_req = table->read_set->MX_BIT_SIZE();
 
=== modified file 'src/table_xt.cc'
--- src/table_xt.cc	2009-06-16 11:35:57 +0000
+++ src/table_xt.cc	2009-06-23 16:07:06 +0000
@@ -2338,6 +2338,9 @@
 		return NULL;
 	memset(ot, 0, offsetof(XTOpenTableRec, ot_ind_wbuf));
 
+	ot->ot_seq_page = NULL;
+	ot->ot_seq_data = NULL;
+
 	self = xt_get_self();
 	try_(a) {
 		xt_heap_reference(self, tab);
 
=== added file 'test/mysql-test/r/se_join_cross.result'
--- test/mysql-test/r/se_join_cross.result	1970-01-01 00:00:00 +0000
+++ test/mysql-test/r/se_join_cross.result	2009-06-23 16:07:06 +0000
@@ -0,0 +1,5365 @@
+DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
+c1	c1
+1	1
+3	3
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
+c1	c1
+1	1
+3	3
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
+c1	c1
+1	1
+3	3
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
+c1	c1
+1	1
+3	3
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
+c1	c1
+1	1
+3	3
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
+c1	c1
+1	1
+3	3
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
+c1	c1
+1	1
+3	3
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
+c1	c1
+1	1
+3	3
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
+c1	c1
+1	1
+3	3
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
+c1	c1
+1	1
+3	3
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
+c1	c1
+1	1
+3	3
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
+c1	c1
+1	1
+3	3
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
+c1	c1
+5	5
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+6	6
+7	7
+8	8
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
+c1	c1
+1	1
+3	3
+7	7
+9	9
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 USING (c1);
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1;
+c1	c1
+SELECT t1.c1,t4.c1 FROM t1 CROSS JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 USING (c1);
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1;
+c1	c1
+SELECT t1.c1,t5.c1 FROM t1 CROSS JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 USING (c1);
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1;
+c1	c1
+SELECT t1.c1,t6.c1 FROM t1 CROSS JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
+c1	c1
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INT NOT NULL);
+CREATE TABLE t2 (c1 INT NOT NULL);
+CREATE TABLE t3 (c1 INT NOT NULL);
+CREATE TABLE t4 (c1 INT NOT NULL);
+CREATE TABLE t5 (c1 INT NOT NULL);
+CREATE TABLE t6 (c1 INT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 INTEGER NOT NULL);
+CREATE TABLE t2 (c1 INTEGER NOT NULL);
+CREATE TABLE t3 (c1 INTEGER NOT NULL);
+CREATE TABLE t4 (c1 INTEGER NOT NULL);
+CREATE TABLE t5 (c1 INTEGER NOT NULL);
+CREATE TABLE t6 (c1 INTEGER NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 BIGINT NOT NULL);
+CREATE TABLE t2 (c1 BIGINT NOT NULL);
+CREATE TABLE t3 (c1 BIGINT NOT NULL);
+CREATE TABLE t4 (c1 BIGINT NOT NULL);
+CREATE TABLE t5 (c1 BIGINT NOT NULL);
+CREATE TABLE t6 (c1 BIGINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 USING (c1);
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1;
+c1	c1
+0	0
+1	1
+2	2
+3	3
+4	4
+5	5
+6	6
+7	7
+8	8
+9	9
+SELECT t1.c1,t2.c1 FROM t1 CROSS JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 TINYINT NOT NULL);
+CREATE TABLE t2 (c1 TINYINT NOT NULL);
+CREATE TABLE t3 (c1 TINYINT NOT NULL);
+CREATE TABLE t4 (c1 TINYINT NOT NULL);
+CREATE TABLE t5 (c1 TINYINT NOT NULL);
+CREATE TABLE t6 (c1 TINYINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 SMALLINT NOT NULL);
+CREATE TABLE t2 (c1 SMALLINT NOT NULL);
+CREATE TABLE t3 (c1 SMALLINT NOT NULL);
+CREATE TABLE t4 (c1 SMALLINT NOT NULL);
+CREATE TABLE t5 (c1 SMALLINT NOT NULL);
+CREATE TABLE t6 (c1 SMALLINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1;
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
+c1	c1
+5	5
+DROP TABLE t1,t2,t3,t4,t5,t6;
+CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
+CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
+INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
+INSERT INTO t4 (c1) VALUES(10);
+INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
+SELECT t1.c1,t3.c1 FROM t1 CROSS JOIN t3 USING (c1);
+c1	c1
+1	1
+3	3
+5	5
+7	7
+9	9