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

ALTER TABLE ... RENAME COLUMN syntax

    XMLWordPrintable

Details

    Description

      To rename a column, MariaDB provides this syntax:

      ALTER TABLE <table_name> CHANGE COLUMN old_name new_name column_definition

      which requires re-specification of all the attributes of the column.

      Disadvantages of the above syntax :

      • All the column information might not be available to the application trying to
        do the rename.
      • There is a risk of accidental data type change in the above syntax which might
        result in data loss.

      The proposed syntax, supported by MySQL 8.0, Oracle and PostgreSQL, is:

      ALTER TABLE <table_name> RENAME COLUMN old_name TO new_name;

      The new proposed syntax is expected to behave the same as "ALTER TABLE ...
      CHANGE" command used to rename column, without changing column attributes.

      The old syntax "ALTER TABLE ... CHANGE" to rename the column will continue
      to work.

      MySQL tickets: WL#10761, WL#6555

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23852 alter table rename column to uppercase doesn't work

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

          Task - A task that needs to be done. MDEV-17567 Atomic DDL

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

          Task - A task that needs to be done. MDEV-7318 RENAME INDEX

          • Major - Major loss of function.
          • 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-21941 RENAME doesn't work for system time or period fields

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22881 Unexpected errors, corrupt output, Valgrind / ASAN errors in Item_ident::print or append_identifier

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28576 RENAME COLUMN with NOCOPY algorithm leads to corrupt partitioned table

          • Major - Major loss of function.
          • Closed

          Activity

            People

              midenok Aleksey Midenkov
              quique Enrique Matías Sánchez
              Votes:
              5 Vote for this issue
              Watchers:
              5 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.