SHOW:
|
|
- or go back to the newest paste.
| 1 | Mongo > db.test.find() | |
| 2 | { "_id" : ObjectId("519ef9b9099b3346085145af"), "c" : 1, "d" : 1 }
| |
| 3 | { "_id" : ObjectId("519ef9bc099b3346085145b0"), "c" : 2, "d" : 2 }
| |
| 4 | { "_id" : ObjectId("519efa29099b3346085145b3"), "c" : 2, "d" : [ 3, 4, 5 ] }
| |
| 5 | { "_id" : ObjectId("519efec6099b3346085145b5"), "c" : 3, "d" : [ 3, 4, 5 ] }
| |
| 6 | ||
| 7 | Mongo > db.test.ensureIndex({ d : 1, c : 1 })
| |
| 8 | - | Mongo > db.test.find({d : 4, c : {$gte : 1, $lte : 2}}).explain()
|
| 8 | + | Mongo > db.test.find({d : 4, c : {$gte : 1, $lte : 2}}).explain() // check index bounds, not as expected
|
| 9 | {
| |
| 10 | "cursor" : "BtreeCursor d_1_c_1", | |
| 11 | "isMultiKey" : true, | |
| 12 | "n" : 1, | |
| 13 | "nscannedObjects" : 1, | |
| 14 | "nscanned" : 1, | |
| 15 | "nscannedObjectsAllPlans" : 1, | |
| 16 | "nscannedAllPlans" : 1, | |
| 17 | "scanAndOrder" : false, | |
| 18 | "indexOnly" : false, | |
| 19 | "nYields" : 0, | |
| 20 | "nChunkSkips" : 0, | |
| 21 | "millis" : 0, | |
| 22 | "indexBounds" : {
| |
| 23 | "d" : [ | |
| 24 | [ | |
| 25 | 4, | |
| 26 | 4 | |
| 27 | ] | |
| 28 | ], | |
| 29 | "c" : [ | |
| 30 | [ | |
| 31 | 1, | |
| 32 | - | 1.7976931348623157e+308 |
| 32 | + | 1.7976931348623157e+308 // $lte is not applied |
| 33 | ] | |
| 34 | ] | |
| 35 | }, | |
| 36 | "server" : "bdvlpabhishekk:27016" | |
| 37 | } | |
| 38 | - | Mongo > db.test.insert({c :3, d: [3, 4, 5]})
|
| 38 | + | ---------------------- |
| 39 | - | Mongo > db.test.find({d : 4, c : {$gte : 1, $lte : 2}}).explain()
|
| 39 | + | Mongo > db.test.find({d : 4, c : {$lte : 2, $gte : 1}}).explain() // $lte and $gte is interchanged, but index bound is again not expected
|
| 40 | {
| |
| 41 | "cursor" : "BtreeCursor d_1_c_1", | |
| 42 | "isMultiKey" : true, | |
| 43 | "n" : 1, | |
| 44 | - | "nscannedObjects" : 2, |
| 44 | + | |
| 45 | - | "nscanned" : 2, |
| 45 | + | |
| 46 | - | "nscannedObjectsAllPlans" : 2, |
| 46 | + | |
| 47 | - | "nscannedAllPlans" : 2, |
| 47 | + | |
| 48 | "scanAndOrder" : false, | |
| 49 | "indexOnly" : false, | |
| 50 | "nYields" : 0, | |
| 51 | "nChunkSkips" : 0, | |
| 52 | "millis" : 0, | |
| 53 | "indexBounds" : {
| |
| 54 | "d" : [ | |
| 55 | [ | |
| 56 | 4, | |
| 57 | 4 | |
| 58 | ] | |
| 59 | ], | |
| 60 | "c" : [ | |
| 61 | [ | |
| 62 | -1.7976931348623157e+308, // $gte not applied | |
| 63 | - | 1.7976931348623157e+308 |
| 63 | + | |
| 64 | ] | |
| 65 | ] | |
| 66 | }, | |
| 67 | "server" : "bdvlpabhishekk:27016" | |
| 68 | } |