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
>compile
>
> ***************
> 256a257
> > #define ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB 1238
> ***************
>
> then ran the query again.
>
> 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;
> delete parent,child from parent,child where parent.id=child.parent_id;
>
> now i get
> ERROR 2013: Lost connection to MySQL server during query
> mysql>
> Number of processes running now: 0
> 030213 15:54:20 mysqld restarted
>
>
> regards,
> Scott Wong
Yes, of course. I have sent just an excerpt.
Full patch is rather big and is not appropriate for mail.
Plus I am still improving it in order to work under all conditions.
Full patch will be in 4.0.11.
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/
---------------------------------------------------------------------
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
