Scott Wong writes:
Hi sinisa,
I tried this patch.
It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on
compile
so i went ahead and added to include/mysqld_error.h for testing.
i'm not sure if it's the right place or the right error code but it made mysql
Scott Wong writes:
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,
To: Scott Wong
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Bug with innodb multi-table delete and foreign keys.
Scott Wong writes:
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
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