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

Add switch to old_mode to disable non-locking ALTER

Details

    Description

      Add a value to old_mode variable to disable the logic introduced in MDEV-16329, e.g. NO_ONLINE_COPY_ALTER or NO_NOLOCK_COPY_ALTER.

      Note: Just NO_ONLINE_ALTER doesn't work, as it's ambiguous due to the old ALTER ONLINE syntax.

      The value should not be set by default.

      If it is set,

      • ALTER TABLE without explicit ALGORITHM=COPY, LOCK=NONE should fall back to the old logic;
      • ALTER TABLE with explicit ALGORITHM=COPY, LOCK=NONE can be either allowed or forbidden, whichever is easier to implement.

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            nikitamalyavin Nikita Malyavin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]

            reviewed on slack

            serg Sergei Golubchik added a comment - reviewed on slack
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Nikita Malyavin [ nikitamalyavin ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nikitamalyavin Nikita Malyavin made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.2.1 [ 29034 ]
            Fix Version/s 11.2 [ 28603 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              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.