[ https://issues.apache.org/jira/browse/CALCITE-35?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838007#comment-16838007 ]
Hongze Zhang edited comment on CALCITE-35 at 5/12/19 9:21 AM: -------------------------------------------------------------- Thanks Muhammad. I think the case should work properly this time. However the syntactic lookahead {{LOOKAHEAD(TableRef())}} brings quadratic behavior (O(n^2)) in parsing. Do we have chance to reduce it back to liner (O\(n\))? I suppose this was one of the main problems that block our effort on solving this issue before. was (Author: zhztheplayer): Thanks Muhammad. I think the case should work properly this time. However the syntactic lookahead {{LOOKAHEAD(TableRef())}} brings quadratic behavior (O(n^2)) in parsing. Do we have chance to reduce it back to liner (O(n))? I suppose this was one of the main problems that block our effort on solving this issue before. > 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)