Kbase P57990: Using '(Field > 1 AND Field < 10)' or BETWEENS in SQL query results in zero records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/3/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Using '(Field > 1 AND Field < 10)' in SQL query results in zero records
Using BETWEEN phrase in SQL query results in zero records
CAUSE:
Bug# 20031208-010
CAUSE:
The SQL query parser was not correctly applying where clause predicates in outer joins
FIX:
Upgrade to Progress 9.1D09 or later.
Upgrade to OpenEdge 10.0A01 or later.