Details
-
Bug
-
Resolution: Done
-
Major - P3
-
None
-
None
-
None
-
None
-
ALL
Description
The lookups index has been set as explained in http://www.mongodb.org/display/DOCS/Using+Multikeys+to+Simulate+a+Large+Number+of+Indexes
The following query doesn't return any value
Query condition: { "_lookups" : { "state" :
} }
Explain:
{ "cursor" : "BtreeCursor lookups", "nscanned" : 0, "nscannedObjects" : 0, "n" : 0, "millis" : 0, "nYields" : 0, "nChunkSkips" : 0, "isMultiKey" : true, "indexOnly" : false, "indexBounds" : { "_lookups" : [[{ "state" :
}, { "state" :
{ "$in" : ["Active", "Verified"] }}]] } }
While
Query condition: { "$or" : [{ "_lookups" :
}, { "_lookups" :
{ "state" : "Verified" } }] }
Explain: { "cursor" : "BtreeCursor lookups", "nscanned" : 10, "nscannedObjects" : 10, "n" : 10, "millis" : 0, "nYields" : 0, "nChunkSkips" : 0, "isMultiKey" : true, "indexOnly" : false, "indexBounds" : { "_lookups" : [[
,
{ "state" : "Active" }]] } }
works