RE: Mysql hangs on multi table update on innodb table.

[Scott Wong]

Hi, I havent received any response on this so i'll send this again.
I did check again with 4.0.11-gamma and the problem is still there.


Regards,
Scott


> Version: Mysql  4.0.10-gamma
> 
> Description:  Mysql hangs and possibly can not recover from a query on an innodb
> table.  
> 
> How to Repeat :
> 
> drop table if exists parent;
> drop table if exists child;
> 
> CREATE TABLE parent(id INT NOT NULL,
>       PRIMARY KEY (id)) TYPE=INNODB;
> CREATE TABLE child(id  INT PRIMARY KEY, parent_id INT,
>       INDEX par_ind (parent_id),
>       FOREIGN KEY (parent_id) REFERENCES parent(id)
>       ON DELETE CASCADE
>       ON UPDATE CASCADE
>       ) TYPE=INNODB;
> 
> insert into parent set id=1;
> insert into child set id=1, parent_id=1;
> update parent,child set parent.id=parent.id+1, child.parent_id=parent.id+1;
> 
> 
> Thank you for your time.
> Scott Wong,
> Meiko America, INC
>