[ 
https://issues.apache.org/jira/browse/FLINK-41409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18146349#comment-18146349
 ] 

Stefan Wang commented on FLINK-41409:
-------------------------------------

I've opened https://github.com/apache/flink/pull/29979 with a fix. Could a 
committer assign this ticket to me?

> A view that selects CURRENT_DATE or LOCALTIME without an alias cannot be 
> queried
> --------------------------------------------------------------------------------
>
>                 Key: FLINK-41409
>                 URL: https://issues.apache.org/jira/browse/FLINK-41409
>             Project: Flink
>          Issue Type: Bug
>          Components: Documentation, Table SQL / API
>            Reporter: Martijn Visser
>            Priority: Major
>              Labels: pull-request-available
>
> CREATE VIEW v AS SELECT CURRENT_DATE;
>  SELECT * FROM v;
> The view is created, but the query fails with SQL parse failed. Incorrect 
> syntax near the keyword 'CURRENT_DATE'. The expanded query stored for the 
> view is SELECT CURRENT_DATE AS CURRENT_DATE, with the alias unquoted, and 
> SHOW CREATE VIEW prints the same. With an explicit alias it works. The time 
> zone page builds its examples on such a view, so they fail on master. 
> FLINK-25900 is about the same example's generated EXPR$ names, not this.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to