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

Duplicate documents while using "Sort" with "Pagination"

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 4.4.0
    • Component/s: Querying
    • None
    • ALL
    • Hide

      Environment with Issue

      Server : Windows Server 2016
      mongo db version: 4.4.0
      driver: 2.10.2

       

      Step

      • Query a collection with more than 50 documents with SortByDescending and Pagination (page size 10)

      Result

      • Duplicate documents are returned by the driver from second page onwards.
      Show
      Environment with Issue Server : Windows Server 2016 mongo db version: 4.4.0 driver: 2.10.2   Step Query a collection with more than 50 documents with SortByDescending and Pagination (page size 10) Result Duplicate documents are returned by the driver from second page onwards.

      When we query MongoDB in below environment with SortByDescending and Pagination, MongoCSharp driver is always returning duplicate documents from the second page onwards. We are setting page size as 10.

      Issue is not observed when we remove SortByDescending.

      Environment with Issue

      Server : Windows Server 2016
      mongo db version: 4.4.0
      driver: 2.10.2

       

      Environment without Issue

      Server : Windows Server 2016
      mongo db version: 4.0.6
      driver: 2.10.2

            Assignee:
            edwin.zhou@mongodb.com Edwin Zhou
            Reporter:
            ummerirshadk@gmail.com Ummer Irshad
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: