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

Scott Wong writes: 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))

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

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

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

Scott Wong writes: 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 Hi! This will require a major re-write in multi table update's and will not come up very soon. But should come up

Mysql hangs on multi table update on innodb table.

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