Icon View Incident Report

Serious Serious
Reported By: Charles Tyson
Reported On: 2/29/2008
For: Version 1.08 Build 1
# 2557 Using a Sub-Query in the SELECT Column List with a GROUP By Query Causes an AV

Most of my bad SQL just results in an ElevateDB exception, but this causes an AV in EDBmgr:

Access violation at address 0056F8ED in module 'edbmgr.exe'. Read of address 00000008

If you remove either line 2 (the subselect) or line 5 (the HAVING clause), everything is fine.

Table1
------
sometext varchar(20)
somedate date

Sample data
-----------
'Hello' 2008-01-01
'Goodbye' 2008-01-02

SQL
----------
select sometext, somedate
, (select min(somedate) from table1) as mindate
from table1
group by sometext, somedate
having sometext='Hello'



Resolution Resolution
Fixed Problem on 3/1/2008 in version 1.09 build 1
Image