We have switched the default engine to innodb in MTR and added a line have_myisam.inc to all existing tests. This WL will migrate opt_trace suite to run with innodb engine.
Remove have_myisam.inc from the .test files that are not required to run with MyISAM
Implementation deatils: ----------------------- Funcs_2: -------- The following are the changes made to the tescases. 1. memory_charset.test: Removed this line : --source include/force_myisam_default.inc from the testcase 2. myisam_charset.test: Added the comments saying that, This is a myisam based testcase hence retained the following line. No other changes are made into the testcase files or result files. opt_trace: ----------- The following are the testcases, identified as InnoDB baseed testcases, hence modified the result files and as well the testcase files, In the testcase file removed only this line : --source include/force_myisam_default.inc 1.general_no_prot_all.test 2.general_no_prot_none.test 3.general_ps_prot_all.test 4.general_ps_prot_none.test 5.security_no_prot.test 6.security_ps_prot.test 7.charset.test (pass) 8.debug.test ( No result file modification) 9.temp_table.test (pass) 10.eq_range_statistics.test Fixed by adding --source include/have_innodb_16k.in ( This line added becuase the testcase fails with page size 4K ) The following testcases , have been indetified as MyISAM based. Hence added only this line in the testcase (#Start server with MyISAM) , no result file modifications are done. 1.bugs_no_prot_all.test 2.bugs_no_prot_none.test 3.bugs_ps_prot_all.test 4.bugs_ps_prot_none.test 5.general2_no_prot.test 6.general2_ps_prot.test 7.subquery_no_prot.test 8.subquery_ps_prot.test The following files,were identified as InnoDB based files,But later reverted the changes back to MyISAM,since these testcases are failing consistently, when running with InnoDB. 1.filesort_pq.test 2.range_no_prot.test 3.range_ps_prot.test Following ways tried to make them pass. * Added CREATE TABLE statement with ENGINE=InnoDB * Added Analyze table in the testcases file, after insert. * Recorded the new result file with InnoDB 30/Apr/2013 * After the comments, the following testcases are reverted back to MyISAM 1.general_no_prot_all.test 2.general_no_prot_none.test 3.general_ps_prot_all.test 4.general_ps_prot_none.test