[
https://issues.apache.org/jira/browse/CALCITE-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1648:
---------------------------------
Description:
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}
was:
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)
> 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)
