Kbase 41244: 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 |
10/05/1998 |
|
Solution ID: P11244
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
Queries containing NOT IN predicate in combination with INNER JOIN
return wrong result sets.
CAUSE:
Known Issue
FIX:
As a workaround, use the <> , != or ^= relational operator