Kbase P97094: SQL-92 Query returns wrong result set when the query includes JOINS, LIKE predicate and the percent
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/04/2005 |
|
Status: Verified
SYMPTOM(s):
SQL-92 Query returns wrong result set
Query includes JOINS
Query includes LIKE predicate
Query includes the percent '%' pattern indicator
Optimizer uses a case sensitive dynamic index scan
The column collation is NOT case sensitive
CAUSE:
Bug# 20041116-028
FIX:
Upgrade to 9.1E01 or later.
If upgrade is not possible, the following can be used as a workaround:
1. Use the RTRIM function,
2. Use the UCASE function, or
3. Make all the data in the fields involved CAPITAL.