[SERVER-6138] skip does not skip on a '2d' near search. Created: 20/Jun/12  Updated: 15/Feb/13  Resolved: 14/Jan/13

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.0.6, 2.3.2
Fix Version/s: None

Type: Bug Priority: Minor - P4
Reporter: Andrea Fontana Assignee: hari.khalsa@10gen.com
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux


Issue Links:
Duplicate
duplicates SERVER-5390 geo query with explicit skip and no e... Closed
Operating System: ALL
Participants:

 Description   

Some code to reproduce bug:

> db.geo.insert(

{coords:[0,1], field: 1}

)
> db.geo.insert(

{coords:[2.3,1.4], field: 2}

)
> db.geo.insert(

{coords:[1,5], field: 0}

)
> db.geo.ensureIndex(

{coords: "2d"}

)

Then:

> db.geo.find({coords : {$near:[1,1]}})

{ "_id" : ObjectId("4fe1e02e033df621f3c59861"), "coords" : [ 0, 1 ], "field" : 1 } { "_id" : ObjectId("4fe1e037033df621f3c59862"), "coords" : [ 2.3, 1.4 ], "field" : 2 } { "_id" : ObjectId("4fe1e03f033df621f3c59863"), "coords" : [ 1, 5 ], "field" : 0 }

Seems ok!

> db.geo.find({coords : {$near:[1,1]}}).skip(1)

Bug?

> db.geo.find({coords : {$near:[1,1]}}).skip(1).limit(1)

{ "_id" : ObjectId("4fe1e037033df621f3c59862"), "coords" : [ 2.3, 1.4 ], "field" : 2 }

?!

Btw my php code doesn't work with limit() setted.


Generated at Thu Feb 08 03:10:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.