MySQL Bugs: #14706: lost of enum values

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:	Windows (Win2000)
Assigned to:		CPU Architecture:	Any

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.

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