[jira] [Updated] (CALCITE-2153) SQL parser fails to parse valid multi nested join subqueries

["Samuel Waggoner (JIRA)" <ji...@apache.org>]

     [ 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)