Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:

Hide

var coll = db.getCollection("covered_compound_1")
coll.drop()
for (i=0;i<100;i++) {
coll.insert(
{a:i, b:"strvar_"+(i%13), c:NumberInt(i%10)}
)
}
coll.insert
coll.ensureIndex(
{a:1,b:-1,c:1}
)
// Test no result
var plan = coll.find(
{a:38, b:"strvar_12", c:55}
).hint(
{a:1, b:-1, c:1}
).explain()
assert.eq(true, plan.indexOnly, "compound.1.7 - indexOnly should be true on covered query")

Show
var coll = db.getCollection("covered_compound_1") coll.drop() for (i=0;i<100;i++) { coll.insert( {a:i, b:"strvar_"+(i%13), c:NumberInt(i%10)} ) } coll.insert coll.ensureIndex( {a:1,b:-1,c:1} ) // Test no result var plan = coll.find( {a:38, b:"strvar_12", c:55} ).hint( {a:1, b:-1, c:1} ).explain() assert.eq(true, plan.indexOnly, "compound.1.7 - indexOnly should be true on covered query")
Confidence Status:
None
Work Order:
3

Covered index query which does not return a result does not have indexOnly=true