WL#7279: Add engine clause to main suite subtest which requires myisam
We are making main suite tests run with innodb default engine. Each test contains multiple subtests. ( e.g "exmaple.test may be contain 100 subtest/testcases). Few tests are failing (when run with innodb as default engine) because one/more of the subtest from ".test" are myisam specific. We can't skip run of test with innodb as only small part of test is myisam. We will be adding engine=myisam clause to table where subtest is myisam specific. Hence it will make subtest run with myisam and rest of test with default engine. Tests changed as part of this will be - Subtest is myisam feature - Subtest written for myisam bug List of changed files: /mysql-test/r/create.result /mysql-test/r/flush.result /mysql-test/r/insert.result /mysql-test/r/insert_select.result /mysql-test/r/insert_update.result /mysql-test/r/key.result /mysql-test/r/lock.result /mysql-test/r/mysqldump.result /mysql-test/r/partition_mgm.result /mysql-test/r/ps.result /mysql-test/r/ps_1general.result /mysql-test/r/symlink.result /mysql-test/t/create.test /mysql-test/t/flush.test /mysql-test/t/insert.test /mysql-test/t/insert_select.test /mysql-test/t/insert_update.test /mysql-test/t/key.test /mysql-test/t/lock.test /mysql-test/t/mysqldump.test /mysql-test/t/partition_mgm.test /mysql-test/t/ps.test /mysql-test/t/ps_1general.test /mysql-test/t/symlink.test User Documentation ================== http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-4.html
Add "create table ..engine=myisam" clause to subtest , and re-record tests with expected results Result files are required to modify major due to following changes( apart "engine=myisam" change) - Expected difference in engine (as have_myisam is removed from test) value for show create table command - select order diff - table data due to transactional behavior( statement rollback on duplication)
Copyright (c) 2000, 2021, Oracle Corporation and/or its affiliates. All rights reserved.