Bug #10687 MERGE Engine fails on Windows
Submitted: 17 May 2005 14:34 Modified: 26 May 2005 1:13
Reporter: Geert Vanderkelen
Status: Closed
Category:Server Severity:S1 (Critical)
Version:4.1.12 OS:Microsoft Windows (Windows)
Assigned to: Reggie Burnett Target Version:

[17 May 2005 14:34] Geert Vanderkelen 
Description:
Hi,

MERGE table under Windows gives errno 2:

ERROR 1017 (HY000): Can't find file: 'mm.MRG' (errno: 2)

Tested with same release under Linux works fine.
Reported to work find under Windows using 4.1.11

Regards,

Geert

How to repeat:

create table t1 ( id int );
create table t2 ( id int );

create table mm ( id int ) engine=merge union=(t1,t2);

select count(*) from mm;

Suggested fix:

Not a fix but..

In 4.1.11 the content of MRG file is something like this:
C:\mysql\data\test/t1

In 4.1.12 it changes to:
./test/m1

Editing the MRG file with an editor to the previous c:\ format, make the MERGE table
accessible again.
[17 May 2005 21:32] Geert Vanderkelen 
Apparently the '/' is not working under Windows, where it was thought it would. Following
ChangeSet from 28 April:

ChangeSet 1.2200.4.1 2005/04/28 18:28:50 ingo@mysql.com
  BUG#5964 - 4.1 MERGE tables regression from 4.0
  Changed the creation of the .MRG file so that only the table  name
  is written when the MyISAM table is in the same database as the
  MERGE table, a relative path is used in other cases in mysqld,
  and possibly an absolute path is used in an embedded server.
  No test case is added as the external behaviour is unchanged.
  Only the file names within the .MRG file are changed.
sql/ha_myisammrg.cc 1.54 2005/04/28 18:28:44 ingo@mysql.com
  BUG#5964 - 4.1 MERGE tables regression from 4.0
  Changed the creation of the .MRG file so that only the table  name
  is written when the MyISAM table is in the same database as the
  MERGE table, a relative path is used in other cases in mysqld,
  and possibly an absolute path is used in an embedded server.

Hope this helps!

Regards,

Geert
[23 May 2005 18:48] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25181
[23 May 2005 18:59] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25183
[23 May 2005 19:25] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25185
[23 May 2005 19:30] Reggie Burnett 
This is fixed in 4.1.13 and 5.0.7
[24 May 2005 14:30] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25211
[24 May 2005 22:05] Paul DuBois 
Note in 4.1.13, 5.0.7 changelogs.
[25 May 2005 18:56] Lenz Grimmer 
Setting it back to "Analyzing", as there are still cases in which the bug can be
reproduced.
[25 May 2005 23:42] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25279
[25 May 2005 23:43] Jim Winstead 
Fixed in 4.1.12a and 5.0.6.
[26 May 2005 1:13] Paul DuBois 
Moved change notes to 4.1.12, 5.0.6 sections.
(In 4.1.12 section, added a note that it applies
to 4.1.12a.)