WL#6731: Switch default engine to innodb in MTR
Status: Complete — Priority: Medium
Problem Statement ------------------- MySQL 5.5 changed the default storage engine from MyISAM to innodb . A change in storage engine has a big impact on the test suite. All the result files would change and lot of investigation is required to validate the new result files. In order to avoid changing the test suite it was decided to change MTR instead to start the server with MyISAM as the default. As a result of the above change the main MySQL functional test suite is running with MyISAM as the storage engine and test coverage on innodb is limited. Even the new tests and suites continue to run with MyISAM unless the tests specifically mention innodb as the storage engine Goal ------ The goal of this WL is to change MTR such that it starts the server with Innodb unless MyISAM explicitly specified in the test
Requirements -------------- R01 - MTR by default should start the server with the default storage engine, innodb R02 - The existing tests that do not explicitly specify any engine should continue to run with MyISAM until the result files are migrated to innodb R03 - Existing tests that explicity specify an engine should continue to run with the specified engine R04 - All suites and tests added to MTR after wl6731 have been pushed to trunk should run with the default storage engine of the server unless the test explicitly specifies another storage engine R05 - Tests that specify engine=innodb when creating tables, should no longer do that since it is now redundant, unless the tests runs the server with another engine as default
The code in the above branch has the following changes: 1. The default MyISAM has been changed to Innodb in mtr, the change can be found in mtr_cases.pm 2. All existing test cases except the ones that run Innodb has been changed to use MyISAM, a new quote # "This line and the line below is a temporary line for tests that do not need MyISAM in future, but need to be kept for tests that need it.\n--source include/force_default_myisam.inc" -- has been added to test cases. 3. A new file include/have_myisam.inc in source for future use and is empty. A new empty file include/force_default_myisam.inc has been added to be included in tests that require MyISAM. The idea is to keep the quote in point 2 for test cases which is still running MyISAM and remove it when it moves to Innodb, for test cases which will be running MyISAM even in future needs to keep this line. R01 - MTR by default should start the server with the default storage engine, innodb R01 has been satisfied. R02 - The existing tests that do not explicitly specify any engine should continue to run with MyISAM until the result files are migrated to innodb R02 satisfied. R03 - Existing tests that explicity specify an engine should continue to run with the specified engine R03 satisfied. RO4 - All new suites and tests should run with innodb unless the test explicitly specifies that it should run with another storage engine. R04 satisfied.
Copyright (c) 2000, 2018, Oracle Corporation and/or its affiliates. All rights reserved.