[
https://issues.apache.org/jira/browse/FLINK-36910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-36910:
-----------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
>
> 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)
