You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2021/03/25 04:08:00 UTC

[jira] [Updated] (CALCITE-4545) Unparse a new function of FUNCTION_ID syntax will be quoted

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

Jark Wu updated CALCITE-4545:
-----------------------------
    Fix Version/s:     (was: 1.27.0)
                       (was: 1.26.0)

> Unparse a new function of FUNCTION_ID syntax will be quoted
> -----------------------------------------------------------
>
>                 Key: CALCITE-4545
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4545
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Jark Wu
>            Priority: Major
>
> In Flink, we would like to introduce some new functions of FUNCTION_ID syntax, e.g. {{CURRENT_ROW_TIMESTAMP}}. However, when unparsing this new function, we will get the quoted string {{`CURRENT_ROW_TIMESTAMP`}} which can't be executed anymore, because Calcite think it is a column reference. 
> The root cause of it is {{org.apache.calcite.sql.SqlIdentifier#unparse}} calls {{org.apache.calcite.sql.SqlUtil#unparseSqlIdentifierSyntax}} where it uses a static Calcite {{SqlStdOperatorTable.instance()}} instead of a user-defined operator table. Therefore, it thinks it's not a sql function and unparse it with quotes. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)