List:General Discussion« Previous MessageNext Message »
From:Jungsu Heo Date:March 12 2003 12:30am
Subject:Re: Altering table which has FOREIGN KEY constraints
View as plain text  
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


Thread
Altering table which has FOREIGN KEY constraintsJungsu Heo8 Mar
  • re: Altering table which has FOREIGN KEY constraintsVictoria Reznichenko10 Mar
    • Re: Altering table which has FOREIGN KEY constraintsJungsu Heo12 Mar
      • re: Re: Altering table which has FOREIGN KEY constraintsVictoria Reznichenko12 Mar
Re: Re: Altering table which has FOREIGN KEY constraintsHeikki Tuuri13 Mar