Bug #8054 join view crash server with query cache switched on

• Submitted: 20 Jan 2005 17:11
• Modified: 7 Mar 2005 0:11
• Reporter: Oleksandr Byelkin
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[20 Jan 2005 17: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 12:23] Oleksandr Byelkin

ChangeSet
  1.1823 05/01/27 14:21:37 [e-mail] +5 -0
  fixed QC invaluidation and processing with view (BUG#8050) (BUG#8054)

[24 Feb 2005 2:21] Oleksandr Byelkin

Thank you for bugreport!
Bugfix is pushed into 5.0.3 source repository.

[7 Mar 2005 0:11] Paul DuBois

Noted in 5.0.3 changelog.