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

Disallow CREATE TEMPORARY TABLE…ROW_FORMAT=COMPRESSED

Details

    • 10.1.21

    Description

      MySQL 5.7 allows temporary tables to be created in ROW_FORMAT=COMPRESSED.
      The usefulness of this is questionable. In MySQL 8.0, WL#7899 prevents the creation of such compressed tables, so that all InnoDB temporary tables will be located inside the predefined InnoDB temporary tablespace.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11824 Allow ROW_FORMAT=DYNAMIC in the InnoDB system tablespace

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11202 InnoDB 10.1 -> 10.2 migration does not work

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-11585 Hard-code the shared InnoDB temporary tablespace ID

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11623 MariaDB 10.1 fails to start datadir created with MariaDB 10.0/MySQL 5.6 using innodb-page-size!=16K

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14240 sync0rw.ic:285 Assertion `!rw_lock_own(lock, RW_LOCK_X)' failed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29980 CREATE TEMPORARY TABLE ... LIKE does not work when original has ROW_FORMAT=COMPRESSED

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä added a comment -

            bb-10.2-mdev-11816
            (this contains also some other work on top of 10.2 in the preceding commits)

            marko Marko Mäkelä added a comment - bb-10.2-mdev-11816 (this contains also some other work on top of 10.2 in the preceding commits)
            jplindst Jan Lindström (Inactive) added a comment -

            ok to push.

            jplindst Jan Lindström (Inactive) added a comment - ok to push.
            marko Marko Mäkelä added a comment -

            repushed bb-10.2-mdev-11816, this time with the test files (and with the rebased/revised removal of MYSQL_ENCRYPTION, MYSQL_COMPRESSION, MYSQL_TABLESPACES)

            marko Marko Mäkelä added a comment - repushed bb-10.2-mdev-11816, this time with the test files (and with the rebased/revised removal of MYSQL_ENCRYPTION, MYSQL_COMPRESSION, MYSQL_TABLESPACES)

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.