[
https://issues.apache.org/jira/browse/FLINK-36841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17906468#comment-17906468
]
Gustavo de Morais commented on FLINK-36841:
-------------------------------------------
Closed in favor of https://issues.apache.org/jira/browse/FLINK-36910
> Incorrect error message for functions without parenthesis
> ---------------------------------------------------------
>
> Key: FLINK-36841
> URL: https://issues.apache.org/jira/browse/FLINK-36841
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Reporter: Gustavo de Morais
> Priority: Major
>
> Running the following query:
> {code:java}
> select CURRENT_TIMESTAMP() from (values (1), (2), (3)) x(a);{code}
> fails with:
> {code:java}
> SQL validation failed. Error from line 1, column 8 to line 1, column
> 26.Caused by: Function 'CURRENT_TIMESTAMP()' does not exist or you do not
> have permission to access it.
> Using current catalog 'DEV' and current database 'IDO_0'.
> Supported signatures are:
> 'CURRENT_TIMESTAMP(<INTEGER>)'
> 'CURRENT_TIMESTAMP()' {code}
>
> The supported signatures we suggest to the user are incorrect:
> {_}'CURRENT_TIMESTAMP(<INTEGER>)''CURRENT_TIMESTAMP()'{_}. We only support
> calling CURRENT_TIMESTAMP without parenthesis. Thus, we have to update the
> error message. Obs.: we might have the same issue for these time-related
> functions LOCALTIME, LOCALTIMESTAMP, CURRENT_TIME, CURRENT_DATE,
> CURRENT_TIMESTAMP and should double-check that.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
