WL#9272: Migrate tests that pass with no changes when run with Innodb engine

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

Following tests are passing without any changes when run with default-storage
engine Innodb. 

suite/federated/federated_server.test
t/compress.test
t/check.test
main.drop_debug.test
main.fix_priv_tables
t/temp_table.test
t/query_cache.test
main.query_cache_debug
t/perror-win.test
t/single_delete_update.test
t/update.test
t/subselect_debug.test
t/lock_multi_bug38691.test
t/mysqlbinlog_row_big.test
t/truncate_coverage.test
t/variables_debug.test
t/upgrade.test
t/mysql_locale_posix.test
t/gis-debug.test
t/signal_code.test
log_tables-big.test
main.events_time_zone  
main.events_stress  
main.information_schema-big        
main.variables-big                     
main.mysqlbinlog_row_big 
main.multi_plugin_load            
main.udf_skip_grants                    
main.kill_debug    
main.subquery_sj_innodb_all_bkaunique   
main.subquery_sj_innodb_none_bkaunique
main.count_distinct3  
main.events_embedded  
main.udf  
t/lock_multi_bug38499.test
log_tables_debug
main.mysql_client_test
main.variables
main.multi_update2
t/mysqlbinlog_raw_mode_win.test
main.type_newdecimal-big  

t/mysql_client_test_embedded.test	This test is in disabled state. Fails 
with
same error when run with Innodb or MyISAM. So force_myisam.inc can be removed
              


Following are MyISAM specific tests. These should specify ENGINE=MyISAM in
CREATE TABLE statements.
t/handler_myisam.test
t/myisam_debug.test
main.myisam_crash_before_flush_keys


The following changes are made, for the testcase which required patch:
----------------------------------------------------------------------
check.test :
Repair table supports for MyISAM temp tables, but does  not support for InnoDB 
temp tables, hence retained as MyISAM testcase and added a negative testcase for 
InnoDB.


main.temp_table.test:
MyISAM temp table supports optimize table
InnoDB temp table does not supports optimize,repair table
Hence added same testcase for InnoDB as a negative.

main.query_cache.test:(reverted the following changes due the Bug#23576337)

* mysqltest: At line 60: query 'select * from t3' failed: 1168: Unable to open 
underlying table which is differently defined or of non-MyISAM type or doesn't 
exist 
union operation with Non Myisam table does not supported, hence, retained as 
MyiSAM testcase.
A similar testcase is added for InnoDB, as a negative testcase


* test.t1	repair	note	The storage engine for the table doesn't support 
repair 
Repair does not support InnoDB table, hence retain as MyISAM.
REPAIR TABLE does not invalidate the query cache for an affected table, But it 
does not support InnoDB tables, hence same scenario could not be added, But as a 
negative testcase  you can refer check.test 

main.single_delete_update.test : 
Recorded the result files with InnoDB 
The sort merge passes value will get changed based on the innodb page size, 
hence need to add column masking.

main.update.test:
Recorded the result file and masking the non-deterministic columns of show 
status like and explain.
Added analyze table command for query plan mismatch  

main.variables.test:

No change, but MTR reports as before and after stats are not same , this problem 
also exist with MyiSAM, and happens only on local machines, this will be 
addressed separately if required
Following is the snippet : 
-table_open_cache	431
+table_open_cache	2000

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

Work was done for test suite. No user documentation required.