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

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3.37
    • None
    • Data Definition - Temporary
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11816 Disallow CREATE TEMPORARY TABLE…ROW_FORMAT=COMPRESSED

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            tgr Gergő Tisza created issue -
            tgr Gergő Tisza made changes -
            Field Original Value New Value
            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.             		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.
            tgr Gergő Tisza made changes -
            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.             		CREATE TEMPORARY TABLE ... LIKE is a convenient way to clone tables for testing, but table compression breaks it:

            {noformat}
            (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
            {noformat}

            It would be more sensible behavior to just ignore the origin table's ROW_FORMAT setting.
            alice Alice Sherepa made changes -

            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.