Hi!
-Original Message-
From: j.random.programmer [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Saturday, March 02, 2002 5:21 AM
Subject: Re: Innodb tables lose foreign keys after creating an index...
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Heikki:
Is there a fix
://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
-Original Message-
From: Rick Flower [EMAIL PROTECTED]
To: MySQL Mailing List [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]
Date: Friday, March 01, 2002 2:32 AM
Subject: Innodb tables lose foreign
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Rick,
sorry, it is not mentioned in the manual that MySQL
performs a CREATE INDEX
by doing an ALTER TABLE. And ALTER TABLE has the
feature (= documented bug)
that it removes foreign key definitions.
Heikki:
Is there a fix planned for the alter
Hi all..
Are any of you aware of a way to get indexes to work at all with Innodb
tables containing foreign keys? I'm finding that after doing a create
index on a table which *had* foreign keys, after the create, the foreign
keys are gone.. I've included a simple test below which shows off