Bug #559 Maximum precision for DECIMAL column in MySQL on Windows

• Submitted: 31 May 2003 12:16
• Modified: 16 Jun 2003 7:47
• Reporter: Miguel Solorzano
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.13
• OS: Windows (Windows)
• CPU Architecture: Any

[31 May 2003 12:16] Miguel Solorzano

Description:
Precision of decimal has different behavior than Uxix.

How to repeat:
On Windows:

mysql> CREATE TABLE `scale_test6` (`a_dec` decimal(30,23) default NULL)
TYPE=MyISAM;

mysql> INSERT INTO scale_test6 (a_dec) VALUES
(12345678.123456789012345678901234);

mysql> SELECT * FROM scale_test6;
+----------------------------------+
| a_dec                            |
+----------------------------------+
| 12345678.12345678900000000000000 |
+----------------------------------+
1 row in set (0.00 sec)

On Unix:

mysql> SELECT * FROM scale_test6;
+----------------------------------+
| a_dec                            |
+----------------------------------+
| 12345678.12345678918063640594482 |
+----------------------------------+
1 row in set (0.00 sec)

[16 Jun 2003 7:47] Sergei Golubchik

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

floaating point precision depends on hardware architecture and OS math library, there is nothing we can do here :(