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.

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