You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Gustavo de Morais (Jira)" <ji...@apache.org> on 2024/12/03 19:19:00 UTC
[jira] [Updated] (FLINK-36841) Incorrect error message for functions without parenthesis
[ https://issues.apache.org/jira/browse/FLINK-36841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gustavo de Morais updated FLINK-36841:
--------------------------------------
Summary: Incorrect error message for functions without parenthesis (was: Incorrect error message for CURRENT_TIMESTAMP)
> 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)