IN behavior change - Caveat

Caveat: The IN operator behaves differently in Texis version 7 and later - it acts more like the new SUBSET operator than INTERSECT. Thus, it is true (matches) if and only if all left-side value(s) are present on the right, not just if any are present (as in version 6 and earlier).

The version 6 behavior can be restored globally with the inmode SQL property (or use the INTERSECT operator); it is also restored when <vxcp compatibilityversion> is set to 6. The IN operator also utilizes indexes more effectively in version 7, which is aided by the new indexvalues SQL property.

Copyright © Thunderstone Software     Last updated: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.