Hi,

I've got a few SQL Queries that behave strangely with FB v2.5 Beta 2:

1st the OK situations:

SELECT FIRST 3 Dur_Total FROM HTTP_Events
gives 3 result rows: 0.5575, 1.2298, 0.7567

SELECT FIRST 2 SKIP 1 Dur_Total FROM HTTP_Events
gives 2 result rows: 1.2298, 0.7567

Now the problem statements:

SELECT FIRST 2 SKIP 1 Min(Dur_Total) FROM HTTP_Events
gives 0 result rows????? Correct answer would be 1 row with value 0.7567
The same happens with MIN(), MAX(), AVG(), SUM() etc...
Event COUNT() gives an empty result...

And other non-working statements:

SELECT FIRST 1 SKIP 0 Min(Dur_Total) FROM HTTP_Events
gives 1 result row: 0.0000 - Which is wrong, should be 0.5575

SELECT FIRST 1 SKIP 0 Avg(Dur_Total) FROM HTTP_Events
gives 1 result row: 9.7764 - Wrong again ...

SELECT FIRST 1 SKIP 0 Max(Dur_Total) FROM HTTP_Events
gives 1 result row: 62.1193 - This is even stranger....

FB version: WI-T6.3.0.24643 Firebird 2.5 Beta 2

The HTTP_Events table DUR_Total field is a FLOAT.

Has anyone encountered this before? Or am I using the MIN,MAX,AVG etc.
functions wrong somehow?


Regards,
Kim Sandell