[
https://issues.apache.org/jira/browse/FLINK-36910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dawid Wysakowicz resolved FLINK-36910.
--------------------------------------
Fix Version/s: 2.0.0
Assignee: Gustavo de Morais
Resolution: Implemented
Implemented in
d2b0fbb8efcd8a94d1b4f730c2a11d069565e1c3..7f162dd1ff1598995c1e576ace59cbd626698fcf
> 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
> Assignee: Gustavo de Morais
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.0.0
>
>
> 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)
