Kbase P157856: SQL LIKE predicate returns inconsistent results
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/12/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL LIKE predicate returns inconsistent results
A query using LIKE predicate with no wildcards returns wrong results
SQL query...
SELECT * FROM PUB.Table WHERE F1 LIKE 'abc';
...retreves all records with field F1 begining with 'abc' as if the value for LIKE predicate was 'abc%'
Discrepancy initially doesn't appear until the following query is executed:
SELECT * FROM PUB.Table WHERE F1 LIKE '_';
FACT(s) (Environment):
UNIX
Windows
OpenEdge 10.1x
OpenEdge 10.2x
CAUSE:
Bug# OE00194245
FIX:
At the moment, the only available workaround is to use equal sign instead of a LIKE predicate when the value is supposed to be fixed and no pattern in the search condition is required