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

MySQL:57657 - Temporary MERGE table with temporary underlying is broken by ALTER

Details

    Description

      MySQL bug http://bugs.mysql.com/bug.php?id=57657 was fixed in 5.6.5, but the fix apparently was not merged to 10.0. It should be, eventually.

      Test case from the bug report:

      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;

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Sergei Golubchik made transition -
          Open In Progress
          		20d 23h 50m 1
          Sergei Golubchik made transition -
          In Progress Closed
          		2d 1h 24m 1

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.