Rounding

Dear All,

 

If I create a simple table with a single column of type FLOAT and I
insert 2 values say 5.8 and 5.9.

 

When I issue 'SELECT * FROM t_table where f_float > 5.8, I get what I
expect.

 

When I issue 'SELECT * FROM t_table where f_float < 5.9, I get what I
expect.

 

When I issue 'SELECT * FROM t_table where f_float >= 5.8 I get what I
expect.

 

When I issue 'SELECT * FROM t_table where f_float <= 5.9, I only get 1
row returned (i.e. 5.8 and not 5.9, which is not what I expect).

 

Did I miss something?

 

MySQL version 3.23.54.

 

Regards,

Scott