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

Adding NULL sort order configuration when using sort() queries

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Backlog
    • Major - P3
    • Resolution: Unresolved
    • None
    • None
    • Querying
    • Query Optimization

    Description

      At the moment, the NULL order fetching is decided upon the sort query type (DESC,ASC).

      If the query is done on field X in a DESC order the NULLs of field X will be presented last, while in an ASC order the NULLs of field X will be presented first. I saw many requests on having the ability to decide the fetch positions of the NULLs in the ordered field.

      Can it be added as an optional flag to the query syntax with a default behavior?

      Attachments

        Issue Links

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              pavel.duchovny@mongodb.com Pavel Duchovny
              Votes:
              22 Vote for this issue
              Watchers:
              30 Start watching this issue

              Dates

                Created:
                Updated: