Icon View Incident Report

Serious Serious
Reported By: John Hay
Reported On: 3/24/2010
For: Version 2.03 Build 9
# 3181 Mixing Column References with Aggregate Functions Causes #700 Error

ElevateDB allows the following first query, but not the second.


SELECT columna+columnb,count(*)+sum(columna)+sum(columnb) FROM Table
GROUP BY columna,columnb
Error #700:

SELECT columna+columnb,count(*)+columna FROM Table
GROUP BY columna,columnb

Comments Comments and Workarounds
ElevateDB had a self-imposed check on mixing aggregates with column references that wasn't necessary, and that has been removed.

Resolution Resolution
Fixed Problem on 4/9/2010 in version 2.03 build 10

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