Loading...

XML

Word

Printable

JSON

Backwards Compatibility:
Minor Change
Operating System:
ALL
Steps To Reproduce:
Hide

In the shell:

> db.test.insert({ a: Infinity }) WriteResult({ "nInserted" : 1 }) > db.test.find({ a : { $type : 1 }}) { "_id" : ObjectId("559edd0837a9ccb7245bb7fd"), "a" : Infinity } > db.test.ensureIndex({ a : 1}) { "createdCollectionAutomatically" : false, "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 } > db.test.find({ a : { $type : 1 }}) > db.test.dropIndex({ a : 1 }) { "nIndexesWas" : 2, "ok" : 1 } > db.test.find({ a : { $type : 1 }}) { "_id" : ObjectId("559edd0837a9ccb7245bb7fd"), "a" : Infinity }
Show
In the shell: > db.test.insert({ a: Infinity }) WriteResult({ "nInserted" : 1 }) > db.test.find({ a : { $type : 1 }}) { "_id" : ObjectId( "559edd0837a9ccb7245bb7fd" ), "a" : Infinity } > db.test.ensureIndex({ a : 1}) { "createdCollectionAutomatically" : false , "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 } > db.test.find({ a : { $type : 1 }}) > db.test.dropIndex({ a : 1 }) { "nIndexesWas" : 2, "ok" : 1 } > db.test.find({ a : { $type : 1 }}) { "_id" : ObjectId( "559edd0837a9ccb7245bb7fd" ), "a" : Infinity }
Confidence Status:
None
Work Order:
3

Executing a type query with indexing and without can result in different results for Infinity, -Infinity, NaN.

The issue is in src/mongo/db/query/index_bounds_builder.cpp and caused by implementation of BSONElement.appendMin/MaxForType.

is related to

SERVER-19348 $mod results are inconsistent with indexing enabled on Infinity, -Infinity, NaN