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 <[EMAIL PROTECTED]>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:[EMAIL PROTECTED] > 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