mysqlimport bug coercing long floats
Just ran into an error, using mysqlimport to pull in a tab-delimited file with long float values in BIGINT columns. When trying to import the value
866.897575000000057458
as an int, mysqlimport turned it into 866897575000000057458 – a bit off!
mysqlimport Ver 3.5 Distrib 5.0.45, for redhat-linux-gnu (x86_64)
(maybe this is fixed in 5.1, don’t know)