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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
