[CALCITE-806] ROW_NUMBER should emit distinct values

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 18/Jul/15 21:47
• Updated: 01/Sep/15 03:02
• Resolved: 22/Jul/15 20:43

Description

ROW_NUMBER should emit distinct values even for rows that have identical sort keys, or if there is no sort key. (This is distinct from RANK and DENSE_RANK, which emit the same value for rows with the same sort key.)

Issue Links

• is related to: CALCITE-800 Window function defined within another window function should be invalid