Version: Mysql 4.0.10-gamma
Description: ERROR 1105: Unknown error after issuing a multi-table delete on
parent/child table.
if there's no foreign keys .. works ok.
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),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE CASCADE
) TYPE=INNODB;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
insert into grandchild set id=1, child_id=1;
delete parent,child from parent,child where parent.id=child.parent_id;
ERROR 1105: Unknown error
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
