sunjincheng created FLINK-6760:
----------------------------------
Summary: Fix OverWindowTest alias test error
Key: FLINK-6760
URL:
https://issues.apache.org/jira/browse/FLINK-6760 Project: Flink
Issue Type: Sub-task
Components: Table API & SQL
Affects Versions: 1.3.0
Reporter: sunjincheng
Assignee: sunjincheng
For Sql:
{code}
val sql = "SELECT c, count(a) OVER (ORDER BY proctime ROWS BETWEEN 2 preceding AND CURRENT ROW) as cnt1 CURRENT ROW from MyTable"
{code}
The alias `cnt1` The alias did not take effect when we generated the plan string. But we can using the alias in outer layer query, for example:
{code}
val sql = "SELECT cnt1 from (SELECT c, count(a) OVER (ORDER BY proctime ROWS BETWEEN 2 preceding AND CURRENT ROW) as cnt1 CURRENT ROW from MyTable)"
{code}
So in this JIRA. we just fix the test case for 1.3 release. In another JIRA. will improve the alias.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)