Hello mysql,
Using 'int not null' make next enum (using cp1251) corrupted in
mysqldump output on W2000.
Is this a known issue?
How-to-repeat:
---------------------------
drop table if exists t1;
drop table if exists t2;
create table t1 (a int, b enum('А','Б')) DEFAULT CHARACTER SET cp1251;
create table t2 (a int not null, b enum('А','Б')) DEFAULT CHARACTER SET cp1251;
show fields from t1 like 'b';
show fields from t2 like 'b';
+---+---------------+-----+--+------+--+
| b | enum('А','Б') | YES | | NULL | |
+---+---------------+-----+--+------+--+
| b | enum('А','Б') | YES | | NULL | | <------ Ok
+---+---------------+-----+--+------+--+
show create table t1;
show create table t2;
+----+--------------------------------
| t1 | CREATE TABLE `t1` (
`a` int(11) default NULL,
`b` enum('А','Б') default NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
+----+--------------------------------
+----+--------------------------------
| t2 | CREATE TABLE `t2` (
`a` int(11) NOT NULL default '0',
`b` enum('?','?') default NULL <------ Oops!
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
+----+--------------------------------
--
Best regards,
Juri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
