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: Apr 15 2024