Bug #14010 Precision math: DECIMAL(38,38) not accepted
Submitted: 13 Oct 2005 17:09 Modified: 13 Dec 2007 9:05
Reporter: Trudy Pelzer Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:5.0.15-rc-debug OS:Linux (SuSE 9.3)
Assigned to: Assigned Account CPU Architecture:Any

[13 Oct 2005 17:09] Trudy Pelzer
MySQL should support a column definition of up to DECIMAL(38,38).
Currently, only 30-post decimal digits are supported.

How to repeat:
mysql> select version();
| version()        |
| 5.0.15-rc-debug |
1 row in set (0.00 sec)

mysql> create table t1 (col1 decimal(38,38));
ERROR 1425 (42000): Too big scale 38 specified for column 'col1'. Maximum is 30.
-- This is the incorrect response. The table definition should be supported;
the change can be done once the new .frm is complete.