Dong Li created CALCITE-1648:
--------------------------------
Summary: Cannot use parentheses after FROM
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)
