Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread AV in ElevateDB Manager 1.08b1
Fri, Feb 29 2008 3:07 AMPermanent Link

Charles Tyson
(1.08b1)

Tim,

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

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

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

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

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.  (The result set is meaningless, but it
executes)
Fri, Feb 29 2008 8:45 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Charles,

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

I'll make sure that this is corrected in the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image