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]
