inputs/udf/udf-natural-join.sql

0001 -- This test file was converted from natural-join.sql.
0002
0003 create temporary view nt1 as select * from values
0004   ("one", 1),
0005   ("two", 2),
0006   ("three", 3)
0007   as nt1(k, v1);
0008
0009 create temporary view nt2 as select * from values
0010   ("one", 1),
0011   ("two", 22),
0012   ("one", 5)
0013   as nt2(k, v2);
0014
0015
0016 SELECT * FROM nt1 natural join nt2 where udf(k) = "one";
0017
0018 SELECT * FROM nt1 natural left join nt2 where k <> udf("") order by v1, v2;
0019
0020 SELECT * FROM nt1 natural right join nt2 where udf(k) <> udf("") order by v1, v2;
0021
0022 SELECT udf(count(*)) FROM nt1 natural full outer join nt2;