[DOCS-14380] Investigate changes in SERVER-55270: Complete TODO listed in SERVER-55063 Created: 26/Apr/21  Updated: 13/Nov/23  Resolved: 24/Jun/21

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 4.9.0, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Jason Price
Resolution: Works as Designed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-55270 Complete TODO listed in SERVER-55063 Closed
Participants:
Days since reply: 2 years, 32 weeks, 6 days ago
Epic Link: DOCSP-9747
Story Points: 2

 Description   

Description

Downstream Change Summary

Tagging as needs attention from docs in case this page has been written already. Default for stdDev and stdPop window functions is now null

Description of Linked Ticket

There is a TODO in the codebase referencing a resolved ticket which is assigned to you.

Please follow this link to see the lines of code referencing this resolved ticket:
https://github.com/mongodb/mongo/search?q=SERVER-55063&type=Code

The next steps for this ticket are to either remove the outdated TODO or follow the steps in the TODO if it is correct. If the latter, please update the summary and description of this ticket to represent the work you're actually doing.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Jason Price [ 24/Jun/21 ]

This is actually already done as part of:
https://jira.mongodb.org/browse/DOCSP-10258

The $stdDevSamp and $stdDevPop topics contain this content:

Behavior with values in a :pipeline:`$setWindowFields` stage
:ref:`window <setWindowFields-window>`:

  • Ignores non-numeric values, ``null`` values, and missing fields in a
    window.
  • If the window is empty, returns ``null``.
  • If the window contains a ``NaN`` value, returns ``null``.
  • If the window contains ``Infinity`` values, returns ``null``.
  • If none of the previous points apply, returns a ``double`` value.

The bullets cover all the cases, including when null is returned. I've checked this content with Nick and he agrees it covers the null return cases correctly.

Per Andrew, resolving this JIRA as "Works as Designed".

Generated at Thu Feb 08 08:10:15 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.