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

CREATE TABLE ... LIKE is not documented completely

    XMLWordPrintable

Details

    Description

      CREATE TABLE ... LIKE creates the new table in a specific non expected way:

      "The copy is created using the same version of the table storage format as the original table. "
      https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html

      This can also be seen in the comment from Elena dated 2014-12-09 18:07
      https://jira.mariadb.org/browse/MDEV-7268

      This means that if the original table is in an old format with old data types the old format remains and now new data types are used.

      This is IMHO fundamentally important to know as an administrator. Please add this documentation here:
      https://mariadb.com/kb/en/create-table/#create-table-like

      I have the impression that ALTER TABLE ... FORCE behaves the same but I did not investigate further...

      Attachments

        Issue Links

          Activity

            People

              greenman Ian Gilfillan
              oli Oli Sennhauser
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.