Jark Wu created CALCITE-4545:
--------------------------------
Summary: 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
Fix For: 1.27.0, 1.26.0
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)
