[
https://issues.apache.org/jira/browse/CALCITE-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-1648.
----------------------------------
Resolution: Duplicate
This is a duplicate of CALCITE-35. I would like to fix this (and also
parenthesized UNION, INTERSECT and MINUS queries) but for reasons explained in
that issue, it is hard to do without a major re-work of the parser.
> Cannot use parentheses after FROM in SQL
> ----------------------------------------
>
> Key: CALCITE-1648
> URL: https://issues.apache.org/jira/browse/CALCITE-1648
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.11.0
> Reporter: Dong Li
> Assignee: Julian Hyde
> Priority: Minor
>
> Some BI tools will generate some SQLs like this:
> {code}SELECT COUNT(*) FROM (emps LEFT OUTER JOIN depts ON emps.deptno =
> depts.deptno);{code}
> In this SQL, the FROM clause is contained within parentheses.
> But always failed with such exception:
> {noformat}Error: Error while executing SQL "SELECT COUNT(*) FROM (emps LEFT
> OUTER JOIN depts ON emps.deptno = depts.deptno)": parse failed: Non-query
> expression encountered in illegal context (state=,code=0){noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
