[
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)