[SERVER-82168] Make window function $rank/$denseRank consistent on handling null and missing Created: 13/Oct/23  Updated: 07/Feb/24

Status: In Code Review
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Rui Liu Assignee: Rui Liu
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Participants:

 Description   

Currently, $rank and $denseRank treat null and missing differently, which causes a field to change from null to missing, or vice versa to a rank increment. This is not consistent with $sort behavior, which treats null and missing the same. This causes the rank result to be unstable.

The SBE implementation currently copies the Classic semantics. When we update the semantics, we should update in both engines.



 Comments   
Comment by Githook User [ 07/Feb/24 ]

Author:

{'name': 'Rui Liu', 'email': '33423526+lriuui0x0@users.noreply.github.com', 'username': 'lriuui0x0'}

Message: SERVER-82168 Make $rank/$denseRank treat null/missing the same (#17911)

GitOrigin-RevId: 74aa440c55a1e3f4910a6ce99bb3efe81a86514d
Branch: master
https://github.com/mongodb/mongo/commit/4766e2eebde3cd796f621a28ce23f0734bf5781c

Generated at Thu Feb 08 06:48:26 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.