Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-15650

[Server] Investigate changes in SERVER-66469: Filtering timeseries with date-field does not include results from before 1970

      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

            Assignee:
            david.hou@mongodb.com David Hou
            Reporter:
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:
              1 year, 23 weeks, 6 days ago