[ 
https://issues.apache.org/jira/browse/FLINK-41409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated FLINK-41409:
-----------------------------------
    Labels: pull-request-available  (was: )

> 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