summaryrefslogtreecommitdiff
path: root/jstests/queryoptimizer6.js
blob: f1742cdcc89a0f3ce09ca79cfda3f1f8c0a14a98 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
// Test that $ne constraints are accounted for in QueryPattern. SERVER-4665

t = db.jstests_queryoptimizer6;
t.drop();

t.save( {a:1} );
t.ensureIndex( {b:1}, {sparse:true} );

// The sparse index will be used, and recorded for this query pattern.
assert.eq( 0, t.find( {a:1,b:{$ne:1}} ).itcount() );
// The query pattern should be different, and the sparse index should not be used.
assert.eq( 1, t.find( {a:1} ).itcount() );