Kbase P30378: INDEXED-REPOSITION does not return correct records with BEGINS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/08/2010 |
|
Status: Unverified
SYMPTOM(s):
INDEXED-REPOSITION does not return the correct records with BEGINS
INDEXED-REPOSITION on a QUERY statement prevents BEGINS from using an index and subsequently the returned records are incorrect
Accented characters are not returned when using INDEXED-REPOSITION with a BEGINS operator
Accented characters are returned when the INDEXED-REPOSITION option is removed from the query using BEGINS
Accented characters are returned by the BEGINS query are not returned when using INDEXED-REPOSITION
smartFilter returns different results when using accented characters compared to FOR EACH and QUERY results.
smartFilter does not work with extended accented characters
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Bug# 19960201-010
FIX:
Add/include field containing accented characters in an index.
Remove INDEXED-REPOSITION option.