From f534708bd6637da06a0dbeb5192351072a8bbbcd Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Fri, 29 Nov 2013 20:21:05 +0100 Subject: MDEV-5266 MySQL:57657 - Temporary MERGE table with temporary underlying is broken by ALTER Fix ha_myisammrg::update_create_info() to do what ha_myisammrg::append_create_info() does - take sub-table names from TABLE_LIST, not reverse engineer tablefile names. Backport praveenkumar.hulakund@oracle.com-20120127081643-u7dxy23i8yyqarm7 from mysql-5.6 --- mysql-test/t/merge.test | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/t/merge.test') diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index eecf892869f..cc26ba35661 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 --disable_result_log -- cgit v1.2.1