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 > --------------------------------------------------------------------- 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