Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-72428

filter/$match not working on 1970-01-01 for timeseries collection

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 5.0.14, 6.0.2, 6.0.3
    • Component/s: None
    • Query Optimization
    • ALL
    • Hide

      Filter on january first a timeseries collection on timestamp field

      Show
      Filter on january first a timeseries collection on timestamp field
    • QO 2023-02-06, QO 2023-02-20, QO 2023-03-06

      When filtering a timestamp on january 1 1970 no document is returned.

      Minimal reproduction collection:

      Filter

       

      $match:

        1. image-2022-12-29-17-31-14-812.png
          image-2022-12-29-17-31-14-812.png
          16 kB
        2. image-2022-12-29-17-31-40-393.png
          image-2022-12-29-17-31-40-393.png
          22 kB
        3. image-2022-12-29-17-32-06-976.png
          image-2022-12-29-17-32-06-976.png
          29 kB
        4. image-2022-12-29-17-33-19-851.png
          image-2022-12-29-17-33-19-851.png
          22 kB
        5. image-2022-12-29-17-33-54-751.png
          image-2022-12-29-17-33-54-751.png
          17 kB
        6. image-2022-12-29-17-15-16-618.png
          image-2022-12-29-17-15-16-618.png
          165 kB

            Assignee:
            david.percy@mongodb.com David Percy
            Reporter:
            thomas.merle@enerfox.fr Thomas MERLE
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: