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

Allow instant ADD COLUMN, ADD INDEX, LOCK=NONE

    Details

    • Sprint:
      10.3.3-1

      Description

      Currently, InnoDB allows instant ADD COLUMN together with DROP INDEX, but not with ADD INDEX, even if the index is to be added on some other column than the instantly added column.

      Also, if the table contains SPATIAL or FULLTEXT index, LOCK=NONE is wrongly refused for ADD COLUMN.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                marko Marko Mäkelä
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: