Kbase P1128: ADM2. Problems with BEGINS and INDEX-REPOSITION within an SD
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/05/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1B
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Problems with using SDO in combination with collation table and extended characters.
Using a combination Index Reposition with SDO Doing a "WHERE field BEGINS string" will not always return all the records.
CAUSE:
INDEX-REPOSITION makes it impossible for the BEGINS option to use the existing index.
CAUSE:
BUG# 20020410-018
FIX:
Instead of the use of BEGINS in the WHERE Clause.
I.E. Doing a "WHERE field BEGINS oo"
use the following:
WHERE Name >= "oo" AND Name <= "oo" + chr(255)