I'll replace the VALUES subqueries with tables and indent to make the
intended operator precedence clearer:
SELECT *
FROM customer
LEFT OUTER JOIN orders
INNER JOIN lineitem
ON o_orderkey = l_orderkey
ON c_custkey = o_custkey
Since 1.31 [1] we support parenthesized joins,
Thank you for looking at this Julian. To be clear, I’m asking if this
statement should be supported or not. I’m not suggesting that it should be.
Hopefully this formatting is easier to read:
SELECT *
FROM (
VALUES (1,
'John')) AS "customer"(c_custkey,
What is 'this syntax' you think we should support? (Your query is
poorly formatted, so I can't see what pattern in it is confusing the
parser.)
On Tue, Jan 2, 2024 at 11:46 AM Sean Broeder wrote:
>
> It looks like Calcite doesn't support the query
>
> select * from (values (1, 'John')) as
>
>
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