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)
