[CALCITE-2323] The configuration parameter "defaultNullCollation" which enum NullCollation { LOW, HIGH, FIRST, LAST } to allow alternative policies, but it can't take effect for over();

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.17.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: John Fang
• Created: 23/May/18 16:02
• Updated: 20/Jul/18 08:18
• Resolved: 23/Jun/18 16:43

Description

For example, the following query:

select deptno, rank() over(partition by empno order by deptno) from emp order by row_number() over(partition by empno order by deptno.

The default null order is nulls last for deptno in calcite. But the null order still is nulls last if we set the parameter "defaultNullCollation" with NullCollation.LOW.