ORDER BY $rank-$expression$ Sorting is Consistent - Caveat

With 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 when 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.


Copyright © Thunderstone Software     Last updated: Jul 17 2021
Copyright © 2021 Thunderstone Software LLC. All rights reserved.