WL#9489: Migrate main suite to run with innodb (part 14)

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

This is a continuation of migrate main suite to run with innodb storage
engine. Several tests were migrated in previous WLs. This one will migrate tests
that appear to be relatively easy to fix. 

Following changes are made:
---------------------------
main.group_by.test : 
1. Order may vary when NULL is used in order by clause , its ok
2. The group by query is an invalid query , so absurd results are expected when 
set SQL_MODE=''
   When SQL_MODE=only_full_group_by  both storage engines throws an error this is 
an expected 
3. ANALYZE TABLE added to avoid explain mismatch

main.ctype_latin1_de.test : 
The auto_inc column should be a key column , in order to become index column for 
innoDB. For Myisam this need not be a case. 

InnoDB behavior:
When the auto_inc column is a secondary column in a multiple-column index, then a 
key needs (primary/unique) to be added or the other solution is that, without 
adding key attribute , make the auto_inc column as a primary column in a DDL 
statement.

Look at the reference manual : http://dev.mysql.com/doc/refman/5.7/en/example-
auto-increment.html

For Myisam the implementation is different 


Following testcases already migrated to InnoDB, hence not touched
------------------------------------------------------------------
main.handler_myisam.test
main.count_distinct.test

User Documentation
==================

Work was done for test suite. No user documentation needed.
t/ddl_i18n_koi8r.test	Record show create table
t/func_regexp.test	Minor difference in EXPLAIN. Must be ok to record
t/func_default.test	Minor difference in EXPLAIN. Must be ok to record
t/events_time_zone.test	Passes without changes. Remove force_myisam.inc
t/func_concat.test	Difference in SELECT output. 
t/group_by.test	Explain difference. Test is validating result, so should be ok
to record
t/func_compress.test	Minor difference in EXPLAIN. Must be ok to record
t/func_like.test	Minor explain difference. Should be ok to record
t/func_test.test	Minor explain difference. Should be ok to record
t/type_datetime.test	Minor explain difference. Should be ok to record
t/row.test	Minor result diff
t/windows.test	Minor explain difference. Should be ok to record
t/null_key_none.test	Minor difference in EXPLAIN. Must be ok to record
t/count_distinct.test	Minor result diff
t/create-big.test	Difference in show create table and binlog content. 
t/ctype_latin1_de.test	Difference in autoinc behavior. Needs to be modified to
work with innodb
t/error_simulation.test	Record show create table
t/handler_myisam.test	Clearly MyISAM test. Add ENGINE=MyISAM to create table
statements
t/metadata.test	Difference in SELECT output. 
t/ddl_i18n_utf8.test	Record show create table