Bug #5455 multi update have not protaction of updating table which has update
Submitted: 7 Sep 2004 19:27 Modified: 16 Sep 2004 16:09
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[7 Sep 2004 19:27] Oleksandr Byelkin
Description:
only usual UPDATE diasllow useing same table for updating and fetching 

How to repeat:
create table t1 (col1 int); 
create table t2 (col1 int); 
update t1,t2 set t1.col1 = (select max(col1) from t1) where t1.col1 = t2.col1; 
 
but  
 
update t1 set col1 = (select max(col1) from t1); fails
[8 Sep 2004 10:40] Oleksandr Byelkin
ChangeSet 
  1.2009 04/09/08 13:39:15 bell@sanja.is.com.ua +6 -0 
  check that table used in multi-update is unique added (BUG#5455)
[16 Sep 2004 16:09] Oleksandr Byelkin
pushed.