[CALCITE-1648] Cannot use parentheses after FROM in SQL

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.11.0
• Fix Version/s: 1.14.0
• Assignee: Julian Hyde
• Reporter: Dong Li
• Created: 20/Feb/17 07:19
• Updated: 05/Oct/17 20:51
• Resolved: 21/Feb/17 01:32

Description

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)

Issue Links

• duplicates: CALCITE-35 Support parenthesized sub-clause in JOIN