Serious bug (or my foolishness) with alter table and InnoDB

[Karam Chand]

Hello,

I am running mysql 4.1.7 on Win2K.

I have two tables:

CREATE TABLE `child` (                      
          `id` int(11) NOT NULL default '0', 
          `name` char(1) NOT NULL default '', 
          PRIMARY KEY  (`id`,`name`)                  
                                                      
                                                      
      
        ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
        
CREATE TABLE `master` (                               
                                                      
                                                      

          `id` int(11) NOT NULL default '0', 
          `name` char(10) NOT NULL default '', 
          PRIMARY KEY  (`id`,`name`) 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If I execute the following statement:

alter table child add foreign key (id) references
master (id), type = innodb;

the mysql server hangs and needs to be killed. After
restarting the table child is also lost.

Is this a known bug?

Karam
          



        
                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail

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