Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

> t = db.t test.t > t.drop() true > t.ensureIndex({a: 1}) > t.insert({a: Infinity}) Insert WriteResult({ "ok" : 1, "n" : 1 }) > t.find() { "_id" : ObjectId("52a73a410ae4a72f57475846"), "a" : Infinity } > t.find({a: {$gt: 1}}) { "_id" : ObjectId("52a73a410ae4a72f57475846"), "a" : Infinity } > t.find({$or: [{a: {$gt: 1}}, {a: {$lt: 3}}]}) // The previous query should return the document, but it returns nothing.
Show
> t = db.t test.t > t.drop() true > t.ensureIndex({a: 1}) > t.insert({a: Infinity}) Insert WriteResult({ "ok" : 1, "n" : 1 }) > t.find() { "_id" : ObjectId( "52a73a410ae4a72f57475846" ), "a" : Infinity } > t.find({a: {$gt: 1}}) { "_id" : ObjectId( "52a73a410ae4a72f57475846" ), "a" : Infinity } > t.find({$or: [{a: {$gt: 1}}, {a: {$lt: 3}}]}) // The previous query should return the document, but it returns nothing.

Consider the query

{$or: [{a: {$gt: 1}}, {a: {$lt: 3}}]}

with an index on field 'a'. The first branch of the $or has index bounds

(1, Infinity]

and the second branch of the $or has index bounds

[-Infinity, 3)

. Since these two branches are children of an $or, the final index bounds should be the union of these two intervals, which is

[-Infinity, Infinity]

However, the actual index bounds are

[-Infinity, Infinity)

The bug is that the upper bound should be inclusive, but instead it is exclusive.