Karam,
----- Original Message ----- From: "Karam Chand" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, January 25, 2005 8:58 PM
Subject: RE: Serious bug (or my foolishness) with alter table and InnoDB
Hello,
I just checked with the same version at home and it works.
Dont know whats the problem at office.
do the tables contain data? Does the data satisfy the FOREIGN KEY constraint you are trying to add?
Will check again?
It is best not to add any extra clauses to a plain:
ALTER TABLE ... TYPE=InnoDB;
Few people try to run such complex statements, and there may be bugs there.
Karam
Regards,
Heikki
--- 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 |
-------------------------------------------------------------------------
http://lists.mysql.com/[EMAIL PROTECTED]
> -----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:
>
> >
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
