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]> w
--- 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 th
Innodb tables lose foreign keys after creating an index...
>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 cr
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 t
