Bug #1477 update allow apdating of derived table
Submitted: 4 Oct 2003 10:10 Modified: 6 Oct 2003 3:20
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (any)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[4 Oct 2003 10:10] Oleksandr Byelkin 
Description:
update allow apdating of derived table 

How to repeat:
update (select * from t7) as t7 set s1 = 5; 

Suggested fix:
fix parsing rules to prohibit usend derived tables in update command
[5 Oct 2003 10:09] Oleksandr Byelkin 
ChangeSet 
  1.1610 03/10/05 21:09:50 bell@laptop.sanja.is.com.ua +3 -0 
  prohibited using derived tables in UPDATE command (BUG#1477) 
  fixed incorrect table name in test
[6 Oct 2003 3:20] Oleksandr Byelkin 
fix is pushed