[COMPASS-7376] Investigate changes in SERVER-82204: Classic window functions first/last handle missing field incorrectly Created: 26/Oct/23  Updated: 29/Jan/24  Resolved: 29/Jan/24

Status: Closed
Project: Compass
Component/s: None
Affects Version/s: None
Fix Version/s: No version

Type: Investigation Priority: Minor - P4
Reporter: Backlog - Core Eng Program Management Team Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-82204 Classic window functions first/last h... Closed
Epic Link: COMPASS-6403
Documentation Changes: Not Needed

 Description   
Original Downstream Change Summary

The $first/$last operator in $setWindowFields will now set null to missing fields to be consistent with $first/$last in $group.

Description of Linked Ticket

When the attribute tracked by first/last in the first/last document in the window has a missing attribute the functions return empty results. This is incorrect. According to the documentation they should return null to be consistent with the $group behaviour.



 Comments   
Comment by Anna Henningsen [ 29/Jan/24 ]

No impact

Comment by PM Bot [ 30/Oct/23 ]

Fix Version updated for upstream SERVER-82204:
7.1.1, 7.2.0-rc0, 6.0.12, 5.0.23, 7.0.4

Comment by PM Bot [ 26/Oct/23 ]

Fix Version updated for upstream SERVER-82204:
7.1.1, 7.2.0-rc0, 7.0.3, 6.0.12, 5.0.23

Comment by PM Bot [ 26/Oct/23 ]

Fix Version updated for upstream SERVER-82204:
7.2.0-rc0, 7.0.3, 6.0.12, 5.0.23

Comment by PM Bot [ 26/Oct/23 ]

Fix Version updated for upstream SERVER-82204:
7.2.0-rc0, 6.0.12, 5.0.23

Comment by PM Bot [ 26/Oct/23 ]

Fix Version updated for upstream SERVER-82204:
7.2.0-rc0, 5.0.23

Comment by PM Bot [ 26/Oct/23 ]

Fix Version updated for upstream SERVER-82204:
7.2.0-rc0

Generated at Wed Feb 07 22:46:20 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.