[ https://issues.apache.org/jira/browse/CALCITE-35?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838041#comment-16838041 ]
Muhammad Gelbana commented on CALCITE-35: ----------------------------------------- I tried a couple of things but none worked. {{LOOKAHEAD(left = TableRef())}} and {{LOOKAHEAD(AtomicTableRef(atomicReferenceToLeft))}} where {{AtomicTableRef}} is a new production that still returns an {{SqlNode}} but also accepts an atomic reference to set the consumed {{SqlNode}} to it before returning the same {{SqlNode}} to be detected by the {{LOOKAHEAD}}. > Support parenthesized sub-clause in JOIN > ---------------------------------------- > > Key: CALCITE-35 > URL: https://issues.apache.org/jira/browse/CALCITE-35 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.19.0 > Reporter: GitHub Import > Priority: Major > Labels: github-import, pull-request-available > Time Spent: 50m > Remaining Estimate: 0h > > 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|https://github.com/julianhyde] > Labels: > Created at: Fri Apr 19 02:46:01 CEST 2013 > State: open -- This message was sent by Atlassian JIRA (v7.6.3#76005)