Subject | Stupid Programmer or a bug? |
---|---|
Author | Dalton Calford |
Post date | 2007-06-08T15:45:43Z |
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
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%.
Please someone, tell me that I am just having an off day and that I have
not found a bug in the group by code in Firebird 1.53
(and If it is me, what the %&$^ am I doing wrong - I think I need more
coffee)
Best regards
Dalton
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
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%.
Please someone, tell me that I am just having an off day and that I have
not found a bug in the group by code in Firebird 1.53
(and If it is me, what the %&$^ am I doing wrong - I think I need more
coffee)
Best regards
Dalton