Reported By: Charles Tyson Reported On: 2/29/2008 For: Version 1.08 Build 1
# 2557Using 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'
ResolutionFixed Problem on 3/1/2008 in version 1.09 build 1