Kbase P129802: SQL: Complex WHERE clause generates "Server crash likely." error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/06/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
SYMPTOM(s):
SQL: Complex WHERE clause generates "Server crash likely." error
The offending WHERE clause looks like this:
WHERE ((T4.C0 = T1.C0
AND T4.C0 = T2.C0)
AND ((T4.C1 = T2.C1
OR T4.C1 IS NULL
AND T2.C1 IS NULL)
AND T4.C0 = T3.C0))
AND ((T4.C1 = T3.C1
OR T4.C1 IS NULL
AND T3.C1 IS NULL)
AND T4.C2 = T3.C2)
ORDER BY 1,
2,
3
Where Tn indicates the nth table and Cn indicates the nth column.
CAUSE:
Bug# OE00166439
FIX:
Upgrade to OpenEdge 10.1C01 or later