Version: Mysql 4.0.10-gamma
Description: Mysql client loses connection when doing a multi-table delete if
one table is innodb and the other is myISAM.
How to Repeat :
drop table parent;
drop table 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),
) ;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
delete parent,child from parent,child where parent.id=child.parent_id;
fix
?
Thank you for your time
2 messages in com.mysql.lists.bugsA bug with innodb and non innodb mult...