Duplicate multi-item strlst index results removed - Caveat
In version 7, duplicate result rows caused by strlst indexes (with indexvalues set to splitstrlst, the default) are removed, so that results are more consistent with linear searches: a given row should be represented at most once in the results.
| Caveat: This means that many ORDER BY, relational etc. queries that use strlst indexes will have a lower total result count. The same rows will be returned, just without duplicates. |
This behavior change is rolled back if <vxcp compatibilityversion> is
set to 6.
Copyright © Thunderstone Software Last updated: Apr 15 2024