Temporary MERGE table with temporary underlying is broken by ALTER

Bug #1002162 reported by Igor Babaev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Confirmed
Medium
Michael Widenius

Bug Description

The bug #57657 from bugs.mysql.com is reproducible in MariaDB 5.5

MariaDB [test]> create temporary table t1_temp(i int);
Query OK, 0 rows affected (0.02 sec)

MariaDB [test]> create temporary table tm_temp_temp (i int) engine=merge union=(t1_temp) insert_method=last;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> alter table tm_temp_temp insert_method=first;
ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
MariaDB [test]> check table tm_temp_temp;
+-------------------+-------+----------+-----------------------------------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+-------+----------+-----------------------------------------------------------------------------------------------------+
| test.tm_temp_temp | check | Error | Table 'test.t1_temp' is differently defined or of non-MyISAM type or doesn't exist |
| test.tm_temp_temp | check | Error | Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist |
| test.tm_temp_temp | check | error | Corrupt |
+-------------------+-------+----------+-----------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

Changed in maria:
status: New → Confirmed
importance: Undecided → Medium
assignee: nobody → Michael Widenius (monty)
milestone: none → 5.5
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.