summaryrefslogtreecommitdiff
path: root/mysql-test/t/merge.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-12-02 12:32:43 +0100
committerSergei Golubchik <sergii@pisem.net>2013-12-02 12:32:43 +0100
commita3b99778fc34e778a0ec6248ac1c0a145ba2b5aa (patch)
tree7ec261594fb85525097416a8354a364c61b8982f /mysql-test/t/merge.test
parentb97b9536c71b3ad5ef521a1f21c527057a0a01c6 (diff)
parent7e431dc3794a553c9a29865f66475d1b7f49a9bc (diff)
downloadmariadb-git-a3b99778fc34e778a0ec6248ac1c0a145ba2b5aa.tar.gz
5.2 merge
Diffstat (limited to 'mysql-test/t/merge.test')
-rw-r--r--mysql-test/t/merge.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test
index abb7c3c7da2..bab0f3e1cc6 100644
--- a/mysql-test/t/merge.test
+++ b/mysql-test/t/merge.test
@@ -1863,6 +1863,15 @@ FLUSH TABLES;
UNLOCK TABLES;
DROP TABLE t1, t2, t3, m1;
+#
+# MDEV-5266 MySQL:57657 - Temporary MERGE table with temporary underlying is broken by ALTER
+#
+create temporary table t1_temp(i int);
+create temporary table tm_temp_temp (i int) engine=merge union=(t1_temp) insert_method=last;
+alter table tm_temp_temp insert_method=first;
+check table tm_temp_temp;
+drop temporary table t1_temp, tm_temp_temp;
+
--echo End of 5.1 tests
--echo #