Bug #2716 Create table type=merge select...

• Submitted: 11 Feb 2004 13:51
• Modified: 11 Feb 2004 15:05
• Reporter: Matthew Lord
• Status: Can't repeat
• Category: MySQL Server: MyISAM storage engine
• Severity: S3 (Non-critical)
• Version: 4.0.17
• OS: Windows (windows 2000)
• Assigned to: Dean Ellis
• CPU Architecture: Any

[11 Feb 2004 13:51] Matthew Lord

Description:
If you create two identical tables for a merge and then want to avoid creating the structure of the actual merge table by doing a create table mergetbl type=merge select * from underlyingtable where something is never true; the statement hangs indefinitely.  If you ctrl-c out of the client you can see that the merge table actually gets created and everything appears normal.  When you go to do a flush tables though it just hangs indefinitely as well so there must be a lock or file descriptor that isn't being cleaned up properly.

How to repeat:
create table student (name char(30) not null);
create table previous_student (name char(30) not null);
create table allstudents type=merge select * from student where name IS NULL;

ctl-c out of client

log in and check out merge table.  try and issue flush tables;

Suggested fix:
???

[11 Feb 2004 15:05] Dean Ellis

I cannot repeat this using 4.0.18 (in Windows or Linux).  If you see it with 4.0.18, tell me which binary you're using and I'll re-test.