WL#7264: Migrate tests that do not have any engine dependencies

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

Tests from main suite failing when run with default engine as innodb. Currently,
these test have "have_myisam.inc" hence running with myisam. As a part of task
we have to remove these inc file call and modify/fix test/result files according
to innodb engine.

Each test need to be analyzed well before making any changes.

Tests to be fixed. (please refer the attached file, test having "NO" for column
"Engine Dependent" are consider for fixing. Comment field specifies reason of
failure or what need to be changed )

Following tests are failing and failure has to be analysed and fixed. It is
assumed that the tests do not have any engine dependency and differences seen
will be minor like show create table, # rows in explain etc. If there are big
differences and if the test is suspected to have any engine dependence please
retain innodb and myisam variations of the test.

main.sp
main.show_check
main.ps_ddl
main.status
main.multi_statement
main.log_state
main.union
main.warnings
main.flush_table
main.events_bugs

main.alter_table
alter_table-big.test

main.information_schema_part
main.insert_notembedded
main.case
main.sp_notembedded
main.count_distinct
main.create_w_max_indexes_64
main.limit
main.profiling
main.ps_1general
main.replace
main.row
main.delete
main.select_found
main.distinct
main.errors
main.flush
main.foreign_key
main.func_compress
main.func_concat
main.func_default
main.func_group
main.select_safe
main.trigger_notembedded
main.trigger_wl6030
main.type_blob
main.type_date
main.func_math
main.type_datetime
main.type_ranges
main.func_str
main.func_test
main.type_temporal_fractional
main.update
main.user_var
main.varbinary
main.func_time
main.view
main.view_grant
main.grant
main.ssl
main.grant2
main.grant4
main.greedy_search
main.group_by
main.ssl_compress
main.wl6219-innodb
main.mysqlbinlog
main.handler_read_last
main.having
main.multi_update
main.information_schema
main.user_var-binlog
main.metadata
main.mysql
main.negation_elimination
main.null
main.null_key_all
main.null_key_icp
main.null_key_none
main.outfile
main.parser

main.query_cache
main.trigger

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

5.8.0 changelog entry:
Test cases that were intended to be storage engine-agnostic but
were actually using a specific engine were corrected.