Details
Description
MySQL Bug#57657 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)
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 1002162