Bug #15119 temptable view + query cache = crash

• Submitted: 21 Nov 2005 23:13
• Modified: 7 Dec 2005 19:28
• Reporter: Oleksandr Byelkin
• Status: Closed
• 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.