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

When alter modify column, INSTANT algorithm cannot be used

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      https://mariadb.com/kb/en/innodb-online-ddl-operations-with-the-instant-alter-algorithm/#alter-table-modify-column

      When alter modify column, INSTANT algorithm cannot be used

      When alter table modify, there is no change in column type and size, but it seems that INSTANT algorithm cannot be used in case of temporal format change.
      I attach the sample test file as test.txt.
      And in the link above, such as the changes case of mariadb53 to mysql56, wouldn't it be better to add a mention where the INSTANT algorithm cannot be used to prevent issues that may occur when changing the temporal format of a column?

        Attachments

          Activity

            People

            Assignee:
            greenman Ian Gilfillan
            Reporter:
            sjco84 sangwoo kim
            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.