Kbase P11244: SQL-92: Queries containing NOT IN predicate in combination with INNER JOIN return wrong result sets
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/01/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
SQL-92 SELECT statements return wrong results.
The SELECT statement contains the NOT IN predicate in combination with INNER JOIN.
The SQL-92 NOT IN predicate returns different results than the <> operator.
CAUSE:
Bug# 20021011-005
FIX:
Upgrade to Progress 9.1D Service Pack 1 or above.
- OR -
As a workaround, use the <> , != or ^= relational operators.