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

Instant Add Column Documentation Clarification

    XMLWordPrintable

    Details

      Description

      https://mariadb.com/kb/en/library/instant-add-column-for-innodb/ states in the Limitations section:

      "If the table becomes empty (either via TRUNCATE or DELETE), the table will be converted to the old "non-instant" format."

      The fact that this is listed as a limitation, and the fact that it makes reference to 'the old "non-instant" format' both imply some sort of limitation. This leads users to understand that the instant add column ability is being lost in cases where the documentation states the table is being converted to "the old format".

      Explaining that columns added 'instantly' are stored in separate structures associated with the table like BLOB columns, and operations like emptying the table take the opportunity to flatten out the table definition, incorporating the instantly added columns into the main table structure, without referring to it as "the old non-instant format", would avoid the misunderstanding.

        Attachments

          Activity

            People

            • Assignee:
              KennethDyer Kenneth Dyer
              Reporter:
              juan.vera Juan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: