Details
-
Bug
-
Resolution: Done
-
Major - P3
-
2.4.0, 2.5.4
-
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
-
Description
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.
Attachments
Issue Links
- 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
-