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

Merge InnoDB test cases from MySQL 5.6

    XMLWordPrintable

Details

    Description

      Until now, the MariaDB process for merging changes from MySQL 5.6 is ignoring additions to tests (new test cases or test files), even though Oracle has been publishing tests for other than security bug fixes for quite some time now.

      Several InnoDB tests are missing as a result of this. I have added some of them. Especially some tests for ALTER TABLE…ALGORITHM=INPLACE are missing.

      To make the task more challenging, some tests may have been renamed or refactored in MySQL or MariaDB. For example, the innodb_zip suite was refactored from tests in the InnoDB suite.

      Also, MariaDB supports slightly different semantics and SQL syntax than MySQL. So, some tests will necessarily be different or not applicable.

      That said, we must ensure that all applicable test cases from the following MySQL 5.6 tests are present in MariaDB 10.0:

      • main.alter_table (missing stuff like "Test for ALTER column DROP DEFAULT")
      • innodb.*
      • innodb_zip.*
      • innodb_fts.*

      All the affected tests should be documented in this ticket in detail (especially those that are already covered by other MariaDB tests).

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-13626 Merge InnoDB test cases from MySQL 5.7

          • Major - Major loss of function.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13647 Mysql Bug#11815557 60269: reject attempts to create system tables in incorrect engine

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13668 InnoDB unnecessarily rebuilds table when renaming a column and adding index

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18618 Merge innodb_zip.8k, innodb_zip.4k, innodb_zip.16k

          • Major - Major loss of function.
          • Confirmed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22379 Cherry-pick mysql-5.6:mysql-test/suite/rpl/r/rpl_binlog_format_errors.test

          • Major - Major loss of function.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-4784 merge test cases from 5.6

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13654 Various crashes due to DB_TRX_ID mismatch in table-rebuilding ALTER TABLE…LOCK=NONE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13671 InnoDB should use case-insensitive column name comparisons like the rest of the server

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13680 InnoDB may crash when btr_page_alloc() fails

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13795 ALTER TABLE…DROP PRIMARY KEY, ADD PRIMARY KEY fails when VIRTUAL columns exist

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20094 InnoDB blob allocation allocates extra extents

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13359 Enable online ALTER TABLE for compressed columns

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13613 Dropping column from table that is part of a key fails in 10.2.8

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13640 ALTER TABLE CHANGE and ADD INDEX on auto_increment column fails with "Incorrect key file for table..."

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13693 innodb.innodb-index-online-fk fails with mismatch on Windows, prints garbage instead of column name

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14140 IMPORT TABLESPACE must not go beyond FSP_FREE_LIMIT

          • Major - Major loss of function.
          • Closed

          Activity

            People

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