Re: 4.1.3-5. Bugs alive!

2004-09-24 Thread Egor Egorov 
Juri Shimon [EMAIL PROTECTED] wrote:

 Using 'int not null' make next enum (using cp1251) corrupted in
 mysqldump output on W2000.

 Is this a known issue?

Spasibo, the bug is posted as http://bugs.mysql.com/bug.php?id=5728

I'm not sure if this is a known issue, but I let the developers investigate
it out. 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.3-5. Bugs alive!

2004-09-23 Thread Juri Shimon 
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]