Details

    • Type: New Feature New Feature
    • Status: Closed Closed
    • Priority: Major - P3 Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.3
    • Component/s: Querying
    • Labels:
      None
    • # Replies:
      51
    • Last comment by Customer:
      false

      Description

      > db.foo.ensureIndex(

      { a : 1 }

      )
      true
      > db.foo.ensureIndex(

      { b : 1 }

      )
      true
      > db.foo.find(

      { a : 1 }

      ).explain()
      {"cursor" : "BtreeCursor a_1" , "startKey" :

      {"a" : 1}

      , "endKey" :

      {"a" : 1}

      , "nscanned" : 2 , "n" : 2 , "millis" : 0 , "allPlans" : [{"cursor" : "BtreeCursor a_1" , "startKey" :

      {"a" : 1}

      , "endKey" : {"a" : 1}}]}
      > db.foo.find( { $or : [

      { a : 1 }

      ,

      { b : 1 }

      } ).explain()
      Wed Jun 17 06:57:15 JS Error: SyntaxError: missing ] after element list (anon):2147
      > db.foo.find( { $or : [

      { a : 1 }

      ,

      { b : 1 }

      ] ).explain()
      Wed Jun 17 06:57:20 JS Error: SyntaxError: missing } after property list (anon):2147
      > db.foo.find( { $or : [

      { a : 1 }

      ,

      { b : 1 }

      ] } ).explain()
      {"cursor" : "BasicCursor" , "startKey" : {} , "endKey" : {} , "nscanned" : 3 , "n" : 0 , "millis" : 0 , "allPlans" : [{"cursor" : "BasicCursor" , "startKey" : {} , "endKey" : {}}]}
      > for ( i=0; i<2000; i++ ){ db.foo.save(

      { a : i }

      ); }
      > for ( i=0; i<2000; i++ ){ db.foo.save(

      { h : i }

      ); }
      > for ( i=0; i<2000; i++ ){ db.foo.save(

      { b : i }

      ); }
      > db.foo.find( { $or : [

      { a : 1 }

      ,

      { b : 1 }

      ] } ).explain()
      {"cursor" : "BasicCursor" , "startKey" : {} , "endKey" : {} , "nscanned" : 6003 , "n" : 0 , "millis" : 2 , "allPlans" : [{"cursor" : "BasicCursor" , "startKey" : {} , "endKey" : {}}]}

        Issue Links

          Activity

          Hide
          Aaron Staple (Inactive)
          added a comment -

          SERVER-1205, SERVER-1206, and SERVER-1207 describe a few remaining issues, but the main implementation is done.

          Show
          Aaron Staple (Inactive)
          added a comment - SERVER-1205 , SERVER-1206 , and SERVER-1207 describe a few remaining issues, but the main implementation is done.
          Hide
          auto
          added a comment -

          Author:

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

          Message: SERVER-109 fix range diff (based on selected index)
          http://github.com/mongodb/mongo/commit/87f204e44fb688fc1787028b3b409cca9cd178ef

          Show
          auto
          added a comment - Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'} Message: SERVER-109 fix range diff (based on selected index) http://github.com/mongodb/mongo/commit/87f204e44fb688fc1787028b3b409cca9cd178ef
          Hide
          auto
          added a comment -

          Author:

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

          Message: SERVER-109 range diff after compound index scan
          http://github.com/mongodb/mongo/commit/a18d67076188ae7288d993a6581daea444ac1cf3

          Show
          auto
          added a comment - Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'} Message: SERVER-109 range diff after compound index scan http://github.com/mongodb/mongo/commit/a18d67076188ae7288d993a6581daea444ac1cf3
          Hide
          auto
          added a comment -

          Author:

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

          Message: SERVER-109 expand $in clauses in simplifiedQuery
          http://github.com/mongodb/mongo/commit/eabc79c785d7687af057b4d0dd3ee657fa32760d

          Show
          auto
          added a comment - Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'} Message: SERVER-109 expand $in clauses in simplifiedQuery http://github.com/mongodb/mongo/commit/eabc79c785d7687af057b4d0dd3ee657fa32760d
          Hide
          auto
          added a comment -

          Author:

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

          Message: SERVER-109 make simplifiedQuery match actual btree cursor bounds when necessary
          http://github.com/mongodb/mongo/commit/a8fd0b6ac537541f516c5d80bab6ce7fcc7f0083

          Show
          auto
          added a comment - Author: {'login': 'astaple', 'name': 'Aaron', 'email': 'aaron@10gen.com'} Message: SERVER-109 make simplifiedQuery match actual btree cursor bounds when necessary http://github.com/mongodb/mongo/commit/a8fd0b6ac537541f516c5d80bab6ce7fcc7f0083

            People

            • Votes:
              9 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

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