Icon View Incident Report

Serious Serious
Reported By: Carlton Craighead
Reported On: 8/10/2008
For: Version 2.01 Build 4
# 2746 UNION/EXCEPT/INTERSECT Queries with an ORDER BY Clause on Columns Not in the SELECT List Causes AV

The following statement causes the following exception:

ElevateDB Error #9999 Access violation at address 00512325 in module 'cdsrvr.exe'. Read of address 00000000

select name, code from intitems where intitemid = 4
union all
select name, code from intitems where parentid = 4 and inactive = false order by displayorder

Comments Comments and Workarounds
The workaround is to include the ORDER BY column in the SELECT columns list for both queries being UNIONed together.

Resolution Resolution
Fixed Problem on 8/11/2008 in version 2.01 build 5

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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial