View Incident Report

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 and Workarounds

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

Resolution

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap