[jira] [Updated] (CALCITE-1648) Cannot use parentheses after FROM in SQL

["Michael Mior (JIRA)" <ji...@apache.org>]

     [ 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)