Bug #10356 update not work with multy table in stored procedure
Submitted: 4 May 2005 13:22 Modified: 4 May 2005 15:38
Reporter: musef habra Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.4-beta-nt OS:Windows (win XP)
Assigned to: Geert Vanderkelen CPU Architecture:Any

[4 May 2005 13:22] musef habra
Description:
new bug in 5.0.4-beta-nt
update not work with multy table whane  i uesd it in stored procedure/Function and i did not  get any error .
but i now it work out side stored procedure .

like this:
create function save(...) retern int(10) 
begin
       update acc a LEFT JOIN JournalsD j on j.IDAcc=a.ID and j.ID_M=10
                  set a.Account=0;
       retern 1;
end;

or

create function save(...) retern int(10) 
begin
       update acc a ,journalsD
                 set a.Account=0
       where j.IDAcc=a.ID and j.ID_M=10
       retern 1;
end;

the result alyas nothing
and update statment do nothing.

pleass any body can anser me way.

How to repeat:
my email

musef0@hotmail.com
[4 May 2005 15:38] Geert Vanderkelen
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html