Bug #8050 alter/drop view do not invalidate Query cache
Submitted: 20 Jan 2005 16:22 Modified: 7 Mar 2005 0:08
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[20 Jan 2005 16:22] Oleksandr Byelkin 
Description:
alter/drop view do not invalidate Query cache

How to repeat:
+ set GLOBAL query_cache_size=1355776;
+ create table t1 (a int);
+ insert into t1 values (1), (2), (3);
+ create view v1 as select a from t1 where a > 1;
+ select * from v1;
+ a
+ 2
+ 3
+ alter view v1 as select a from t1 where a > 2;
+ select * from v1;
+ a
+ 2
+ 3
+ drop view v1;
+ select * from v1;
+ a
+ 2
+ 3
+ drop table t1;
[27 Jan 2005 12:23] Oleksandr Byelkin 
ChangeSet
  1.1823 05/01/27 14:21:37 bell@sanja.is.com.ua +5 -0
  fixed QC invaluidation and processing with view (BUG#8050) (BUG#8054)
[24 Feb 2005 2:20] Oleksandr Byelkin 
Thank you for bugreport!
Bugfix is pushed into 5.0.3 source repository.
[7 Mar 2005 0:08] Paul DuBois 
Noted in 5.0.3 changelog.