Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-11830

geo near query does not cover entire length of equator

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 2.5.5
    • Affects Version/s: None
    • Component/s: Geo
    • Environment:
    • ALL
    • 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,
						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
}
      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 }

      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.

        1. server11830.js
          0.9 kB
          Benety Goh

            Assignee:
            benety.goh@mongodb.com Benety Goh
            Reporter:
            luke.lovett Luke Lovett
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: