[SERVER-53972] Handle non-finite floats in arithmetic window functions Created: 22/Jan/21  Updated: 27/Oct/23  Resolved: 02/Mar/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Nicholas Zolnierz Assignee: Backlog - Query Optimization
Resolution: Gone away Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Sprint: Query Optimization 2021-03-22
Participants:

 Description   

For windows which may remove state from the accumulator, its possible to to evaluate to a non-finite value and then incorrectly stay in that state because adding anything to NaN, for instance, will always be NaN (even though the "new" window doesn't have a NaN in it, the state could be carried over from the prior iteration).



 Comments   
Comment by Nicholas Zolnierz [ 02/Mar/21 ]

hartek.sabharwal after standup, it sounds like we'll handle this ticket as we build out each function. Feel free to re-open if my understanding is incorrect.

Comment by Nicholas Zolnierz [ 18/Feb/21 ]

Note that a portion of this has been done for $sum and $avg as part of SERVER-53713, but leaving it open in case there's work for the other accumulators.

Generated at Thu Feb 08 05:32:19 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.