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
