Hi all,

I have this very odd problem I can't explain so I'm hoping one of you
can. I'll try to keep this post as short and simple as possible:

I have a table named rt_hour with this table lay-out:
+-----------+------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+-------------------+-------+
| server_id | int(11) | NO | PRI | | |
| date | timestamp | NO | PRI | CURRENT_TIMESTAMP | |
| rt | float(6,2) | NO | | | |
+-----------+------------+------+-----+-------------------+-------+

This table contains some records, including this one:
+-----------+---------------------+------+
| server_id | date | rt |
+-----------+---------------------+------+
| 9 | 2008-02-03 17:30:00 | 0.78 |
+-----------+---------------------+------+

Running this query shows me that record:
SELECT * FROM rt_hour WHERE (server_id = 9 AND date = '2008-02-03
17:30:00');

However, when I run this query, it returns nothing!
SELECT * FROM rt_hour WHERE (server_id = 9 AND date = '2008-02-03
17:30:00' AND rt = 0.78);

If you know how this happens, please let me know. Is this a bug in my
MySQL version (5.0.32, running on i468 Linux) or is there a problem with
the table lay-out?

Kind Regards,
Vincent van Scherpenseel