Subject Re: [firebird-support] Stupid Programmer or a bug?
Author Helen Borrie
Hi Dalton, LTNS!

At 01:45 AM 9/06/2007, you wrote:
>Ok, I have to admit it has been a very long time since I used group by,
>so I am admitting that this may be my fault from the start but.......
>I have a table (report), with four columns
>Zone integer
>Description varchar(50)
>StartTime timestamp
>Duration integer
>So I use IB_SQL to create a simple query
>select zone, description, count(description) as calls, sum(duration)
>from report group by calls order by description

OK, you should be getting an exception for this - you have to have
all of the output fields other than the aggregating ones (count, sum)
in the GROUP BY list. In ancient times your query would have been
legal but not since at least Fb 1.5.

>I try to prepare the query, but instead of an error, I get nothing.
>IB_SQL looks to be waiting for the server to return but the server's CPU
>is sitting at 0%.

The latest build of IB_SQL handles exceptions by hanging up, unfortunately.