diff options
Diffstat (limited to 'mysql-test/t/merge.test')
-rw-r--r-- | mysql-test/t/merge.test | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index fb1da4e3739..0b14ba388ce 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -50,7 +50,7 @@ insert into t2 (c) values ('test2'); insert into t2 (c) values ('test2'); select * from t3; select * from t3; -delete from t3; +delete from t3 where 1=1; select * from t3; select * from t1; drop table t3,t2,t1; @@ -78,6 +78,16 @@ alter table t3 UNION=(t1,t2); select count(*) from t3; alter table t3 TYPE=MYISAM; select count(*) from t3; + +# Test that ALTER TABLE rembers the old UNION + +drop table t3; +CREATE TABLE t3 (incr int not null, othr int not null, primary key(incr)) +TYPE=MERGE UNION=(t1,t2); +show create table t3; +alter table t3 drop primary key; +show create table t3; + drop table t3,t2,t1; # |