Kbase P10278: A SQL statement that has a left join and uses the LIKE predi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Using SQL92
A SQL statement that has a left join and uses the LIKE predicate results in no data being returned
CAUSE:
Bug# 20020916-043
CAUSE:
The optimizer would try to optimize the phrase LIKE '%' when it should not
FIX:
This bug has been fixed in 9.1D Service Pack 2 (9.1D02)