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

CREATE TEMPORARY TABLE ... LIKE does not work when original has ROW_FORMAT=COMPRESSED

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3.37
    • None
    • None
    • Debian Buster

    Description

      CREATE TEMPORARY TABLE ... LIKE is a convenient way to clone tables for testing, but table compression breaks it:

      (10:51) vagrant@localhost:[test]> CREATE TABLE t(c INT) ROW_FORMAT=COMPRESSED;
      Query OK, 0 rows affected (0.025 sec)
       
      (10:51) vagrant@localhost:[test]> CREATE TEMPORARY TABLE tt LIKE t;
      ERROR 4047 (HY000): CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
      Error (Code 4047): CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
      Warning (Code 1030): Got error 140 "Wrong create options" from storage engine InnoDB
      

      It would be more sensible behavior to just ignore the origin table's ROW_FORMAT setting.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tgr Gergő Tisza
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.