Bug #15119 temptable view + query cache = crash
Submitted: 21 Nov 2005 23:13 Modified: 7 Dec 2005 19:28
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Views Severity:S2 (Serious)
Version:5.0 OS:Any (all)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[21 Nov 2005 23:13] Oleksandr Byelkin
Description:
The following sequance of queries crash a server.

How to repeat:
set GLOBAL query_cache_size=1355776;
flush status;
create table t1 (a int, b int);
create algorithm=temptable view v1 as select * from t1;
select * from v1;
show status like "Qcache_hits";
select * from v1;
[22 Nov 2005 9:34] 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/32522
[30 Nov 2005 10:17] Konstantin Osipov
OK to push, approved by email.
[1 Dec 2005 10:01] 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/32896
[3 Dec 2005 17:54] Oleksandr Byelkin
Thank you for the bug report!
The bugfix is pushed to 5.0.17 and 5.1.4.
[7 Dec 2005 19:28] Paul Dubois
Noted in 5.0.17, 5.1.4 changelogs.