Its possible to get logically impossible results using $not in 2.5.5-pre
2.5.5-pre:
> db.thurs6.find({_id: {$lt: 0}}) { "_id" : -314159265359 } { "_id" : -3.14159265859 } > db.thurs6.find({_id: {$not: {$gte: 0}}}).count() 134 > db.runCommand({buildinfo: 1}) { "version" : "2.5.5-pre-", "gitVersion" : "4e62d347f090ce1afd91dc59b3db2fab8f930bc0", "OpenSSLVersion" : "", "sysInfo" : "Darwin Andrew-Emil-MacBook-Pro.local 12.4.0 Darwin Kernel Version 12.4.0: Wed May 1 17:57:12 PDT 2013; root:xnu-2050.24.15~1/RELEASE_X86_64 x86_64 BOOST_LIB_VERSION=1_49", "loaderFlags" : "-fPIC -pthread -Wl,-bind_at_load -mmacosx-version-min=10.6", "compilerFlags" : "-Wnon-virtual-dtor -Woverloaded-virtual -fPIC -fno-strict-aliasing -ggdb -pthread -Wall -Wsign-compare -Wno-unknown-pragmas -Winvalid-pch -Werror -pipe -O3 -Wno-unused-function -Wno-deprecated-declarations -mmacosx-version-min=10.6", "allocator" : "tcmalloc", "versionArray" : [ 2, 5, 5, -100 ], "javascriptEngine" : "V8", "bits" : 64, "debug" : false, "maxBsonObjectSize" : 16777216, "ok" : 1 }
Complete output of results from above attached to ticket.
- is duplicated by
-
SERVER-12501 $lte and $not producing different results from 2.5.5-pre and 2.4
- Closed