order of keys is matters in hashes, in find, similar object gives different results on different queries.

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: 1.6.5
    • Component/s: Querying
    • None
    • Environment:
      Ubuntu 10 server 64bit
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      I cant expect programmers to remember the order in all places in the code especially in large code base.

      db.eventstatus.insert(
      {
      "_id": ObjectId("4d2093d0aaed39b6d9716b1d"),
      "t12_status": [

      { "status": "coming", "invite": ObjectId("4d208cdb50e82e8f65000002"), "value": 1 }

      ]
      });

      db.eventstatus.insert({
      "_id": ObjectId("4d208dac50e82e8f6500000b"),
      "t12_status": [

      { "invite": ObjectId("4d208cdb50e82e8f65000002"), "status": "coming", "value": 1 }

      ]
      });

      db.eventstatus.find({"t12_status":{"status":"coming","invite":ObjectId("4d208cdb50e82e8f65000002"),"value":1}});
      db.eventstatus.find({"t12_status":{"invite":ObjectId("4d208cdb50e82e8f65000002"),"status":"coming","value":1}});

      //expected: both queries will return the 2 documents. - wanted
      //actual@v1.6.5: each query returns a different object, one object. - not wanted, unexpected

            Assignee:
            Unassigned
            Reporter:
            Shimon Doodkin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: