RE: Bug with innodb multi-table delete and foreign keys.

2003-02-14 Thread Sinisa Milivojevic
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

Re: Bug with innodb multi-table delete and foreign keys.

2003-02-13 Thread Sinisa Milivojevic
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,

RE: Bug with innodb multi-table delete and foreign keys.

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

Bug with innodb multi-table delete and foreign keys.

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