Icon View Incident Report

Serious Serious
Reported By: John Hay
Reported On: 7/3/2009
For: Version 2.02 Build 14
# 3022 Sub-Select Queries that Reference the Same Table as the Outer Query Can Cause Incorrect Results

In the following query (from your data) is the same for all records (the correlation part appears to be broken).

select book,
(select sum(sequence) from books b1 where b1.book=books.book) as total
from books



Comments Comments
The problem was that EDB was not properly handling the name resolution for the b1 and books correlation names, thus binding the inner query's books.book correlated reference to the inner query's books table instead of the outer query's books table.


Resolution Resolution
Fixed Problem on 7/4/2009 in version 2.02 build 15


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