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

Merge InnoDB test cases from MySQL 5.7

    XMLWordPrintable

Details

    Description

      Until MDEV-11751 and MDEV-13481, the MariaDB process for merging changes from MySQL after 5.6 ignored additions to existing test cases or added test files.
      The preferred way of merging changes should be like the MySQL 5.7.19 merge: a merge of a cherry-pick of each relevant commit, and add test cases; if substantial changes to tests or code are needed, do them in separate commits.

      There are some behaviour changes in MariaDB that need to be taken into account. Most notably:

      • MariaDB 10.2 does not support CREATE TABLESPACE for InnoDB
      • MDEV-11426 Remove InnoDB INFORMATION_SCHEMA.FILES implementation
      • MDEV-11487 Revert InnoDB internal temporary tables from WL#7682
      • MDEV-5800 implemented indexed virtual columns in a slightly different way, and the InnoDB tests are in --suite=gcol
      • many startup&shutdown fixes (the innodb.log_* tests are already be present in 10.2 in modified form)
      • MDEV-13613 Dropping column from table that is part of a key fails in 10.2.8
      • MDEV-13564 made TRUNCATE TABLE and undo tablespace truncation compatible with backup
      • MDEV-14717 made renames crash-safe in InnoDB
      • MDEV-14585 Automatically remove #sql- tables in innodb dictionary during recovery

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

      • main.alter_table (WL#6555 "Online rename index", DISCARD/IMPORT, index comment, …)
      • main.alter_table-big
      • innodb.*
      • innodb_zip.*
      • innodb_fts.*
      • innodb_gis.*
      • innodb_stress.* (maybe not to be run on buildbot?)

      All the affected tests should be documented in this ticket in detail (especially those that are already covered by other MariaDB tests).
      The innodb_undo tests were rewritten in MDEV-17049.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20138 innodb.trx_id_future fails in buildbot

          • Major - Major loss of function.
          • Closed
          includes

          Task - A task that needs to be done. MDEV-4697 UPDATE_TIME field for XtraDB / InnoDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12251 InnoDB: Failing assertion: table->data_dir_path

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14231 MATCH() AGAINST( IN BOOLEAN MODE), results mismatch

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14252 innodb_fts.limit_union failed, results mismatch, MATCH .. AGAINST (.. IN BOOLEAN MODE)

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-14403 Review and fix tests from innodb_fts, innodb_zip, innodb_undo suites, merged from mysql 5.7

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19869 Port innodb_fts.fulltext2 from mysql to mariadb.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19886 InnoDB returns misleading ER_NO_SUCH_TABLE_IN_ENGINE

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20000 Consider adopting innodb.innodb_pagesize_max_recordsize from MySQL

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

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

          • Major - Major loss of function.
          • Closed
          relates to

          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

          Task - A task that needs to be done. MDEV-9260 Improve progress report on on-line alter table

          • Major - Major loss of function.
          • Open

          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-13818 CREATE INDEX leaks memory if running out of undo log space

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14218 rem0rec.cc:566: Assertion `!leaf' failed, innodb_gis.kill_server failed, sporadic,

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14238 row0row.ic:52: ulint row_get_trx_id_offset Assertion `len == 6' failed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14325 Mysqld crash, when innodb_open_files is greater than open_files_limit

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14335 foreign key silently becomes broken

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14418 Failing assertion: table->data_dir_path in row0mysql.cc line 4038

          • Major - Major loss of function.
          • Confirmed

          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-32690 After CREATE INDEX, InnoDB reports the index length as 0 if STATS_PERSISTENT=0

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32725 innodb.import_update_stats accesses uninitialized ib_table->stat_n_rows

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10568 Implement support for ALTER TABLE ... {DISCARD|IMPORT} PARTITION

          • Major - Major loss of function.
          • Open

          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-13716 point_big test fails in 10.2

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14207 innodb_gis.rtree_compress, innodb_gis.rtree_compress2, innodb_gis.rtree_purge failed in buildbot due to missing include

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14230 wrong relevance ranking for full-text searches

          • 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
          links to

          Web Link bb

          Web Link github bb-10.2-alice

          There are no Sub-Tasks for this issue.

          Activity

            People

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