[SERVER-7987] Combination of geospatial and sort queries causes skip and limit to fail Created: 19/Dec/12  Updated: 01/Apr/13  Resolved: 17/Jan/13

Status: Closed
Project: Core Server
Component/s: Geo, Querying
Affects Version/s: 2.0.8, 2.2.0
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Julien Chaumond Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Tested on two different installs on Ubuntu and Mac OS X.


Attachments: Zip Archive dump.zip     File testcase.js    
Issue Links:
Duplicate
duplicates SERVER-5800 Refactor 2D $geoWithin into new query... Closed
Operating System: ALL
Steps To Reproduce:

Attached are:

  • a sample BSON dump (16 elements)
  • two sample queries (to be run in Mongo shell) exhibiting the issue. The only difference between those two queries is the skip() parameter. (First page, second page).
Participants:

 Description   

I need to perform a geospatial query while sorting on another attribute, and skip/limit results so as to paginate search results.

(For context, the app in question is http://jemem.fr/recherche/coach/sportif/paris – it's a Yelp-like interface where you search for POIs near a geocoded location, sorted by a parameter – here Reviews, Distance, or Price – while paginating results. Warning, it's in French!).

Skip and limit fail, i.e. the query results are not properly paginated (some items are repeated when you change page, while some other items never show up).



 Comments   
Comment by Eliot Horowitz (Inactive) [ 17/Jan/13 ]

SERVER-5800

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