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

Collection find on ISODate

    • Type: Icon: Question Question
    • Resolution: Done
    • Priority: Icon: Minor - P4 Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
      None

      Does the ordering of "date", "timezone", "timezone_type" matters for an ISODate attribute matters on insert/find of a document?

       

      We noticed that a find operation on an ISODate object that was inserted with timezone_type, date, timezone didn`t match any documents and when we switched the attribute order in the object to date, timezone_type, timezone it worked as expected. 

       

      Sample query used: db.test_col.find({to: { $gt:

      { date: "2019-04-17 13:45:07.000000", timezone_type: 1, timezone: "+00:00" }

      } });

            Assignee:
            eric.sedor@mongodb.com Eric Sedor
            Reporter:
            alex_aslan Alex Aslan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: