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

RENAME INDEX

    XMLWordPrintable

Details

    Description

      1) MySQL 5.7 has RENAME INDEX, MariaDB should, too.

      http://dev.mysql.com/doc/refman/5.7/en/alter-table.html
      "RENAME INDEX old_index_name TO new_index_name" renames an index.

      2) My permute-index tool creates synthetic index names that need to be renamed later for esthetic reasons (ie. idx_jb_007.)

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23356 InnoDB: Failing assertion: field->col->mtype == type, crash or ASAN failures in row_sel_convert_mysql_key_to_innobase, InnoDB indexes are inconsistent after INDEX changes

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25555 Server crashes in tree_record_pos after INPLACE-recreating index on HEAP table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          duplicates

          Task - A task that needs to be done. MDEV-18196 ALTER TABLE RENAME INDEX

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13301 Optimize DROP INDEX, ADD INDEX into RENAME INDEX

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16290 ALTER TABLE ... RENAME COLUMN syntax

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21889 IF EXISTS clause does not work for RENAME COLUMN and RENAME INDEX

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25803 Inplace ALTER breaks MyISAM/Aria table when order of keys is changed

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              midenok Aleksey Midenkov
              mrperl James Briggs
              Votes:
              6 Vote for this issue
              Watchers:
              10 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.