[
https://issues.apache.org/jira/browse/CALCITE-886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-886:
--------------------------------
Summary: System functions in GROUP BY clause (was: Calcite hits
SqlValidatorException when group by clause has system functions)
> System functions in GROUP BY clause
> -----------------------------------
>
> 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)
