summaryrefslogtreecommitdiff
path: root/mysql-test/t/merge.test
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mysql.com>2009-02-04 17:00:40 +0400
committerSergey Vojtovich <svoj@mysql.com>2009-02-04 17:00:40 +0400
commitaa13a4b95ef7cc5fbc656b3a05807596f8eb06bd (patch)
tree0fcd4cc22c791faeee761dc99ebffd2456455ca9 /mysql-test/t/merge.test
parent7957622bfde87af5bbe880bb53c9544c5578be38 (diff)
parent97bd763544bbaf882a083b1952b47901bc9a335b (diff)
downloadmariadb-git-aa13a4b95ef7cc5fbc656b3a05807596f8eb06bd.tar.gz
Merge 5.0-bugteam -> 5.1-bugteam.
Diffstat (limited to 'mysql-test/t/merge.test')
-rw-r--r--mysql-test/t/merge.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test
index dd3e4e28aeb..118f8771f91 100644
--- a/mysql-test/t/merge.test
+++ b/mysql-test/t/merge.test
@@ -613,6 +613,19 @@ ALTER TABLE m1 UNION=();
SHOW CREATE TABLE m1;
DROP TABLE t1, m1;
+#
+# BUG#32047 - 'Spurious' errors while opening MERGE tables
+#
+CREATE TABLE t1(a INT);
+CREATE TABLE t2(a VARCHAR(10));
+CREATE TABLE m1(a INT) ENGINE=MERGE UNION=(t1, t2);
+CREATE TABLE m2(a INT) ENGINE=MERGE UNION=(t1);
+SELECT * FROM t1;
+--error ER_WRONG_MRG_TABLE
+SELECT * FROM m1;
+SELECT * FROM m2;
+DROP TABLE t1, t2, m1, m2;
+
--echo End of 5.0 tests
#