Support more missing() sort options

Description

We could introduce two more options:

  • consider the missing values as the greatest/farthest values of the result set, putting it last in ascending mode or first in descending mode

  • consider the missing values as the smallest/nearest values of the result set, putting it first in ascending mode or last in descending mode

As a workaround the user can now simulate these two options just using missing().use(…) and providing there a very large/small value. Or using missing().last() or missing().first() depending on the sort order.

Environment

None

Assignee

Unassigned

Reporter

Fabio Massimo Ercoli

Labels

None

Suitable for new contributors

None

Pull Request

None

Feedback Requested

None

Fix versions

Affects versions

Priority

Minor