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