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?
- is related to
-
SERVER-5065 a missing field nested within an array is sorted as 'null', even if the same field exists inside another array element
- Closed