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

When alter modify column, INSTANT algorithm cannot be used

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Documentation
    • 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

            greenman Ian Gilfillan
            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.