Reznichenko, Thank you for your answer!
> What do you mean "could not execute a query on those tables"?
> Could you be more detailed?
Ok. let me explain.
When I was using MySQL 4.0.10,
After I add columns with "ALTER TABLE" on foreign key referencing table so many
times,
when I execute "SELECT * FROM child", MySQL session is deaded with Seg. fault.
even if I execute "drop table child". so I rebuilded entire InnoDB Table with
back-up data.
I don't have error log and test-bed at this time.
I wanna know that this problem is fixed in MySQL 4.0.11.
----- Original Message -----
From: "Victoria Reznichenko" <victoria.reznichenko@stripped>
To: <mysql@stripped>
Sent: Monday, March 10, 2003 10:32 PM
Subject: re: Altering table which has FOREIGN KEY constraints
> On Saturday 08 March 2003 09:09, Heo Jungsu wrote:
>
> > I have a question about altering table which has foreign key constraints.
> >
> > MySQL manual says that :
> >
> > "In InnoDB versions < 3.23.50 ALTER TABLE or CREATE INDEX should not be
> > used in connection with tables which have foreign key constraints or which
> > are referenced in foreign key constraints: .. (omitted) .. A CREATE INDEX
> > statement is in MySQL processed as an ALTER TABLE, and these restrictions
> > apply also to it. " on http://www.mysql.com/doc/en/SEC457.html
> >
> > But, how abount InnoDB versions >= 3.23.50?
> >
> > Version 4.0.11 still cannot alter referencing table and referenced table?
>
> It can and MySQL doesn't remove foreign key constraint.
>
> > What's the safe query in below lits (MySQL 4.0.11) ?
> >
> > * alter referencing table
> > * alter referenced table
> > * create index on referencing table
> > * create index on referenced table.
>
> They are all safe ...
>
> > When I have used MySQL 4.0.10 If I alter referencing and referenced table
> > several times,
> > sometimes I could not execute a query on those tables even "drop table...."
> > (So I rebuilded entire InnoDB ;-( )
>
> What do you mean "could not execute a query on those tables"?
> Could you be more detailed?
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread134356@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-jsheo=simplexi.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
