From: Dan Nelson
Date: August 6 2003 5:58pm
Subject: Re: Problem with merge tables in 4.1
List-Archive: http://lists.mysql.com/mysql/147069
Message-Id: <20030806175844.GE3366@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 06), Pierre-Luc Soucy said:
> I was working on some merge tables this morning and it worked fine,
> but after a few unsuccessful table creation requests (I was making
> some tests), I could not alter or select from a table for the
> following reason:
> 
> mysql> create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE UNION=(countries);
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> select * from test_table;
> ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143)

$ perror 143
Error code 143:  Unknown error: 143
143 = Conflicting table definitions in sub-tables of MERGE table

Does your countries table layout match that of test_table?

-- 
	Dan Nelson
	dnelson@stripped