0001 CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a);
0002 CREATE TEMPORARY VIEW t2 AS SELECT * FROM VALUES (1) AS GROUPING(a);
0003
0004 CREATE TEMPORARY VIEW empty_table as SELECT a FROM t2 WHERE false;
0005
0006 SELECT * FROM t1 INNER JOIN empty_table;
0007 SELECT * FROM t1 CROSS JOIN empty_table;
0008 SELECT * FROM t1 LEFT OUTER JOIN empty_table;
0009 SELECT * FROM t1 RIGHT OUTER JOIN empty_table;
0010 SELECT * FROM t1 FULL OUTER JOIN empty_table;
0011 SELECT * FROM t1 LEFT SEMI JOIN empty_table;
0012 SELECT * FROM t1 LEFT ANTI JOIN empty_table;
0013
0014 SELECT * FROM empty_table INNER JOIN t1;
0015 SELECT * FROM empty_table CROSS JOIN t1;
0016 SELECT * FROM empty_table LEFT OUTER JOIN t1;
0017 SELECT * FROM empty_table RIGHT OUTER JOIN t1;
0018 SELECT * FROM empty_table FULL OUTER JOIN t1;
0019 SELECT * FROM empty_table LEFT SEMI JOIN t1;
0020 SELECT * FROM empty_table LEFT ANTI JOIN t1;
0021
0022 SELECT * FROM empty_table INNER JOIN empty_table;
0023 SELECT * FROM empty_table CROSS JOIN empty_table;
0024 SELECT * FROM empty_table LEFT OUTER JOIN empty_table;
0025 SELECT * FROM empty_table RIGHT OUTER JOIN empty_table;
0026 SELECT * FROM empty_table FULL OUTER JOIN empty_table;
0027 SELECT * FROM empty_table LEFT SEMI JOIN empty_table;
0028 SELECT * FROM empty_table LEFT ANTI JOIN empty_table;
