[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: 26/Oct/22 12:50
• 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.

 

Issue Links

• is related to: CALCITE-5348 When translating ORDER BY in OVER, use the session's default null collation (e.g. NULLS LAST)