[DOCS-15650] [Server] Investigate changes in SERVER-66469: Filtering timeseries with date-field does not include results from before 1970 Created: 27/Sep/22  Updated: 13/Nov/23  Resolved: 09/Nov/22

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 6.2.0-rc0, 6.0.5, 5.0.16, 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: David Hou
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-66469 Filtering timeseries with date-field ... Closed
Participants:
Days since reply: 1 year, 13 weeks ago
Epic Link: DOCSP-22091

 Description   
Original Downstream Change Summary

Time series collections containing dates outside the epoch will no longer be using _id or the clustered index for filtering. This can be mitigated by adding an index over control.min.[time_field] to the bucket collection.

Description of Linked Ticket

db['test-array-ts'].countDocuments({
  date: { $lt: ISODate('1970-01-01T18:31:22.000+00:00') }
})
result: 149

db['test-array-ts'].countDocuments({
  date: { $lt: ISODate('1965-01-01T18:31:22.000+00:00') }
})
result: 1989943



 Comments   
Comment by David Hou [ 09/Nov/22 ]

No docs changes needed.

Comment by Education Bot [ 27/Sep/22 ]

Fix Version updated for upstream SERVER-66469:
6.2.0-rc0

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