Re: missing 7th digit in float
Sergei Golubchik <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi! On Oct 16, [email protected] wrote: > Hi all, > > my environment: WindowsNT4 with SP6, mysql4.0.15-max-nt > A select from a float field created with > create table ... (..., float) > or with > create table ... (..., float(24)) > returns only 6 significant digits - the standard requires 7! What do you mean "the standard requires 7" ? As far as I see the standard specifies: <approximate numeric type> ::= FLOAT [ <left paren> <precision> <right paren> ] | REAL | DOUBLE PRECISION <precision> ::= <unsigned integer> ... Syntax Rules 11) If a <precision> is omitted, then an implementation-defined <precision> is implicit. Thus, it's "implementation-defined". > Only > create table ... (..., float(24,7)) > works as expected. > Is this a bug, do I have to define every float field with "float(24,7)" or > is there a configuration option for this? Please, explain why do you think that it's a bug. We can consider changing the default, if old behaviour is incorrect. Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[email protected]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]