Bug #8054 join view crash server with query cache switched on
Submitted: 20 Jan 2005 18:11 Modified: 7 Mar 2005 1:11
Reporter: Oleksandr Byelkin
Status: Closed
Category:Server Severity:S2 (Serious)
Version:5.0 OS:
Assigned to: Bugs System Target Version:

[20 Jan 2005 18:11] Oleksandr Byelkin 
Description:
Select from join view crash server with query cache switched on

How to repeat:
create table t1 (a int, primary key (a), b int);
create table t2 (a int, primary key (a), b int);
insert into t2 values (1000, 2000);
create view v3 (a,b) as select t1.a as a, t2.a as b from t1, t2;
select * from v3;
[27 Jan 2005 13: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 3:21] Oleksandr Byelkin 
Thank you for bugreport!
Bugfix is pushed into 5.0.3 source repository.
[7 Mar 2005 1:11] Paul DuBois 
Noted in 5.0.3 changelog.