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