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