WL#7402: Migrate tests in main suite for federated, blackhole, merge and csv engines

Status: Complete   —   Priority: Medium

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.