Bug #4286 HANDLER tables are closed by FLUSH TABLE(S)
Submitted: 25 Jun 2004 14:38 Modified: 5 Oct 2004 10:38
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0 OS:
Assigned to: Ingo Strüwing CPU Architecture:Any

[25 Jun 2004 14:38] Ingo Strüwing 
Description:
FLUSH TABLE(S) close HANDLER tables. This is wrong. They should be re-opened instead.

How to repeat:
create table t1(a INT PRIMARY KEY);
insert into t1 values (5);
HANDLER t1 OPEN;
HANDLER t1 READ FIRST LIMIT 9;
FLUSH TABLES; /* can also be done by another thread */
HANDLER t1 READ FIRST LIMIT 9; /* this fails with the old behavior */

Suggested fix:
Re-open HANDLER tables when they have been hit by a FLUSH TABLE(S).
[25 Sep 2004 7:40] Ingo Strüwing 
I fixed this together with BUG#4435: bk commit - 4.0 tree (ingo:1.2010) BUG#4335
[5 Oct 2004 10:38] Ingo Strüwing 
Fixed in 4.0.22.