Bug #6053 DOUBLE PRECISION literal 1.7976931348623157E+308
Submitted: 12 Oct 2004 23:38 Modified: 16 Mar 2005 8:29
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Alexey Botchkov CPU Architecture:Any

[12 Oct 2004 23:38] Peter Gulutzan 
Description:
The MySQL Reference Manual says: 
"Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 
2.2250738585072014E-308 to 1.7976931348623157E+308." But in fact I can't enter 
1.7976931348623157E+308. 
 

How to repeat:
mysql> create table t1 (s1 double precision); 
Query OK, 0 rows affected (0.33 sec) 
 
mysql> insert into t1 values (1.7976931348623155E+308); 
Query OK, 1 row affected (0.00 sec) 
 
mysql> insert into t1 values (1.7976931348623157E+308); 
ERROR 1367 (22007): Illegal double '1.7976931348623157E+308' value found during 
parsing 
mysql> insert into t1 values (-1.7976931348623157E+308); 
ERROR 1367 (22007): Illegal double '1.7976931348623157E+308' value found during 
parsing
[12 Oct 2004 23:47] MySQL Verification Team 
Verified on latest BK source tree.
[16 Mar 2005 8:29] Alexey Botchkov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html