[SERVER-11830] geo near query does not cover entire length of equator - MongoDB Jira

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major - P3
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 2.5.5
Component/s: Geo
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 }

Operating System:
ALL

Steps To Reproduce:

Hide

2.5.5-pre-

> db.c.insert({loc:{type:"Point",coordinates:[0,0]}})

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

> db.c.insert({loc:{type:"Point",coordinates:[-1,0]}})

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

> db.c.ensureIndex({loc:"2dsphere"})

> db.c.find({loc:{$nearSphere:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}})

{ "_id" : ObjectId("528fa9b06ce2fec2710a135b"), "loc" : { "type" : "Point", "coordinates" : [  -1,  0 ] } }

> db.c.find({loc:{$near:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}})

{ "_id" : ObjectId("528fa9b06ce2fec2710a135b"), "loc" : { "type" : "Point", "coordinates" : [  -1,  0 ] } }

> db.runCommand({geoNear:"c", near:{type:"Point",coordinates:[180,0]},spherical:true})

	"ns" : "georepro.c",

	"results" : [

			"dis" : 19926073.25883961,

			"obj" : {

				"_id" : ObjectId("528fa9b06ce2fec2710a135b"),

				"loc" : {

					"type" : "Point",

					"coordinates" : [

-1,

],

	"stats" : {

		"nscanned" : 2,

		"avgDistance" : 19926073.25883961,

		"maxDistance" : 19926073.25883961,

		"time" : 7

},

	"ok" : 1

2.4.9-pre-

> db.c.insert({loc:{type:"Point",coordinates:[0,0]}})

> db.c.insert({loc:{type:"Point",coordinates:[-1,0]}})

> db.c.ensureIndex({loc:"2dsphere"})

> db.c.find({loc:{$nearSphere:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}})

{ "_id" : ObjectId("528fa9b05142cd7d1e23d1bb"), "loc" : { "type" : "Point", "coordinates" : [  -1,  0 ] } }

{ "_id" : ObjectId("528fa99e5142cd7d1e23d1ba"), "loc" : { "type" : "Point", "coordinates" : [  0,  0 ] } }

> db.c.find({loc:{$near:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}})

{ "_id" : ObjectId("528fa9b05142cd7d1e23d1bb"), "loc" : { "type" : "Point", "coordinates" : [  -1,  0 ] } }

{ "_id" : ObjectId("528fa99e5142cd7d1e23d1ba"), "loc" : { "type" : "Point", "coordinates" : [  0,  0 ] } }

> db.runCommand({geoNear:"c", near:{type:"Point",coordinates:[180,0]},spherical:true})

	"ns" : "georepro.c",

	"results" : [

			"dis" : 19926073.261345826,

			"obj" : {

				"_id" : ObjectId("528fa9b05142cd7d1e23d1bb"),

				"loc" : {

					"type" : "Point",

					"coordinates" : [

-1,

},

			"dis" : 20037392.09826071,

			"obj" : {

				"_id" : ObjectId("528fa99e5142cd7d1e23d1ba"),

				"loc" : {

					"type" : "Point",

					"coordinates" : [

0,

],

	"stats" : {

		"time" : 5,

		"nscanned" : 2,

		"avgDistance" : 19981732.679803267,

		"maxDistance" : 20037392.09826071

},

	"ok" : 1

Show

2.5.5-pre- > db.c.insert({loc:{type:"Point",coordinates:[0,0]}}) Insert WriteResult({ "ok" : 1, "n" : 1 }) > db.c.insert({loc:{type:"Point",coordinates:[-1,0]}}) Insert WriteResult({ "ok" : 1, "n" : 1 }) > db.c.ensureIndex({loc:"2dsphere"}) > db.c.find({loc:{$nearSphere:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}}) { "_id" : ObjectId("528fa9b06ce2fec2710a135b"), "loc" : { "type" : "Point", "coordinates" : [ -1, 0 ] } } > db.c.find({loc:{$near:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}}) { "_id" : ObjectId("528fa9b06ce2fec2710a135b"), "loc" : { "type" : "Point", "coordinates" : [ -1, 0 ] } } > db.runCommand({geoNear:"c", near:{type:"Point",coordinates:[180,0]},spherical:true}) { "ns" : "georepro.c", "results" : [ { "dis" : 19926073.25883961, "obj" : { "_id" : ObjectId("528fa9b06ce2fec2710a135b"), "loc" : { "type" : "Point", "coordinates" : [ -1, 0 ] } } } ], "stats" : { "nscanned" : 2, "avgDistance" : 19926073.25883961, "maxDistance" : 19926073.25883961, "time" : 7 }, "ok" : 1 } 2.4.9-pre- > db.c.insert({loc:{type:"Point",coordinates:[0,0]}}) > db.c.insert({loc:{type:"Point",coordinates:[-1,0]}}) > db.c.ensureIndex({loc:"2dsphere"}) > db.c.find({loc:{$nearSphere:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}}) { "_id" : ObjectId("528fa9b05142cd7d1e23d1bb"), "loc" : { "type" : "Point", "coordinates" : [ -1, 0 ] } } { "_id" : ObjectId("528fa99e5142cd7d1e23d1ba"), "loc" : { "type" : "Point", "coordinates" : [ 0, 0 ] } } > db.c.find({loc:{$near:{$geometry:{type:"Point",coordinates:[180,0]},$maxDistance:10e1000000}}}) { "_id" : ObjectId("528fa9b05142cd7d1e23d1bb"), "loc" : { "type" : "Point", "coordinates" : [ -1, 0 ] } } { "_id" : ObjectId("528fa99e5142cd7d1e23d1ba"), "loc" : { "type" : "Point", "coordinates" : [ 0, 0 ] } } > db.runCommand({geoNear:"c", near:{type:"Point",coordinates:[180,0]},spherical:true}) { "ns" : "georepro.c", "results" : [ { "dis" : 19926073.261345826, "obj" : { "_id" : ObjectId("528fa9b05142cd7d1e23d1bb"), "loc" : { "type" : "Point", "coordinates" : [ -1, 0 ] } } }, { "dis" : 20037392.09826071, "obj" : { "_id" : ObjectId("528fa99e5142cd7d1e23d1ba"), "loc" : { "type" : "Point", "coordinates" : [ 0, 0 ] } } } ], "stats" : { "time" : 5, "nscanned" : 2, "avgDistance" : 19981732.679803267, "maxDistance" : 20037392.09826071 }, "ok" : 1 }

Description

It seems that $near, $nearSphere and geoNear in version 2.5 of mongodb won't return documents whose longitude is 180 degrees away from that in the coordinates given in the query. Version 2.4 will return these documents.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

server11830.js
0.9 kB
Nov 25 2013 02:36:00 PM UTC

Activity

People

Assignee:: Benety Goh

Reporter:: Luke Lovett

Participants:: Benety Goh, Githook User, Luke Lovett

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: Nov 22 2013 07:12:47 PM UTC

Updated:: Jul 11 2016 05:40:37 PM UTC

Resolved:: Nov 25 2013 08:24:10 PM UTC