Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 7.1.1, 7.2.0-rc0, 5.0.22, 7.0.3, 6.0.12
Affects Version/s: None
Component/s: None
Labels:
None

Backwards Compatibility:
Fully Compatible
Operating System:
ALL
Backport Requested:

v7.1, v7.0, v6.0, v5.0
Linked BF Score:
150
Confidence Status:
None
Work Order:
3

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

When the number of documents in the window frame is 0, the adjusted count for $stdDevSamp might be negative, and we should return NULL in this case.

https://github.com/10gen/mongo/blob/fc174d081bdd6a5178cc888e6f0309d23504b4df/src/mongo/db/pipeline/window_function/window_function_stddev.h#L65-L67

$covarianceSamp handles this correctly.

https://github.com/10gen/mongo/blob/fc174d081bdd6a5178cc888e6f0309d23504b4df/src/mongo/db/pipeline/window_function/window_function_covariance.cpp#L96-L98

Assignee:: Rui Liu
Reporter:: Rui Liu
Participants:: Githook User, Rui Liu
Votes:: 0 Vote for this issue
Watchers:: 3 Start watching this issue

Created:: Oct 11 2023 01:09:49 PM UTC
Updated:: Feb 05 2024 08:08:34 PM UTC
Resolved:: Oct 11 2023 05:40:02 PM UTC
Confidence Status Last Update:: 11/Oct/23 1:40 PM