WL#6925: Migrate opt_trace suite to run with inndob

Status: Complete

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