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).