I use Firebird 1.5.2-473, and until now when there was a problem with
the query result always was my mistake, but this time I checked the
query carefully and I think maybe there is a bug.
This is the case: I have a table with one date field (date of
admission) and one time field (time of admission), if I use a select
query with ascending order I get the right data:

select NREC,DATE_ADMIN,TIME_ADMIN
from INGRESOS
where ID=12
order by DATE_ADMIN,TIME_ADMIN

NREC DATE_ADMIN TIME_ADMIN
21 29/01/2004 10:00:00
4 30/04/2004 2:05:00
8 30/04/2004 3:00:00
20 19/05/2004 16:06:00

But if I try it in the reverse order, descending, I get an amazing result:

select NREC,DATE_ADMIN,TIME_ADMIN
from INGRESOS
where ID=12
order by DATE_ADMIN,TIME_ADMIN desc

NREC DATE_ADMIN TIME_ADMIN
21 29/01/2004 10:00:00
8 30/04/2004 3:00:00
4 30/04/2004 2:05:00
20 19/05/2004 16:06:00

I copied real data in this message.

Does anyone know about this problem? Am I completely blind and doing
something wrong?