inputs/udf/udf-inner-join.sql

0001 -- This test file was converted from inner-join.sql.
0002 CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a);
0003 CREATE TEMPORARY VIEW t2 AS SELECT * FROM VALUES (1) AS GROUPING(a);
0004 CREATE TEMPORARY VIEW t3 AS SELECT * FROM VALUES (1), (1) AS GROUPING(a);
0005 CREATE TEMPORARY VIEW t4 AS SELECT * FROM VALUES (1), (1) AS GROUPING(a);
0006
0007 CREATE TEMPORARY VIEW ta AS
0008 SELECT udf(a) AS a, udf('a') AS tag FROM t1
0009 UNION ALL
0010 SELECT udf(a) AS a, udf('b') AS tag FROM t2;
0011
0012 CREATE TEMPORARY VIEW tb AS
0013 SELECT udf(a) AS a, udf('a') AS tag FROM t3
0014 UNION ALL
0015 SELECT udf(a) AS a, udf('b') AS tag FROM t4;
0016
0017 SELECT tb.* FROM ta INNER JOIN tb ON ta.a = tb.a AND ta.tag = tb.tag;