Kbase P70561: LEFT OUTER JOIN crashes server from SQL Explorer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
SYMPTOM(s):
LEFT OUTER JOIN crashes server
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20217
[JDBC Progress Driver]:-20217
LEFT OUTER JOIN with (+) in where close
example:
SELECT * FROM T1, T2 WHERE T1.C1 (+) = T2.C3;
CAUSE:
Bug# 20040305-002
FIX:
Upgrade to 9.1E service pack 1 or
Upgrade to and 10.1A