You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2015/09/16 22:05:46 UTC
[jira] [Created] (CALCITE-886) Calcite hits SqlValidatorException
when group by clause has system functions
Jinfeng Ni created CALCITE-886:
----------------------------------
Summary: 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: Jinfeng Ni
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)