[
https://issues.apache.org/jira/browse/FLINK-36910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gustavo de Morais updated FLINK-36910:
--------------------------------------
Description:
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}
We currently do not support calling any of the time-related dynamic functions
with parenthesis: LOCALTIME, LOCALTIMESTAMP, CURRENT_TIME, CURRENT_DATE,
CURRENT_TIMESTAMP. This is not intuitive for new users since most functions
support being called with empty parenthesis. Thus, we want to support calling
these both with or without parenthesis, like we do for PI and PI().
was:
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.
> 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
> 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}
>
> We currently do not support calling any of the time-related dynamic functions
> with parenthesis: LOCALTIME, LOCALTIMESTAMP, CURRENT_TIME, CURRENT_DATE,
> CURRENT_TIMESTAMP. This is not intuitive for new users since most functions
> support being called with empty parenthesis. Thus, we want to support calling
> these both with or without parenthesis, like we do for PI and PI().
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
