Icon View Incident Report

Serious Serious
Reported By: Guenter Angerer
Reported On: 6/16/2001
For: Version 2.10 Build 1
# 808 Using Nested LEFT OUTER JOINs in SQL SELECT Statement Causes Incorrect Result

Execute this query in 2.10 and you will see that first record has a lot of entries, but there should only be one. I tested with an old exe (DBISAM 2.08 I think) and there the result is ok.

   SELECT table1.field2,
          table2.field3,
          table3.field4,
          table4.field5,
          table5.field6
     FROM table1
          INNER JOIN table2
                  ON table1.field1 = table2.field1
          INNER JOIN table3
                  ON table2.field1 = table3.field1
          LEFT OUTER JOIN table4
                       ON table3.field1 = table4.field1
          LEFT OUTER JOIN table5
                       ON table4.field1 = table5.field1



Comments Comments
This problem was introduces in 2.10 due to some changes in the internal join processing to streamline the code and make it easier to fix. Note that this problem *only* affects nested LEFT OUTER JOINs (including LEFT OUTER JOINs that are nested inside of INNER JOINs), it does not affect nested INNER JOINs.


Resolution Resolution
Fixed Problem on 6/18/2001 in version 2.11 build 1
Image