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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
