Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.19.0
-
None
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
Attachments
Issue Links
- is duplicated by
-
CALCITE-5042 Incorrect syntax in sub-query
-
- Resolved
-
-
CALCITE-4961 Add support for parenthesis-wrapped joined tables
-
- Resolved
-
-
CALCITE-2981 Syntax error with simple nested select query
-
- Closed
-
-
CALCITE-2153 SQL parser fails to parse valid multi nested join subqueries
-
- Closed
-
-
CALCITE-1648 Cannot use parentheses after FROM in SQL
-
- Closed
-
-
CALCITE-3463 Parse SQL Query - Non-query expression encountered in illegal context
-
- Resolved
-
-
CALCITE-3051 Babel parser should parse special table expressions
-
- Closed
-
- is related to
-
CALCITE-2152 SQL parser unable to parse SQL with nested joins produced by RelToSqlConverter
-
- Open
-
- links to