[jira] [Updated] (CALCITE-886) Calcite hits SqlValidatorException when group by clause has system functions

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jinfeng Ni updated CALCITE-886:
-------------------------------
    Assignee: Julian Hyde  (was: Jinfeng Ni)

> Calcite hits SqlValidatorException when group by clause has system functions
> ----------------------------------------------------------------------------
>
>                 Key: CALCITE-886
>                 URL: https://issues.apache.org/jira/browse/CALCITE-886
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Jinfeng Ni
>            Assignee: Julian Hyde
>
> The system functions are the ones that do not have parentheses, like CURRENT_DATE, CURRENT_TIME, CURRENT_USER, etc.
> When such functions appear in the group by clause, Calcite will hit SqlValidatorException, complaining the column with the function name could not be found in any table.
> For instance,
> {code}
> select CURRENT_USER from SCOTT.EMP GROUP BY CURRENT_USER;
> org.apache.calcite.sql.validate.SqlValidatorException <init>
> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Column 'CURRENT_USER' not found in any table
> {code}
> This query runs perfectly fine.
> {code}
> select CURRENT_USER from SCOTT.EMP limit 1;
> {code}
> Looks like the sql validation logic for group by clause could not recognize SqlIdentifier which may represent a function w/o parentheses.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)