Martijn Visser created FLINK-41409:
--------------------------------------
Summary: 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
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)
