Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Backport Completed:

2.6.6
Steps To Reproduce:
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
Confidence Status:
None
Work Order:
3

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

is duplicated by

SERVER-16945 cannot specify index when count command

related to

SERVER-2677 Allow count to work with query hints