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

2008-08-26 Thread Jim Lyons
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

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

2008-08-26 Thread Rolando Edwards
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-