Bug #4286 HANDLER tables are closed by FLUSH TABLE(S)

• Submitted: 25 Jun 2004 14:38
• Modified: 5 Oct 2004 10:38
• Reporter: Ingo Struewing
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 4.0
• Assigned to: Ingo Struewing

[25 Jun 2004 14:38] Ingo Struewing

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 Struewing

I fixed this together with BUG#4435: bk commit - 4.0 tree (ingo:1.2010) BUG#4335

[5 Oct 2004 10:38] Ingo Struewing

Fixed in 4.0.22.