WL#7402: Migrate tests in main suite for federated, blackhole, merge and csv engines
We have switched the default engine to innodb in MTR and added a line force_myisam_default.inc to all existing tests. This WL will migrate the tests in main suite that are meant for engines other than innodb or myISAM. Since these are not MyISAM tests the MyISAM engine switch is not required. Remove force_myisam_default.inc and associated comments from the affected tests. User Documentation ================== http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-4.html
Tests to be migrated are: archive-big.test archive_bitfield.test archive_debug.test archive_gis.test archive_no_symlink.test archive_plugin.test archive_symlink.test archive.test blackhole_plugin.test blackhole.test csv_alter_table.test csv_not_null.test csv.test merge-big.test merge_mmap.test merge_recover.test merge.test
Except the following tests other tests passed when run with Innodb as default storage engine. 1)merge.test 2)archive_plugin.test 3)blackhole_plugin.test merge.test failed with the following failure when run with InnoDB storage engine. "1168: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist" Added ENGINE=MyISAM to all the create table statements which cause the above failure. The last 2 plugin tests failures are not because of change in the engine but because of change in MySQL server behavior of handling usage of disabled engines. The create table statements in the tests ( created with respective disabled storage engines ) show error instead of warning. Hence changed the tests according to the expected behavior and updated the result files.
Copyright (c) 2000, 2021, Oracle Corporation and/or its affiliates. All rights reserved.