hi,
please help me... i can't understand why are my doubles incorrect.
create table test (dnum double(20,5));
insert into test values(8999999999999998);
insert into test values(8999999999999998.0001);
insert into test values(899999999999998.0001);
insert into test values(89999999999998.0001);
insert into test values(1.0001);
select * from test;
+------------------------+
| dnum |
+------------------------+
| 8999999999999998.00000 |
| 8999999999999997.00000 |<<<<<<<<<<<<<<< HERE
| 899999999999998.00000 |<<<<<<<<<<<<<<< HERE
| 89999999999998.00000 |<<<<<<<<<<<<<<< HERE
| 1.00010 |
+------------------------+
intel PII-450 / debian-2.2.19 / mysql 3.23.32
intel PIII-833 / debian-2.2.19 / mysql 3.23.37
thanx
Attila Soki
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
