| Steps To Reproduce: |
db.foo.insert({fname:"MICKEY",lname:"MOUSE",state:"FL", loc:{type:"Point",coordinates:[-81.513743,28.369947]}})
|
|
db.foo.ensureIndex({"lname":1,"state":1},{name:"MYINDEX"})
|
db.foo.ensureIndex({loc:"2dsphere"})
|
|
// This will fail
|
db.foo.find({loc:{$near:{$geometry:{type:"Point",coordinates : [-81.513743,28.369947] }, $maxDistance :100}},lname:"MOUSE"})
|
|
|
db.foo.dropIndex("MYINDEX")
|
db.foo.ensureIndex({"lname":1},{name:"MYINDEX"})
|
|
// This will work since MYINDEX is not a compound index
|
db.foo.find({loc:{$near:{$geometry:{type:"Point",coordinates : [-81.513743,28.369947] }, $maxDistance :100}},lname:"MOUSE"})
|
|