[
https://issues.apache.org/jira/browse/CALCITE-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Mior updated CALCITE-1648:
----------------------------------
Fix Version/s: 1.14.0
> 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
> Fix For: 1.14.0
>
>
> 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.4.14#64029)
