Bug #12569 crash in case of update of view over multi-table view
Submitted: 13 Aug 2005 13:10 Modified: 17 Aug 2005 19:31
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:Any (all)
Assigned to: Oleksandr Byelkin

[13 Aug 2005 13:10] Oleksandr Byelkin
Description:
crash in case of update of view based on join view

How to repeat:
create table t1 (a int);
create table t2 (b int);
create view v1 as select a,b from t1,t2;
create view v2 as select * from v1;
update v2 set a=1;
[13 Aug 2005 15:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28251
[17 Aug 2005 17:18] Paul Dubois
We need the three-part version number for the
version to which the patch was applied, in order to
write a changelog entry.  Reverting to Patch Pending
status.  Please supply the version number and set
to Documenting status again. Thanks.
[17 Aug 2005 19:22] Oleksandr Byelkin
pushed to 5.0.12
[17 Aug 2005 19:31] Paul Dubois
Noted in 5.0.12 changelog.