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

Change text column collation unnecessarily requires ALGORITHM=COPY

    XMLWordPrintable

Details

    Description

      The following test case succeeds only with copy algorithm

      --source include/have_innodb.inc
      CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT,
                       c3 TEXT CHARACTER SET utf8 COLLATE utf8_bin not null,
                       index(c3))ENGINE=InnoDB STATS_PERSISTENT=0;
      SHOW CREATE TABLE t1;
      ALTER TABLE t1 CHANGE c3 c3 TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci, algorithm=inplace;
      DROP TABLE t1;
      

      10.6 40aa94df356cfa000fc43c92ff0061212d1b161d

      mysqltest: At line 6: query 'ALTER TABLE t1 CHANGE c3 c3 TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci, algorithm=inplace' failed: ER_ALTER_OPERATION_NOT_SUPPORTED_REASON (1846): ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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