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

Table from older version requires table rebuild when adding column to table with multi-column index

    XMLWordPrintable

Details

    Description

      How to reproduce:

      On a 10.4 server instance do:

      CREATE TABLE t1 (
        id int not null primary key,
        msg varchar(10),
        index(id, msg)
      ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
      

      Then upgrade to 10.5 and try to instant-add a column:

      alter table t1 add column i int, algorithm=instant;
      

      This fails with:

      ERROR 1845 (0A000): ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE
      

      Same table created on 10.5 right away allows to add the column in instant mode just fine.

      Attachments

        1. data-10.4.tar.gz
          546 kB
          Hartmut Holzgraefe

        Issue Links

          Activity

            People

              bar Alexander Barkov
              hholzgra Hartmut Holzgraefe
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.