[
https://issues.apache.org/jira/browse/CALCITE-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dong Li updated CALCITE-1648:
-----------------------------
Summary: Cannot use parentheses after FROM in SQL (was: Cannot use
parentheses after FROM)
> 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:
> SELECT COUNT(*) FROM (emps LEFT OUTER JOIN depts ON emps.deptno =
> depts.deptno);
> In this SQL, the FROM clause is contained within parentheses.
> But always failed with such exception:
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
