Hi!
At 12:24 PM 12/13/01 -0800, you wrote:
>Heikki Tuuri wrote:
>
>> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
>> the manual that they do not work even if you do an ALTER TABLE to the
>> referenced table.
>
>
>Are you saying that you can't add columns to a table (
Heikki Tuuri wrote:
> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
> the manual that they do not work even if you do an ALTER TABLE to the
> referenced table.
Are you saying that you can't add columns to a table (to grow the schema
incrementally between software v
Hi!
At 04:10 PM 12/13/01 -0200, you wrote:
>Heikki Tuuri wrote:
>>
>> Hi!
>>
>> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
>> the manual that they do not work even if you do an ALTER TABLE to the
>> referenced table.
>>
>> Workaround: use DROP TABLE + CREATE TAB
Heikki Tuuri wrote:
>
> Hi!
>
> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
> the manual that they do not work even if you do an ALTER TABLE to the
> referenced table.
>
> Workaround: use DROP TABLE + CREATE TABLE to alter your table, whether it is
> the referring
Content-Type: text/plain; charset=us-ascii
>Subject: Bug in Foreign key constraint
>From: Leonardo Dias <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Date: Thu, 13 Dec 2001 15:03:49 -0200
>Sender: [EMAIL PROTECTED]
>
>Hi there.
>
>I'm using MySQL-Max version 3
Hi there.
I'm using MySQL-Max version 3.23.46 for Linux-i386 and I just found a
problem.
It seems that every once in a while MySQL changes the references of a
foreign key when it's using temporary table. A show table status would
give us the following:
InnoDB free: 21504 kB; (usr_id) REFER conl