diff options
author | monty@hundin.mysql.fi <> | 2001-08-29 17:33:41 +0300 |
---|---|---|
committer | monty@hundin.mysql.fi <> | 2001-08-29 17:33:41 +0300 |
commit | 2f93aa9e51559f1a681544c1e0b7be4706e3fe24 (patch) | |
tree | 3d579fb9d02e1fa69457e4ec1706fb325190d90c /mysql-test | |
parent | 788bc3f43bb20915e5ae733f868f98cbce85fdcc (diff) | |
download | mariadb-git-2f93aa9e51559f1a681544c1e0b7be4706e3fe24.tar.gz |
Test that all MERGE tables comes from the same database
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/t/merge.test | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index 59da525990c..6820242d562 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -35,9 +35,13 @@ show create table t3; # The following should give errors create table t4 (a int not null, b char(10), key(a)) type=MERGE UNION=(t1,t2); +--error 1016 +select * from t4; +--error 1212 +create table t5 (a int not null, b char(10), key(a)) type=MERGE UNION=(test.t1,test_2.t2); # Because of windows, it's important that we drop the merge tables first! -drop table if exists t4,t3,t1,t2; +drop table if exists t5,t4,t3,t1,t2; create table t1 (c char(10)) type=myisam; create table t2 (c char(10)) type=myisam; |