Re: MySQL FLOAT is flaky!

2001-01-15 Thread Tomi Junnila
* Petras Virzintas <[EMAIL PROTECTED]> wrote on 15.01.01 23:55: > The column type "FLOAT" seems to be flaky in MySQL 2.23.24-beta. I > wouldn't mind if it was a rounding issue but the value 66.66 becomes > 66.69 and 77.77 becomes 77.75! Sounds to me like a typical binary rounding

MySQL FLOAT is flaky!

2001-01-15 Thread Petras Virzintas
The column type "FLOAT" seems to be flaky in MySQL 2.23.24-beta. I wouldn't mind if it was a rounding issue but the value 66.66 becomes 66.69 and 77.77 becomes 77.75! To reproduce the problem follow the steps below: Step 1: Creat Table create table TestAmt ( id int(8) not nu