Subject | Strange FIRST n SKIP m + Function behaviour in FB 2.5 Beta 2 |
---|---|

Author | Kim Sandell (Celarius) |

Post date | 2009-09-22T21:11:46Z |

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

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