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

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

    XMLWordPrintable

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)

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.