diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-11-29 20:21:05 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-11-29 20:21:05 +0100 |
| commit | f534708bd6637da06a0dbeb5192351072a8bbbcd (patch) | |
| tree | 7df07e29a2c712c5012c461b711dd446c4765446 /mysql-test/r/merge.result | |
| parent | 0657f102afe0a683c6ef9e330828af977dd5433c (diff) | |
| download | mariadb-git-f534708bd6637da06a0dbeb5192351072a8bbbcd.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/merge.result')
| -rw-r--r-- | mysql-test/r/merge.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index 937fa77a885..7b50be68281 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -2368,4 +2368,11 @@ FLUSH TABLES; ERROR HY000: Can't reopen table: 'm1' UNLOCK TABLES; DROP TABLE t1, t2, t3, m1; +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; +Table Op Msg_type Msg_text +test.tm_temp_temp check status OK +drop temporary table t1_temp, tm_temp_temp; End of 5.1 tests |