Loading...

XML

Word

Printable

JSON

Backwards Compatibility:
Fully Compatible
Operating System:
ALL
Steps To Reproduce:
Hide

var houses = db.getSisterDB("2d").houses; houses.insert({ price_room: [10000, 3], type: "house" }); houses.ensureIndex({price_room: "2d"}, { min: 0, max: 200000}); houses.find( { price_room : { $geoWithin : { $box : [ [ 2000 , 0 ] , [ 20000 , 100 ] ] } } }).explain(true);

In 2.4 the indexBounds field is filled in. In 2.5.5, the indexBounds is an empty document.
Show
var houses = db.getSisterDB( "2d" ).houses; houses.insert({ price_room: [10000, 3], type: "house" }); houses.ensureIndex({price_room: "2d" }, { min: 0, max: 200000}); houses.find( { price_room : { $geoWithin : { $box : [ [ 2000 , 0 ] , [ 20000 , 100 ] ] } } }).explain( true ); In 2.4 the indexBounds field is filled in. In 2.5.5, the indexBounds is an empty document.
Confidence Status:
None
Work Order:
3

When using the 2d index with custom min, max values query plan does not return when using explain although query is answered.