MarkLogic SQL ORDER-BY Keyword
Starting in MarkLogic 9.0-9, ORDER-BY
ordering on NULL is set to NULLS LAST
. This changes default behavior for nulls in query results and therefore may cause backwards incompatibility for certain queries (unless the Optic Nulls Smallest On
trace event is turned on).