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

Unclear documentation for "ALTER ONLINE TABLE"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • N/A
    • N/A
    • Documentation
    • None

    Description

      https://mariadb.com/kb/en/alter-table/#alter-online-table states that

      ALTER ONLINE TABLE ...;
      [...] This statement is equivalent to the following: ALTER TABLE ... LOCK=NONE;

      and then later

      This statement is equivalent to the following:
      ALTER TABLE ... ALGORITHM=INPLACE;

      So, is ALTER ONLINE TABLE equivalent to ALTER TABLE ... LOCK=NONE, ALGORITHM=INPLACE?

      If yes, it would be great to have that as a single line on top.

      Currently, it makes the impression that all three statements (ALTER ONLINE, ALGORITHM=INPLACE, LOCK=NONE) are equivalent, which I'm not sure is correct. If that's the case, stating it explicitly would also help to clarify things.

      (Reported on https://github.com/MariaDB/mariadb-documentation/issues/8, copied here for tracking purposes)

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            greenman Ian Gilfillan
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.