[FLINK-14053] blink planner dense_rank corner case bug

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.10.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jacky Lau
• Reporter: Jacky Lau
• Created: 11/Sep/19 12:10
• Updated: 24/Oct/19 12:24
• Resolved: 24/Oct/19 12:24

Description

sql :

val rank =
"""

SELECT

gradeId,

classId,

stuId,

score,

dense_rank() OVER (PARTITION BY gradeId, classId ORDER BY score asc) as dense_rank_num

FROM student

""".stripMargin

sample date:

row("grade2", "class2", "0006", 90),
row("grade1", "class2", "0007", 90),
row("grade1", "class1", "0001", 95),
row("grade1", "class1", "0002", 94),
row("grade1", "class1", "0003", 97),
row("grade1", "class1", "0004", 95),
row("grade1", "class1", "0005", 0)

the dense_rank ranks from 0, but it should be from 1

 

Issue Links

• links to: GitHub Pull Request #9966