You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Samuel Waggoner (JIRA)" <ji...@apache.org> on 2018/01/29 23:28:00 UTC

[jira] [Created] (CALCITE-2153) SQL parser fails to parse valid triply nested join query

Samuel Waggoner created CALCITE-2153:
----------------------------------------

             Summary: SQL parser fails to parse valid triply nested join query
                 Key: CALCITE-2153
                 URL: https://issues.apache.org/jira/browse/CALCITE-2153
             Project: Calcite
          Issue Type: Bug
            Reporter: Samuel Waggoner
            Assignee: Julian Hyde


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