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

$elemMatch on subarrays returns different results in 2.4 vs 2.6

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.6.0
    • Component/s: Querying
    • Query
    • ALL

      I don't yet understand the behavior surrounding this issue, but have generated a small reproduction.

      In 2.5:

      > x
      { "_id" : 0, "a" : [ [ { "a" : [ 1 ] } ] ] }
      > db.mytest.insert(x)
      SingleWriteResult({
              "writeErrors" : [ ],
              "writeConcernErrors" : [ ],
              "nInserted" : 1,
              "nUpserted" : 0,
              "nUpdated" : 0,
              "nModified" : 0,
              "nRemoved" : 0,
              "upserted" : [ ]
      })
      > db.mytest.find({"a.0": {$elemMatch: {a: 1}}})
      { "_id" : 0, "a" : [ [ { "a" : [ 1 ] } ] ] }
      > db.runCommand({buildinfo: 1})
      {
              "version" : "2.5.5-pre-",
              "gitVersion" : "4e62d347f090ce1afd91dc59b3db2fab8f930bc0",
              "OpenSSLVersion" : "",
              "sysInfo" : "Darwin Andrew-Emil-MacBook-Pro.local 12.4.0 Darwin Kernel Version 12.4.0: Wed May  1 17:57:12 PDT 2013; root:xnu-2050.24.15~1/RELEASE_X86_64 x86_64 BOOST_LIB_VERSION=1_49",
              "loaderFlags" : "-fPIC -pthread -Wl,-bind_at_load -mmacosx-version-min=10.6",
              "compilerFlags" : "-Wnon-virtual-dtor -Woverloaded-virtual -fPIC -fno-strict-aliasing -ggdb -pthread -Wall -Wsign-compare -Wno-unknown-pragmas -Winvalid-pch -Werror -pipe -O3 -Wno-unused-function -Wno-deprecated-declarations -mmacosx-version-min=10.6",
              "allocator" : "tcmalloc",
              "versionArray" : [
                      2,
                      5,
                      5,
                      -100
              ],
              "javascriptEngine" : "V8",
              "bits" : 64,
              "debug" : false,
              "maxBsonObjectSize" : 16777216,
              "ok" : 1
      }
      
      

      But in 2.4.9 the document is not returned:

      > x
      { "_id" : 0, "a" : [ [ { "a" : [ 1 ] } ] ] }
      > mydb.mytest.insert(x)
      > mydb.mytest.find({"a.0": {$elemMatch: {a: 1}}})
      

            Assignee:
            backlog-server-query Backlog - Query Team (Inactive)
            Reporter:
            andrew.emil@10gen.com Andrew Emil (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: