Kbase P83323: LEFT OUTER JOIN does not return the same number of records using 9.1D SQL-92 engine as it does in pr
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
LEFT OUTER JOIN does not return the correct number of records via SQL-92.
A different number of records is returned compared to the number returned using a previous version of Progress.
CAUSE:
The way LEFT OUTER JOINS are processed in Progress 9.1D has changed from previous versions.
In previous versions, we applied all the conditions in the WHERE clause, plus the join condition in the ON clause, to determine the final result set.
In 9.1D and onwards, we use the join conditions in the ON clause to determine the results of the FROM clause. Then we apply the conditions in the WHERE clause to the result set retrieved in the FROM clause.
FIX:
Change the query to adhere to the 9.1D LEFT OUTER JOIN processing method so the correct results are returned.