Hello, I just checked with the same version at home and it works.
Dont know whats the problem at office. Will check again? Karam --- Artem Koltsov <[EMAIL PROTECTED]> wrote: > Works fine on WinXP 4.1.8. Only generates warning: > > mysql> show warnings; > +---------+------+--------------------------------------------------------------------------+ > | Level | Code | Message > | > +---------+------+--------------------------------------------------------------------------+ > | Warning | 1287 | 'TYPE=storage_engine' is > deprecated; use 'ENGINE=storage_engine' instead | > +---------+------+--------------------------------------------------------------------------+ > > And here is the `child` table after execution: > > mysql> show create table child; > +-------+---------------------------------------------------------------- > ------------------------------------------------------------------------- > | Table | Create Table > +-------+---------------------------------------------------------------- > ------------------------------------------------------------------------- > | child | CREATE TABLE `child` ( > `id` int(11) NOT NULL default '0', > `name` char(1) NOT NULL default '', > PRIMARY KEY (`id`,`name`), > CONSTRAINT `child_ibfk_1` FOREIGN KEY (`id`) > REFERENCES `master` (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | > +-------+---------------------------------------------------------------- > ------------------------------------------------------------------------- > > > -----Original Message----- > > From: Karam Chand [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 25, 2005 10:50 AM > > To: mysql@lists.mysql.com > > Subject: Serious bug (or my foolishness) with > alter table and InnoDB > > > > > > 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] > > > > > > Attention: > Any views expressed in this message are those of the > individual sender, except where the message states > otherwise and the sender is authorized to state them > to be the views of any such entity. The information > contained in this message and or attachments is > intended only for the person or entity to which it > is addressed and may contain confidential and/or > privileged material. If you received this in error, > please contact the sender and delete the material > from any system and destroy any copies. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
