Scott Wong writes:
> 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
Hi!
Thank you for your bug report, it was fixed one week ago in with the
following patch which was committed, but is not yet pushed:
===== sql/sql_parse.cc 1.293 vs 1.294 =====
*** /tmp/sql_parse.cc-1.293-28756 Wed Jan 29 21:33:54 2003
--- 1.294/sql/sql_parse.cc Sat Feb 8 19:25:16 2003
***************
*** 2038,2044 ****
(ORDER *)NULL,(ORDER *)NULL,(Item *)NULL,
(ORDER *)NULL,
select_lex->options | thd->options |
! SELECT_NO_JOIN_CACHE,
result);
delete result;
}
--- 2038,2044 ----
(ORDER *)NULL,(ORDER *)NULL,(Item *)NULL,
(ORDER *)NULL,
select_lex->options | thd->options |
! SELECT_NO_JOIN_CACHE | SELECT_NO_UNLOCK,
result);
delete result;
}
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / 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
