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

Allow instant ADD COLUMN, ADD INDEX, LOCK=NONE

    XMLWordPrintable

Details

    • 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

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14396 Assertion `(ha_alter_info->handler_flags & ~INNOBASE_INPLACE_IGNORE) == Alter_inplace_info::CHANGE_CREATE_OPTION' failed in create_option_need_rebuild

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15828 Server crash or assertion `num_fts_index <= 1' failure upon ALTER TABLE adding two fulltext indexes

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14219 Allow online table rebuild when encryption or compression parameters change

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14246 Skip the ha_innobase::prepare_inplace_alter_table() phase if no inplace_alter_table() phase is needed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28912 Assertion `ha_alter_info->key_count + (dict_table_get_first_index(ctx->new_table))->is_gen_clust() + .... in bool prepare_inplace_alter_table_dict

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-11369 Instant add column for InnoDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30969 Some ALGORITHM=INSTANT checks are missing from handler::can_convert_nocopy()

          • Major - Major loss of function.
          • Open

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.