Kbase P11323: Executing a Left Join with SQL code fails with error 7481
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/10/2008 |
|
Status: Verified
SYMPTOM(s):
Executing a Left Join with SQL code.
Fails with error:
Error: === SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20008
[JDBC Progress Driver]:Inconsistent types (7481)
. (8933)
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
Windows
CAUSE:
Bug # OE00075512
FIX:
1.Upgrade to 9.1D08 or later.
2.A workaround is to use the BETWEEN predicate instead.