Icon View Incident Report

Serious Serious
Reported By: Krisztian Kepes
Reported On: 5/6/2010
For: Version 2.03 Build 13
# 3208 INNER JOINs Combined with LEFT OUTER JOINs Not Producing Correct Results

I used the first query in DBISAM, but the result is wrong in EDB.

I replaced the first query with the second query, and it produces the correct result.

Wrong result:

select cikk.cikkszam, sum(bizal.mennyiseg) as mozgas
from cikk
left outer join bizal on (bizal.cikk=cikk.kod)
inner join bizfo on (bizfo.kod=bizal.kod) and
(bizfo.datum >= DATE '2010-01-01')
where cikk.raktar>0
and (cikk.Cikkszam BETWEEN '01' and '029999')
group by cikk.cikkszam, cikk.kod, cikk.nev, cikk.ubear, cikk.raktar

Correct result:

select cikk.cikkszam, sum(bizal.mennyiseg) as mozgas
from cikk
left outer join bizal on bizal.cikk=cikk.kod and bizal.kod in
(select kod from bizfo where bizfo.datum >= DATE '2010-01-01')
where cikk.raktar>0
and (cikk.Cikkszam BETWEEN '01' AND '029999')
group by cikk.cikkszam



Comments Comments
The problem occurred when a table that was the target of a LEFT OUTER JOIN was then joined to another table with an INNER JOIN.


Resolution Resolution
Fixed Problem on 5/16/2010 in version 2.03 build 14


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image