Icon View Incident Report

Serious Serious
Reported By: Gienek Majonez
Reported On: 5/22/2009
For: Version 2.02 Build 13
# 3000 Executing a UNION Query with Expressions in the SELECT List Can Cause AV

We have small problem with "EDB 2.02b13" unicode when try to execute the following query:

Error message:
ElevateDB Error #9999 Access violation at address 00517DFB in module 'edbsrvr.exe'. Read of address 00000010

SELECT
 GGG.AAA,
 GGG.OOO as "BBB",
 GGG.VVV as "CCC",
 RRR."TTN",
 RRR.TTC,
 RRR."TTV",
 RRR.TTK,
 RRR.OOO as "XXX",
 COUNT( QQQ.AAA ) as "WWW"
FROM
 GGG
LEFT JOIN 
 RRR ON
 GGG.AAA = RRR.AAA
LEFT JOIN
 QQQ ON
 (
   ( GGG.AAA = QQQ.AAA )
   AND
   (
     ( GGG.OOO = QQQ.ZZZ )
     OR
     (
       ( GGG.OOO = RRR.OOO ) AND
       ( QQQ.ZZZ IS NULL )
     )
   )
 )
GROUP BY
 QQQ.AAA,
 BBB

UNION

/* QUERY2 */
SELECT
 QQQ.AAA,
 CASE
   WHEN QQQ.ZZZ IS NULL THEN RRR.OOO
   ELSE QQQ.ZZZ
 END BBB,
 GGG.VVV as "CCC",
 RRR."TTN",
 RRR.TTC,
 RRR."TTV",
 RRR.TTK,
 RRR.OOO as "XXX",
 COUNT( QQQ.AAA ) as "WWW"
FROM
 QQQ
LEFT JOIN
 RRR ON
 QQQ.AAA = RRR.AAA
LEFT JOIN
 GGG ON
 (
   ( RRR.AAA = GGG.AAA )
   
   AND
   
   (
     ( GGG.OOO = QQQ.ZZZ )

     OR

     (
       ( GGG.OOO = RRR.OOO ) AND
       ( QQQ.ZZZ IS NULL )
     ) 
   )
 )
 
WHERE

 GGG.VVV IS NULL
 
GROUP BY

 QQQ.AAA,
 BBB



Resolution Resolution
Fixed Problem on 5/24/2009 in version 2.02 build 14


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