[jira] [Created] (FLINK-18440) ROW_NUMBER function: ROW/RANGE not allowed with RANK, DENSE_RANK or ROW_NUMBER functions

["LakeShen (Jira)" <ji...@apache.org>]

LakeShen created FLINK-18440:
--------------------------------

             Summary: ROW_NUMBER function: ROW/RANGE not allowed with RANK, DENSE_RANK or ROW_NUMBER functions
                 Key: FLINK-18440
                 URL: https://issues.apache.org/jira/browse/FLINK-18440
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.11.0
            Reporter: LakeShen
             Fix For: 1.11.1


When I run flink sql ,the flink sql like this:

create view test as select  name, eat ,sum(age) as cnt from test_source group by  name,eat;

create view resultsssss as select *, ROW_NUMBER() OVER (PARTITION BY name ORDER BY cnt DESC) as row_num from test;

The same sql code I could run success in flink 1.10, now I change the flink version into flink 1.11, it throw the exception.





--
This message was sent by Atlassian Jira
(v8.3.4#803005)