[jira] [Created] (FLINK-6760) Fix OverWindowTest alias test error

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-6760) Fix OverWindowTest alias test error

Shang Yuanchun (Jira)
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)