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

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;

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

OK to push, approved by email.

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

Thank you for the bug report!
The bugfix is pushed to 5.0.17 and 5.1.4.

Noted in 5.0.17, 5.1.4 changelogs.

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.