[ https://issues.apache.org/jira/browse/CALCITE-2153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Samuel Waggoner updated CALCITE-2153: ------------------------------------- Summary: SQL parser fails to parse valid multi nested join subqueries (was: SQL parser fails to parse valid triply nested join query) > SQL parser fails to parse valid multi nested join subqueries > ------------------------------------------------------------ > > Key: CALCITE-2153 > URL: https://issues.apache.org/jira/browse/CALCITE-2153 > Project: Calcite > Issue Type: Bug > Reporter: Samuel Waggoner > Assignee: Julian Hyde > Priority: Major > > {code:java} > @Test public void testInnerJoinOnSubqueryWithAggregation() { > final String sql = "select *\n" > + "from table1 \n" > + "inner join (( \n" > + " select * \n" > + " from table2 ) \n" > + " inner join ( \n" > + " select * \n" > + " from table3) \n" > + " on table2.field1 = table3.field1) \n" > + "on table1.field1 = table2.field1 \n"; > sql(sql).ok(""); > }{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)