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

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 10.0.5, 5.1.67, 5.2.14, 5.3.12, 5.5.34
        • Fix Version/s: 5.5.35, 10.0.7, 5.3.13, 5.2.15, 5.1.73
        • Component/s: None
        • Labels:

          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;

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug#57657 - Temporary MERGE table with temporary underlying is broken by ALTER

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  pushed in 5.1

                  Show
                  serg Sergei Golubchik added a comment - pushed in 5.1
                  Hide
                  Permalink
                  dbart Daniel Bartholomew added a comment -

                  http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/2502.565.59

                  Show
                  dbart Daniel Bartholomew added a comment - http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/2502.565.59

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 1 hour
                        1h