[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 |