Icon View Incident Report

Serious Serious
Reported By: Andrew Hill
Reported On: 11/17/2008
For: Version 2.02 Build 3
# 2863 DISTINCT, UNION, EXCEPT, and INTERSECT Queries with More than 4 Columns Cause Incorrect Results

The following query causes incorrect results:

SELECT distinct id, 0, 0, 0, ABS(CAST(ReferenceDate - DATE '2008-10-20' AS INTEGER)) AS DaysDiff
FROM DayTest
WHERE id=100



Comments Comments
The problem was caused by the fact that the query DISTINCT functionality switches to a different type of processing once the number of SELECT columns is greater than 4, and there was an error in that functionality.


Resolution Resolution
Fixed Problem on 11/18/2008 in version 2.02 build 4


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