7 messages in com.mysql.lists.plusplusRe: Loss of float precision
FromSent OnAttachments
Warren Young24 Mar 2008 16:30 
Jim Wallace01 Apr 2008 11:48 
Warren Young01 Apr 2008 16:07 
Dave Bailey01 Apr 2008 16:31 
Warren Young01 Apr 2008 17:03 
Jim Wallace01 Apr 2008 17:40 
Warren Young01 Apr 2008 19:50 
Subject:Re: Loss of float precision
From:Warren Young (mysq@etr-usa.com)
Date:04/01/2008 05:03:34 PM
List:com.mysql.lists.plusplus

Dave Bailey wrote:

If you view the raw file and look for the definition of

Item_func_ieee754_to_string::val_str(String *str)

the comment specifies that 17 digits of precision are needed for double. It is also true that 9 digits are needed for single precision. I didn't believe it, but I tested it once with every possible value of a single precision float and found that there were cases where 8 digits was not enough to support a lossless conversion from float to string and back.

Well, OK... :) The patch is in svn now.