RE: alter merge table doesn't work as documented (?)

[Rolando Edwards <redwards@xxxxxxxxxxxxxx>]

You are better off running it this way:

create table t1 (x int);
create table t2 (x int);
create table t3 (x int);

create table t_merge (x int) engine=merge union=(t1,t2,t3);

drop table t1;
drop table t_merge;

create table t_merge (x int) engine=merge union=(t2,t3);

-----Original Message-----
From: Jim Lyons [mailto:jlyons4435@xxxxxxxxx]
Sent: Tuesday, August 26, 2008 4:41 PM
To: mysql
Subject: alter merge table doesn't work as documented (?)

I have a merge table and dropped one of the tables that was in the union.  I
then tried to alter the merge table to use only the remaining tables.

Here is some simple test code representing what I was doing.

########################
create table t1 (x int);
create table t2 (x int);
create table t3 (x int);

create table t_merge (x int) engine=merge union=(t1,t2,t3);

drop table t1;

alter table t_merge union=(t2, t3);
##########################

As I read the doc, this ought to work, leaving me with a merge table with
only 2 tables in the union.  The output I got was (the error message is at
the end):

--------------
create table t1 (x int)
--------------

--------------
create table t2 (x int)
--------------

--------------
create table t3 (x int)
--------------

--------------
create table t_merge (x int) engine=merge union=(t1,t2,t3)
--------------

--------------
drop table t1
--------------

--------------
alter table t_merge union=(t2, t3)
--------------

ERROR 1146 (42S02) at line 16: Table 'jlyons.t1' doesn't exist

Is this a bug or expected behavior?

Thanks,
Jim

--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx