-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: 2.4.0, 2.5.4
-
Component/s: Querying
-
Environment:Linux devpocmdb01 3.5.0-17-generic #28-Ubuntu SMP Tue Oct 9 19:31:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
-
Fully Compatible
-
Linux
-
If you query on two fields, and the first field is sparsly indexed, querying for $exists:true on the second field will use the first field's index. However, querying for $exists:false on the second field will prevent the use of the FIRST field's index!
The problem does not occur if the first field is fully (not sparsely) indexed.
- depends on
-
SERVER-11446 don't punt all not/nor to collscan.
- Closed
- is related to
-
SERVER-10608 {$exists: false} will not use index
- Closed