WL#10185: Remove all references to embedded server from tests

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

WL#9816 has removed ability to build embedded server. This WL should remove all 
references in tests and MTR

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

None needed.
Remove all references of embedded server from MTR tests.

-Remove embedded server reference from comment section.

-Remove include files to check embedded server mode.

-Rename test/results/opt/cnf/inc files that has a string embedded in its filename

-Remove condition checks for embedded server from tests and include files.

-Remove test,result,opt and cnf files that is specific to embedded server and      
sources is_embedded.inc

-Remove test cases associated to embedded server.

-Modify tests to remove sourcing of not_embedded.inc and 
not_windows_embedded.inc

-Record new results in case of modification of test.

-Merge test for not_embedded mode to the main test. For example: 
internal/mysql-test/suite/i_main/t/func_like_not_embedded.test to func_like.test
Following tests along with their results and opt files  have been removed
===============================================================================

mysql-test/suite/funcs_1/t/is_columns_is_embedded.test
mysql-test/suite/funcs_1/t/is_columns_is_embedded_ci.test
mysql-test/suite/funcs_1/t/is_columns_myisam_embedded.test
mysql-test/suite/funcs_1/t/is_columns_mysql_embedded.test
mysql-test/suite/funcs_1/t/is_key_column_usage_embedded.test
mysql-test/suite/funcs_1/t/is_key_column_usage_embedded_ci.test
mysql-test/suite/funcs_1/t/is_routines_embedded.test
mysql-test/suite/funcs_1/t/is_schemata_embedded.test
mysql-test/suite/funcs_1/t/is_schemata_embedded_ci.test
mysql-test/suite/funcs_1/t/is_statistics_mysql_embedded.test
mysql-test/suite/funcs_1/t/is_table_constraints_mysql_embedded.test
mysql-test/suite/funcs_1/t/is_tables_embedded.test
mysql-test/suite/funcs_1/t/is_tables_embedded_ci.test
mysql-test/suite/funcs_1/t/is_tables_myisam_embedded.test
mysql-test/suite/funcs_1/t/is_tables_mysql_embedded.test
mysql-test/suite/funcs_1/t/is_triggers_embedded.test
mysql-test/suite/funcs_1/t/is_views_embedded.test
mysql-test/suite/funcs_1/t/is_views_embedded_ci.test
mysql-test/suite/innodb/t/tablespace_embedded.test
mysql-test/suite/innodb/t/tablespace_embedded_windows.test
mysql-test/suite/ndb/t/ndb_bug22904640_embedded.test
mysql-test/suite/perfschema/t/show_embedded.test
mysql-test/t/events_embedded.test
mysql-test/t/mysql_client_test_embedded.test
mysql-test/t/mysql_embedded.test
mysql-test/t/mysql_embedded_client_test.test
mysql-test/suite/funcs_1/t/is_routines.test
mysql-test/suite/funcs_1/t/is_key_column_usage.test
mysql-test/suite/funcs_1/t/is_key_column_usage_ci.te
mysql-test/t/trigger_notembedded.cnf
mysql-test/t/sp_notembedded.cnf
mysql-test/t/mysql_embedded-master.opt

Following include files have been removed
===============================================================================
mysql-test/include/is_embedded.inc
mysql-test/include/not_embedded.inc
mysql-test/include/not_windows_embedded.inc
mysql-test/suite/auth_sec/include/not_embedded.inc
mysql-test/suite/funcs_1/datadict/is_key_column_usage.inc
mysql-test/suite/funcs_1/datadict/is_routines.inc 

Following tests and their corresponding results and opt files have been renamed
===============================================================================
mysql-test/t/flush_block_commit_notembedded.test -> mysql-
test/t/flush_block_commit_have_log_bin.test
internal/mysql-test/suite/i_main/t/sp_notembedded.test -> sp_not_windows.test 

Following tests have been merged 
================================================================================
mysql-test/t/insert_notembedded.test to insert.test
mysql-test/t/events_trans_notembedded.test t0 events_trans.test
internal/mysql-test/suite/i_main/t/func_like_not_embedded.test to func_like.test
mysql-test/suite/innodb/t/create_tablespace_notembedded.test to 
create_tablespace.test
mysql-test/suite/innodb/t/innodb_notembedded.test to innodb.test
mysql-test/t/parser_not_embedded.test to parser.test
mysql-test/t/plugin_not_embedded.test to plugin.test
mysql-test/t/ps.test  to ps_ddl.test
mysql-test/t/query_cache_notembedded.test to query_cache.test
mysql-test/t/schema_not_embedded.test to schema.test
mysql-test/t/sp_notembedded.test to sp.test
mysql-test/t/subselect.test  to subquery.inc
mysql-test/t/trigger_notembedded.test  to trigger.test
mysql-test/t/variables-notembedded.test to variables.test

Test cases from mysql-test/t/not_embedded_server.test have been moved to 
following tests
================================================================================
BUG#43835 to variables.test
BUG#58026 to func_regexp.test
WL#4284 to lock.test
BUG#54812 to errors.test
Bug#12601974 to sql_mode.test