summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authormonty@hundin.mysql.fi <>2001-08-29 17:33:41 +0300
committermonty@hundin.mysql.fi <>2001-08-29 17:33:41 +0300
commit2f93aa9e51559f1a681544c1e0b7be4706e3fe24 (patch)
tree3d579fb9d02e1fa69457e4ec1706fb325190d90c /mysql-test
parent788bc3f43bb20915e5ae733f868f98cbce85fdcc (diff)
downloadmariadb-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.test6
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;