yql/essentials/tests/sql/suites/join/left_null_literal.sql


1
2
3
4
5
6
7
8

/* syntax version 1 */
use plato;

$foo = [<|"x":1|>];
$bar = [<|"x":1, "y":Null|>];

insert into Output
select * from AS_TABLE($foo) as a LEFT JOIN AS_TABLE($bar) as b USING(x);