[CALCITE-35] Support parenthesized sub-clause in JOIN

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: github-import pull-request-available
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 07:51
• Updated: 12/Aug/22 22:59
• Resolved: 01/Jun/22 22:13

Description

SQL-92 allows joins to be grouped into trees using parentheses. For example,

select * from a join (b join c on b.x = c.x) on a.y = c.y

Optiq should support this. Currently this gives "org.eigenbase.util.EigenbaseException: Non-query expression encountered in illegal context".

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/35
Created by: julianhyde
Labels:
Created at: Fri Apr 19 02:46:01 CEST 2013
State: open

Issue Links

• causes: CALCITE-5194 Cannot parse parenthesized UNION in subquery
• is duplicated by: CALCITE-5042 Incorrect syntax in sub-query
• is duplicated by: CALCITE-2981 Syntax error with simple nested select query
• is duplicated by: CALCITE-2153 SQL parser fails to parse valid multi nested join subqueries
• is duplicated by: CALCITE-4961 Add support for parenthesis-wrapped joined tables
• is duplicated by: CALCITE-1648 Cannot use parentheses after FROM in SQL
• is duplicated by: CALCITE-3051 Babel parser should parse special table expressions
• is duplicated by: CALCITE-3463 Parse SQL Query - Non-query expression encountered in illegal context
• is related to: CALCITE-2152 SQL parser unable to parse SQL with nested joins produced by RelToSqlConverter
• relates to: CALCITE-5168 Allow AS after parenthesized JOIN
• relates to: CALCITE-5233 Support for SQL syntax with parenthesis for outer join associativity
• links to: GitHub Pull Request #1204
• links to: GitHub Pull Request #1228
• links to: GitHub Pull Request #2820