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

Count with hint doesn't work when hint is a document

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • 2.6.3, 2.7.4
    • 2.6.6, 2.7.7
    • Querying
    • None
    • ALL
    • Hide 

      t = db.jstests_count_hint;
      		 
      t.drop();
      		 
       
      		 
      t.save( { i: 1 } );
      		 
      t.save( { i: 2 } );
      		 
      assert.eq( 2, t.find().count() );
      		 
       
      		 
      // create a sparse index which should have no entries
      		 
      t.ensureIndex( { x:1 }, { sparse:true } );
      		 
       
      		 
      assert.eq( 0, t.find( { i: 1 } ).hint( "x_1" ).count(), "A" );
      		 
      assert.eq( 0, t.find( { i: 1 } ).hint( {x: 1} ).length(), "B" ); // With just find works
      		 
      assert.eq( 0, t.find( { i: 1 } ).hint( {x: 1} ).count(), "C" ); // Fails

      Show
      t = db.jstests_count_hint; t.drop();   t.save( { i: 1 } ); t.save( { i: 2 } ); assert.eq( 2, t.find().count() );   // create a sparse index which should have no entries t.ensureIndex( { x:1 }, { sparse: true } );   assert.eq( 0, t.find( { i: 1 } ).hint( "x_1" ).count(), "A" ); assert.eq( 0, t.find( { i: 1 } ).hint( {x: 1} ).length(), "B" ); // With just find works assert.eq( 0, t.find( { i: 1 } ).hint( {x: 1} ).count(), "C" ); // Fails

    Description

      When using hint() with count() it only works with the string name of the index and not a document representing the index key.

      Attachments

        Issue Links

          is depended on by

          Bug - A problem which impairs or prevents the functions of the product. DOCS-4391 Cannot use the document representing the index key for the hint() with count()

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-16945 cannot specify index when count command

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-2677 Allow count to work with query hints

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              david.storch@mongodb.com David Storch
              ross@mongodb.com Ross Lawley
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: