[SERVER-11837] Documents with value Infinity for index key not returned in query in 2.4 - MongoDB Jira

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major - P3
Resolution: Won't Fix
Affects Version/s: None
Fix Version/s: None
Component/s: Querying
Labels:
- 26qa
- nqf
- query_triage
Environment:

Hide
> db.serverBuildInfo()
{
"version" : "2.4.9-pre-",
"gitVersion" : "38b3b8f7395d6717efd570a62dc1c2c085d1b049",
"sysInfo" : "Linux ip-10-2-29-40 2.6.21.7-2.ec2.v1.2.fc8xen #1 SMP Fri Nov 20 17:48:28 EST 2009 x86_64 BOOST_LIB_VERSION=1_49",
"loaderFlags" : "-fPIC -pthread -rdynamic",
"compilerFlags" : "-Wnon-virtual-dtor -Woverloaded-virtual -fPIC -fno-strict-aliasing -ggdb -pthread -Wall -Wsign-compare -Wno-unknown-pragmas -Winvalid-pch -Werror -pipe -fno-builtin-memcmp -O3",
"allocator" : "tcmalloc",
"versionArray" : [
2,
4,
9,
-100
],
"javascriptEngine" : "V8",
"bits" : 64,
"debug" : false,
"maxBsonObjectSize" : 16777216,
"ok" : 1
}
and
> db.serverBuildInfo()
{
"version" : "2.5.5-pre-",
"gitVersion" : "4d722953fa6e7f0cd8732601ed7c5c1cb8808bad",
"OpenSSLVersion" : "",
"sysInfo" : "Linux ip-10-2-29-40 2.6.21.7-2.ec2.v1.2.fc8xen #1 SMP Fri Nov 20 17:48:28 EST 2009 x86_64 BOOST_LIB_VERSION=1_49",
"loaderFlags" : "-fPIC -pthread -Wl,-z,now -rdynamic",
"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 -fno-builtin-memcmp",
"allocator" : "tcmalloc",
"versionArray" : [
2,
5,
5,
-100
],
"javascriptEngine" : "V8",
"bits" : 64,
"debug" : false,
"maxBsonObjectSize" : 16777216,
"ok" : 1
}

Show
> db.serverBuildInfo() { "version" : "2.4.9-pre-", "gitVersion" : "38b3b8f7395d6717efd570a62dc1c2c085d1b049", "sysInfo" : "Linux ip-10-2-29-40 2.6.21.7-2.ec2.v1.2.fc8xen #1 SMP Fri Nov 20 17:48:28 EST 2009 x86_64 BOOST_LIB_VERSION=1_49", "loaderFlags" : "-fPIC -pthread -rdynamic", "compilerFlags" : "-Wnon-virtual-dtor -Woverloaded-virtual -fPIC -fno-strict-aliasing -ggdb -pthread -Wall -Wsign-compare -Wno-unknown-pragmas -Winvalid-pch -Werror -pipe -fno-builtin-memcmp -O3", "allocator" : "tcmalloc", "versionArray" : [ 2, 4, 9, -100 ], "javascriptEngine" : "V8", "bits" : 64, "debug" : false, "maxBsonObjectSize" : 16777216, "ok" : 1 } and > db.serverBuildInfo() { "version" : "2.5.5-pre-", "gitVersion" : "4d722953fa6e7f0cd8732601ed7c5c1cb8808bad", "OpenSSLVersion" : "", "sysInfo" : "Linux ip-10-2-29-40 2.6.21.7-2.ec2.v1.2.fc8xen #1 SMP Fri Nov 20 17:48:28 EST 2009 x86_64 BOOST_LIB_VERSION=1_49", "loaderFlags" : "-fPIC -pthread -Wl,-z,now -rdynamic", "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 -fno-builtin-memcmp", "allocator" : "tcmalloc", "versionArray" : [ 2, 5, 5, -100 ], "javascriptEngine" : "V8", "bits" : 64, "debug" : false, "maxBsonObjectSize" : 16777216, "ok" : 1 }

Backwards Compatibility:
Fully Compatible
Operating System:
ALL

Steps To Reproduce:

Hide

2.4.9-pre-

> db.c.insert({a:Infinity})

> db.c.find({a:{$gt:0}})

{ "_id" : ObjectId("528ffb985142cd7d1e23d1cf"), "a" : Infinity }

> db.c.ensureIndex({a:1})

> db.c.find({a:{$gt:0}})

2.5.5-pre-

> db.c.insert({a:Infinity})

Insert WriteResult({ "ok" : 1, "n" : 1 })

> db.c.find({a:{$gt:0}})

{ "_id" : ObjectId("528ffb986ce2fec2710a136f"), "a" : Infinity }

> db.c.ensureIndex({a:1})

> db.c.find({a:{$gt:0}})

{ "_id" : ObjectId("528ffb986ce2fec2710a136f"), "a" : Infinity }

Show

2.4.9-pre- > db.c.insert({a:Infinity}) > db.c.find({a:{$gt:0}}) { "_id" : ObjectId("528ffb985142cd7d1e23d1cf"), "a" : Infinity } > db.c.ensureIndex({a:1}) > db.c.find({a:{$gt:0}}) 2.5.5-pre- > db.c.insert({a:Infinity}) Insert WriteResult({ "ok" : 1, "n" : 1 }) > db.c.find({a:{$gt:0}}) { "_id" : ObjectId("528ffb986ce2fec2710a136f"), "a" : Infinity } > db.c.ensureIndex({a:1}) > db.c.find({a:{$gt:0}}) { "_id" : ObjectId("528ffb986ce2fec2710a136f"), "a" : Infinity }

Description

A document that has the value Infinity for a key that is indexed is not returned in queries that use that index in MongoDB version 2.4. Version 2.5 does not seem to have this issue. Seems like there should be a fix for 2.4 or this change in behavior between versions be documented (if it is intentional).

Attachments

Issue Links

is related to

SERVER-11617 Sorting with value of Infinity causes assertion

Closed

Activity

People

Assignee:: Benety Goh

Reporter:: Luke Lovett

Participants:: Benety Goh, Luke Lovett

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: Nov 23 2013 12:57:51 AM UTC

Updated:: Dec 10 2014 11:15:11 PM UTC

Resolved:: Dec 04 2013 05:18:32 PM UTC