Bug #28229 MyODBC driver unable to retrieve very large double value from MySQL database
Submitted: 4 May 2007 0:49 Modified: 28 May 2013 8:22
Reporter: Derek Lai Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.14 OS:Windows (2003)
Assigned to: CPU Architecture:Any

[4 May 2007 0:49] Derek Lai 
Description:
We have a database table "acdatatypes" that has a column of type "double".  We inserted the value "1.79769313486232e+308" into the column.  However, when we issue a select statement to retrieve the value, using the ODBC function SQLGetData() to retrieve the value as a double value, we are getting the value "1.#INF" instead.  Notice that the value is returned fine when using MySQL command line tool.

Please see the attached Visual Studio project for a reproducible case.

How to repeat:
See reproducible code project attached.
[4 May 2007 9:10] Tonci Grgin 
Hi Derek and thanks for your report.

AFAIS 1.79769313486232*10^308 is much bigger than -1.7*10^308 and 1.7*10^308 (DOUBLE according to http://msdn2.microsoft.com/en-us/library/s3f49ktz.aspx) don't you agree? Also notice that cl client can not manipulate with such a big value...

I think this is not a bug as value is out of range and #inf is the right way to represent it...
[4 Jun 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[28 May 2013 8:22] Bogdan Degtyariov 
Cannot continue without feedback from the reporter.
The bug is closed.