Gustavo de Morais created FLINK-36910:
-----------------------------------------
Summary: Support calling time-related dynamic functions with
parenthesis
Key: FLINK-36910
URL: https://issues.apache.org/jira/browse/FLINK-36910
Project: Flink
Issue Type: Bug
Components: Table SQL / API
Reporter: Gustavo de Morais
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)
