WL#11700: Migrate optimizer tests from main suite to run with default engine innodb (subquery_sj)

In latest releases , innodb is made as default engine. But tests from main 
suite are written considering myisam as engine from start. As count of tests from 
main suite is , so modifications  (tests and/or result) for innodb is big task. 
We currently continue to run main suite test with "myisam" by calling
"include/force_myisam_default.inc" .
So as to make test run with innodb we have to adjust test(and/or result) and
remove "include/force_myisam_default.inc" from each test.

This WL targets changing optimizer related test (where tests are failing mainly
due to difference in explain output )when run with innodb as default engine.
Difference in explain output is for
- index used
- rows ( which vary for innodb)
- Comment field 

**List of test which have failure/result difference related to optimizer (they
might have additional difference too )

Major diff in explain which is recorded for myisam  + parent/child delete error

main.subquery_sj_all
main.subquery_sj_all_bka
main.subquery_sj_all_bka_nixbnl
main.subquery_sj_dupsweed
main.subquery_sj_dupsweed_bka
main.subquery_sj_dupsweed_bka_nixbn
main.subquery_sj_firstmatch
main.subquery_sj_firstmatch_bka
main.subquery_sj_firstmatch_bka_nixbnl
main.subquery_sj_loosescan
main.subquery_sj_loosescan_bka
main.subquery_sj_loosescan_bka_nixbnl
main.subquery_sj_mat
main.subquery_sj_mat_bka
main.subquery_sj_mat_bka_nixbnl
main.subquery_sj_mat_nosj
main.subquery_sj_none
main.subquery_sj_none_bka
main.subquery_sj_none_bka_nixbnl