Kbase P81619: SQL-92 query contining two or more JOINS may return error 7481
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Tests are done with 9.1D Service Pack 8
SQL-92 query containing at least two JOIN returns the error 7481
Sequence of joins influences the result of SQL-92 query
JOIN 1 placed before JOIN 2 gives correct result of query
JOIN 2 placed before JOIN 1 returns error 7481.
[JDBC Progress Driver]:Inconsistent types (7481)
[ODBC Progress Driver]:Inconsistent types (7481)
CAUSE:
Bug# 20040521-001
FIX:
Upgrade to 9.1E or higher. This issue was fixed in 100.0B01, 10.1A and 9.1E.