[fpc-devel] MySQL 5.1 and Double (trouble)

[Andrew Brunner]

Can someone check the status of update if the bind parameter for
double decimal values?

I'm getting unexpected rounding errors after updating - the data in
the column looks different than what was specified during the update
statement.

Value: double;
Query.Params.ParamByName(sName).AsFloat:=Value;

1.) Update Value                  : 40734.825668912039
2.) Actual Value after update : 40734.825668912
3.) Actual Value on read       : 40734.825668912003

As far as I know this is a relatively new problem.  Could be with
Ubuntu but was someone doing MYSQL work lately?