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