Re: Serious BUG in 3.23!

[Dan Nelson]

In the last episode (Feb 22), Tim Bunce said:
> All very true, but it ought to be possible for mysqld to do the right
> thing for simple constants that have not undergone any manipulation
> (addition, subtraction etc).

The problem is that 0.2 is not a simple constant.  In binary, it's
represented as .0011(0011), repeating until infinity.  It's possible
that float->double or double->float casts could round in different
directions, making even direct comparison fail.  If you want accurate
fractional amounts, use the DECIMAL field type.

-- 
	Dan Nelson
	dnelson@stripped