Bug #16058 the datatype were transformed automatically
Submitted: 29 Dec 2005 5:56 Modified: 29 Dec 2005 6:15
Reporter: ming lu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:1.1.2 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[29 Dec 2005 5:56] ming lu 
Description:
The datatype were transformed automatically.
Real -> Double  
Numeric -> Decimal

run mysql-administrator -> choose schema db1 -> new table
CREATE TABLE `db1`.`table1` (
  `id` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  `f1` REAL NOT NULL DEFAULT 0,
  `f2` NUMERIC(10,5) NOT NULL DEFAULT 0,
  PRIMARY KEY(`id`)
)
ENGINE = InnoDB;

when i reopen the table with table editor, the f1' datatype has become 'Double' and the f2's datatype has becom 'Decimal(10,5)'.

How to repeat:
see the description
[29 Dec 2005 6:15] Aleksey Kishkin 
Hi! 
'real' and 'double' are synonyms for mysql.
The same as for 'numeric' and 'decimal'
It 's described in the mysql documentation:

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html