Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-598

LP:1002162 - Temporary MERGE table with temporary underlying is broken by ALTER

    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

              Hide
              ratzpo Rasmus Johansson added a comment -

              Launchpad bug id: 1002162

              Show
              ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1002162
              Hide
              serg Sergei Golubchik added a comment -

              fixed in 5.6 only

              Show
              serg Sergei Golubchik added a comment - fixed in 5.6 only
              Hide
              elenst Elena Stepanova added a comment -

              The bug was fixed in 5.1 tree and up by the following revision:

              revno: 3210
              revision-id: sergii@pisem.net-20131129192105-0excqx2i9sj6wt8l
              parent: bar@mnogosearch.org-20131114120932-8byc3si7yycaejd3
              fixes bug: https://mariadb.atlassian.net/browse/MDEV-5266
              committer: Sergei Golubchik <sergii@pisem.net>
              branch nick: 5.1
              timestamp: Fri 2013-11-29 20:21:05 +0100
              message:
                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
              
              Show
              elenst Elena Stepanova added a comment - The bug was fixed in 5.1 tree and up by the following revision: revno: 3210 revision-id: sergii@pisem.net-20131129192105-0excqx2i9sj6wt8l parent: bar@mnogosearch.org-20131114120932-8byc3si7yycaejd3 fixes bug: https://mariadb.atlassian.net/browse/MDEV-5266 committer: Sergei Golubchik <sergii@pisem.net> branch nick: 5.1 timestamp: Fri 2013-11-29 20:21:05 +0100 message: 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

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  igor Igor Babaev
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: