l Satterwhite
>Cc: mysql@lists.mysql.com
>Subject: Re: numeric comparisons
>
>On Mon, Nov 8, 2010 at 1:01 PM, Michael Satterwhite
>wrote:
>> While I don't know why the behavior changed, the comparison of floating
>> point
>> values has been an issue since the
On Mon, Nov 8, 2010 at 1:01 PM, Michael Satterwhite wrote:
> While I don't know why the behavior changed, the comparison of floating point
> values has been an issue since the day computers were created. In the last 10
> - 15 years, the comparisons have worked better, but it's still an issue. The
I know I can strip off the trailing zeros from the varchar, but there
must be a generic way to cast these so they compare properly as
numbers.
Cast() may happen to fix some rounding errors, but the only way to be
sure of getting rid of such rounding errors in float or double values is
to chang