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

["Jim Lyons" <jlyons4435@xxxxxxxxx>]

true, but I'm more interested in if the error message I received is
documented behavior or not.

Thanks,
Jim

On Tue, Aug 26, 2008 at 4:11 PM, Rolando Edwards <redwards@xxxxxxxxxxxxxx>wrote:

> 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
>



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