Currently, missing values are treated as nulls and appear either first by default (using ASC sorting) or last for DESC sorting.
It would be useful to further enhance the sorting similar to FieldSortBuilder to specify whether the missing values should appear last (_last) or first (_first). In SQL this would allow implementing NULLS FIRST/LAST functionality as well as offer the expected behavior (that NULLs have a fixed position regardless of ordering).
Currently, missing values are treated as
nulls and appear either first by default (usingASCsorting) or last forDESCsorting.It would be useful to further enhance the sorting similar to
FieldSortBuilderto specify whether the missing values should appear last (_last) or first (_first). In SQL this would allow implementingNULLS FIRST/LASTfunctionality as well as offer the expected behavior (that NULLs have a fixed position regardless of ordering).