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

2003-03-11 Thread Sinisa Milivojevic
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 (

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

2003-03-05 Thread Sinisa Milivojevic
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 co

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

2003-03-05 Thread 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 Re

Mysql hangs on multi table update on innodb table.

2003-02-21 Thread Scott Wong
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