compatibilityversion 8 and later, by default all SQL ORDER BY clauses now obey the ASC and DESC flags, and
order ascending when no flag is given. In previous versions, an ORDER BY expression that contained $rank may have ordered
descending by default (or when ASC given), or descending when
ASC given, or changed ordering depending on presence of
Metamorph index etc.
This behavior may be altered with the [Texis] Legacy Version 7
Order By Rank setting in texis.ini, which defaults to off
compatibilityversion is 8 or later (on for 7 and earlier).
Caveat: When upgrading to Texis version 8 or later, existing scripts that use ORDER BY expressions containing $rank should be altered to explicitly use ASC or DESC as appropriate.