Bug #14706 lost of enum values
Submitted: 7 Nov 2005 14:15 Modified: 24 Nov 2005 12:38
Reporter: Nándor Horgos Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.0.20 rc OS:Microsoft Windows (Win2000)
Assigned to: CPU Architecture:Any

[7 Nov 2005 14:15] Nándor Horgos
Description:
Migrating from mySQL 4.0.18 to mySQL 5.0.4 beta fails on each table creation containing ENUM data type field. On "Creation Result" the generated SQL create script is: 

CREATE TABLE `i-flow_dev`.`adverts` (
  `id` SMALLINT(5) NOT NULL,
  `image` VARCHAR(100) NOT NULL DEFAULT '',
  `name` VARCHAR(50) NOT NULL DEFAULT '',
  `link` VARCHAR(100) NOT NULL DEFAULT '',
  `type` TINYINT(1) NOT NULL DEFAULT '0',
  `displayed` INT(10) NOT NULL DEFAULT '0',
  `clicked` INT(10) NOT NULL DEFAULT '0',
  `showlimit` INT(6) NOT NULL DEFAULT '0',
  `unlimited` ENUM NOT NULL DEFAULT '0',
  `adv_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `client_email` VARCHAR(75) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
ENGINE = MYISAM;

`unlimited` ENUM NOT NULL DEFAULT '0',
 if this line modified to
`unlimited` ENUM ('0','1') NOT NULL DEFAULT '0',
than creation is successful.

How to repeat:
Migrate table containing ENUM data type.
[24 Nov 2005 12:38] Michael G. Zinner
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html