[SERVER-55063] window function stddev can take the sqrt of a negative number and return NaN Created: 09/Mar/21  Updated: 29/Oct/23  Resolved: 15/Mar/21

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

Type: Bug Priority: Major - P3
Reporter: Ted Tuckman Assignee: Hartek Sabharwal
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-55270 Complete TODO listed in SERVER-55063 Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Steps To Reproduce:

Running the window function helpers implemented in SERVER-54849 reveals this bug.

Sprint: Query Optimization 2021-03-22
Participants:

 Comments   
Comment by Githook User [ 15/Mar/21 ]

Author:

{'name': 'Hartek Sabharwal', 'email': 'hartek.sabharwal@mongodb.com', 'username': 'tectonic8'}

Message: SERVER-55063 Window function StdDev can take the sqrt of a negative number and return NaN
Branch: master
https://github.com/mongodb/mongo/commit/ab6cfc3ad758c41d5e8bb9364ef8cb3639e84f0f

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