Gustavo de Morais created FLINK-36841:
-----------------------------------------
             Summary: Incorrect error message for CURRENT_TIMESTAMP
                 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


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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to