Leeuw van der, Tim writes: > Hello, > > Thank you very much for your reply! I was hoping that this was indeed fixed > in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to > 4.0.1; I will retest the query with 4.0.2 as soon as it's released. > > Apologies btw for not mentioning the version I was using. > > With regards, > > --Tim
Hi! Thank you for your bug report, thanks to which bug in multi-table delete was fixed. A fix will come up in 4.0.2. This is a patch for the bug: ===== sql/sql_parse.cc 1.228 vs edited ===== *** /tmp/sql_parse.cc-1.228-5440 Wed May 29 21:20:27 2002 --- edited/sql/sql_parse.cc Sat Jun 1 21:23:55 2002 *************** *** 1960,1965 **** --- 1960,1966 ---- } auxi->lock_type=walk->lock_type=TL_WRITE; auxi->table= (TABLE *) walk; // Remember corresponding table + (void)add_item_to_list(new Item_field(auxi->db,auxi->real_name,"*")); } tables->grant.want_privilege=(SELECT_ACL & ~tables->grant.privilege); if (add_item_to_list(new Item_null())) -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- 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