diff options
author | unknown <serg@sergbook.mysql.com> | 2002-11-05 00:00:51 +0100 |
---|---|---|
committer | unknown <serg@sergbook.mysql.com> | 2002-11-05 00:00:51 +0100 |
commit | 3fbb70294662f3bc604c68d25d44d802c9835c8e (patch) | |
tree | c0328212efe7c722b0154253a487ad341625ce2a /mysql-test/t/merge.test | |
parent | 195aa6c98f94254b33b3d2423833275485de6eca (diff) | |
download | mariadb-git-3fbb70294662f3bc604c68d25d44d802c9835c8e.tar.gz |
TEMPORARY MERGE tables are allowed
Diffstat (limited to 'mysql-test/t/merge.test')
-rw-r--r-- | mysql-test/t/merge.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index 238dd599664..6ea9ecc269f 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -114,3 +114,22 @@ insert into t2 values (1,1),(2,2),(0,0),(4,4),(5,5),(6,6); flush tables; select * from t3 where a=1 order by b limit 2; drop table t3,t1,t2; + +# +# temporary merge tables +# +drop table if exists t1, t2, t3, t4, t5, t6; +create table t1 (a int not null); +create table t2 (a int not null); +insert into t1 values (1); +insert into t2 values (2); +create temporary table t3 (a int not null) TYPE=MERGE UNION=(t1,t2); +select * from t3; +create temporary table t4 (a int not null); +create temporary table t5 (a int not null); +insert into t4 values (1); +insert into t5 values (2); +create temporary table t6 (a int not null) TYPE=MERGE UNION=(t4,t5); +select * from t6; +drop table if exists t1, t2, t3, t4, t5, t6; + |