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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.19.0
• Component/s: core
• Labels: github-import pull-request-available
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 07:51
• Updated: 16/May/22 03:49

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

• is duplicated by: CALCITE-5042 Incorrect syntax in sub-query
• is duplicated by: CALCITE-4961 Add support for parenthesis-wrapped joined tables
• 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-1648 Cannot use parentheses after FROM in SQL
• is duplicated by: CALCITE-3463 Parse SQL Query - Non-query expression encountered in illegal context
• is duplicated by: CALCITE-3051 Babel parser should parse special table expressions
• is related to: CALCITE-2152 SQL parser unable to parse SQL with nested joins produced by RelToSqlConverter
• links to: GitHub Pull Request #1204
• links to: GitHub Pull Request #1228