It looks like Calcite doesn't support the query
select * from (values (1, 'John')) as
"customer"(c_custkey, c_name)
left outer join (values(100, 1)) as "orders"(o_orderkey, o_custkey)
inner join (values (100, 'Random item')) as "lineitem"(l_orderkey,
l_itemname) on o_orderkey = l_orderkey
on c_custkey = o_custkey
I'm seeing a parser error
on c_custkey = o_custkey": parse failed: Encountered "on" at line 5, column
1.
Was expecting one of:
<EOF>
"EXCEPT" ...
Should this syntax be supported?
It looks like this syntax is supported by at least postgres and sqlserver.
Thanks!
