Core Server
  1. Core Server
  2. SERVER-958

Range queries on arrays behave differently with indexes

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major - P3 Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.1
    • Component/s: Querying
    • Labels:
      None
    • # Replies:
      15
    • Last comment by Customer:
      true

      Description

      > db.test.insert(

      {a:[1,10]}

      )
      > db.test.find({a: {$gt: 2, $lt:5}})

      { "_id" : ObjectId("4bb9be0accf9c6e519c4d1fe"), "a" : [ 1, 10 ] }

      > db.test.ensureIndex(

      {a:1}

      )
      > db.test.find({a: {$gt: 2, $lt:5}})
      >

        Issue Links

          Activity

          Hide
          auto (Inactive)
          added a comment -

          Author:

          {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

          Message: SERVER-958 merge and address mongos dependency differences
          Branch: master
          https://github.com/mongodb/mongo/commit/3af50f5b941a07b0f290c7f8ee2726c85e2d0699

          Show
          auto (Inactive)
          added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-958 merge and address mongos dependency differences Branch: master https://github.com/mongodb/mongo/commit/3af50f5b941a07b0f290c7f8ee2726c85e2d0699
          Hide
          auto (Inactive)
          added a comment -

          Author:

          {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

          Message: SERVER-958 merge and address mongos dependency differences
          Branch: master
          https://github.com/mongodb/mongo/commit/3af50f5b941a07b0f290c7f8ee2726c85e2d0699

          Show
          auto (Inactive)
          added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-958 merge and address mongos dependency differences Branch: master https://github.com/mongodb/mongo/commit/3af50f5b941a07b0f290c7f8ee2726c85e2d0699
          Hide
          auto (Inactive)
          added a comment -

          Author:

          {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

          Message: SERVER-958 Prefer fully contained multikey ranges since they are smaller.
          Branch: master
          https://github.com/mongodb/mongo/commit/4786360d414f6b4421a71456222866c9a4f033fa

          Show
          auto (Inactive)
          added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-958 Prefer fully contained multikey ranges since they are smaller. Branch: master https://github.com/mongodb/mongo/commit/4786360d414f6b4421a71456222866c9a4f033fa
          Hide
          auto (Inactive)
          added a comment -

          Author:

          {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

          Message: SERVER-958 Looser bounds for multikey indexes with parallel nested fields
          Branch: master
          https://github.com/mongodb/mongo/commit/e780ffc12fc56885566a93f5fa97f8281885f334

          Show
          auto (Inactive)
          added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-958 Looser bounds for multikey indexes with parallel nested fields Branch: master https://github.com/mongodb/mongo/commit/e780ffc12fc56885566a93f5fa97f8281885f334
          Hide
          Aaron Staple (Inactive)
          added a comment -

          A few related todos

          SERVER-3102
          SERVER-3103
          SERVER-3104

          Show
          Aaron Staple (Inactive)
          added a comment - A few related todos SERVER-3102 SERVER-3103 SERVER-3104

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since reply:
                3 years, 42 weeks ago
                Date of 1st Reply: