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

Allow instant ADD COLUMN, ADD INDEX, LOCK=NONE

    XMLWordPrintable

    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: