#4355 (ok 4.1.13) Precision specifier for DOUBLE type is truncated

4.1.12
fixed
Marc Delisle
double (1)
1
2014-04-13
2014-04-07
Verbum
No

PMA 4.1.12
Apache/2.2.22 (Win32) mod_ssl/2.2.22 OpenSSL/1.0.1c PHP/5.4.24
Windows XP SP3 x32
Browser: Firefox v28

I try to add column to table in tbl_structure interface
Form:
name: dou
type: double
length: 15,2
default: 0.00

instead
ALTER TABLE table1 ADD dou DOUBLE(15,2) NOT NULL DEFAULT '0.00'
run sql
ALTER TABLE table1 ADD dou DOUBLE NOT NULL DEFAULT '0.00'
without (15,2)

Discussion

  • Marc Delisle
    Marc Delisle
    2014-04-07

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2014-04-07

    • summary: Incorrect inserting of the column with double type --> Precision specifier for DOUBLE type is truncated
     
  • Marc Delisle
    Marc Delisle
    2014-04-07

    • summary: Precision specifier for DOUBLE type is truncated --> (ok 4.1.13) Precision specifier for DOUBLE type is truncated
    • status: open --> resolved
     
  • Marc Delisle
    Marc Delisle
    2014-04-13

    • Status: resolved --> fixed