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ä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.21 [ 130 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            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)
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            jplindst Jan Lindström (Inactive) added a comment -

            ok to push.

            jplindst Jan Lindström (Inactive) added a comment - ok to push.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            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)
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.2.4 [ 22116 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2017-01-18 06:57:04.0 2017-01-18 06:57:04.037
            marko Marko Mäkelä made changes -
            Fix Version/s 10.2.4 [ 22116 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 79228 ] MariaDB v4 [ 151544 ]
            alice Alice Sherepa made changes -
            marko Marko Mäkelä made changes -

            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.