WL#7411: Migrate tests that do not show any result difference when run with innodb engine

Status: Complete   —   Priority: Medium

Innodb has been made the default engine for MTR
and we have also added a force_myisam_default.inc file to all existing tests to
avoid test failures due to result differences. There are many tests that have
absolutely no dependeny on the underlying engine and should just pass if run
without force_myisam_default.inc file. This WL will migrate tests in this 
category.
Identify tests that pass without any changes when run with innodb engine. Remove
following lines from these tests

# The include statement below is a temp one for tests that are yet to
#be ported to run with InnoDB,
#but needs to be kept for tests that would need MyISAM in future.
--source include/force_myisam_default.inc



These tests are already identified to belong to this class

  alias.test
  almost_full.test
  analyze.test
  bool.test
  bulk_replace.test
  client_xml.test
  comment_column.test
  comment_column2.test
  comment_index.test
  comment_table.test
  comments.test
  compare.test
  connect.test
  count_distinct2.test
  ctype_ascii.test
  ctype_cp1250_ch.test
  ctype_errors.test
  ctype_filename.test
  ctype_filesystem.test
  ctype_gbk_binlog.test
  ctype_hebrew.test
  ctype_latin2.test
  ctype_latin2_ch.test
  ctype_ucs2_def.test
  ctype_utf16_def.test
  ctype_utf8mb4_uca.test
  date_formats.test
  debug_sync.test
  default.test
  deprecated_features.test
  dirty_close.test
  disabled_replication.test
  disconnect_on_expired_password_default.test
  disconnect_on_expired_password_off.test
  drop.test
  empty_table.test
  events_1.test
  events_2.test
  events_grant.test
  events_logs_tests.test
  events_microsec.test
  events_restart.test
  events_scheduling.test
  execution_constants.test
  explain_json_all.test
  explain_json_none.test
  file_contents.test
  flush2.test
  fulltext2.test
  fulltext3.test
  fulltext_distinct.test
  fulltext_plugin.test
  fulltext_update.test
  func_crypt.test
  func_date_add.test
  func_des_encrypt.test
  func_digest.test
  func_encrypt.test
  func_encrypt_ucs2.test
  func_equal.test
  func_if.test
  func_isnull.test
  func_op.test
  func_sapdb.test
  func_set.test
  func_timestamp.test
  function_defaults.test
  gcc296.test
  get_diagnostics.test
  gis-precise.test
  gis-rt-precise.test
  grant3.test
  grant_cache.test
  grant_explain_non_select.test
  heap_auto_increment.test
  heap_btree.test
  heap_hash.test
  help.test
  implicit_char_to_num_conversion.test
  index_merge_myisam.test
  information_schema_chmod.test
  information_schema_db.test
  information_schema_parameters.test
  information_schema_routines.test
  init_connect.test
  init_file.test
  innodb_ignore_builtin.test
  ipv4_as_ipv6.test
  ipv6.test
  join_crash.test
  key_diff.test
  key_primary.test
  keywords.test
  loaddata.test
  loadxml.test
  locale.test
  log_tables.test
  log_tables_upgrade.test
  long_tmpdir.test
  lowercase_fs_off.test
  lowercase_mixed_tmpdir.test
  lowercase_table_grant.test
  lowercase_table_qcache.test
  lowercase_utf8.test
  lowercase_view.test
  mix2_myisam.test
  mix2_myisam_ucs2.test
  multi_plugin_load_add.test
  multi_plugin_load_add2.test
  multi_update_tiny_hash.test
  myisam-system.test
  myisam_explain_json_non_select_all.test
  myisam_explain_json_non_select_none.test
  myisam_explain_non_select_all.test
  myisam_explain_non_select_none.test
  myisam_row_rpl.test
  mysql_binary_mode.test
  mysql_comments.test
  mysql_config_editor.test
  mysql_cp932.test
  mysql_not_windows.test
  mysql_protocols.test
  mysql_upgrade.test
  mysql_upgrade_ssl.test
  mysqladmin.test
  mysqlbinlog_raw_mode.test
  mysqld--defaults-file.test
  mysqld--help-notwin.test
  mysqldump-compat.test
  mysqldump-no-binlog.test
  mysqldump_restore.test
  mysqlimport.test
  mysqlslap.test
  mysqltest.test
  no-threads.test
  no_binlog.test
  not_embedded_server.test
  odbc.test
  olap.test
  openssl_1.test
  optimizer_switch.test
  order_fill_sortbuf.test
  outfile_loaddata.test
  overflow.test
  packet.test
  parser_not_embedded.test
  parser_precedence.test
  parser_stack.test
  perror.test
  plugin.test
  plugin_load.test
  plugin_load_option.test
  plugin_not_embedded.test
  ps_10nestset.test
  ps_11bugs.test
  ps_ddl1.test
  ps_grant.test
  ps_not_windows.test
  query_cache_28249.test
  query_cache_disabled.test
  query_cache_notembedded.test
  query_cache_ps_no_prot.test
  query_cache_with_views.test
  read_only.test
  rename.test
  renamedb.test
  rewrite_general_log.test
  rewrite_slow_log.test
  rollback.test
  round.test
  rpl_mysqldump_slave.test
  schema.test
  server_uuid.test
  show_profile.test
  signal.test
  signal_demo1.test
  signal_demo2.test
  signal_demo3.test
  signal_sqlmode.test
  skip_grants.test
  skip_log_bin.test
  skip_name_resolve.test
  sp-big.test
  sp-bugs.test
  sp-code.test
  sp-destruct.test
  sp-dynamic.test
  sp-error.test
  sp-fib.test
  sp-lock.test
  sp-no-code.test
  sp-prelocking.test
  sp-security.test
  sp-threads.test
  sp-ucs2.test
  sp-vars.test
  sp_gis.test
  sp_stress_case.test
  sp_sync.test
  sp_validation.test
  status2.test
  status_bug17954.test
  strict_autoinc_1myisam.test
  strict_autoinc_3heap.test
  subquery_sj_innodb_all_bka.test
  subquery_sj_innodb_all_bka_nixbnl.test
  subquery_sj_innodb_none_bka.test
  subquery_sj_innodb_none_bka_nixbnl.test
  subselect_gis.test
  subselect_notembedded.test
  sum_distinct.test
  sysdate_is_now.test
  system_mysql_db.test
  system_mysql_db_refs.test
  tablelock.test
  timezone.test
  timezone2.test
  timezone4.test
  timezone_grant.test
  trans_read_only.test
  trigger-compat.test
  truncate.test
  type_temporal_upgrade.test
  type_time.test
  type_uint.test
  type_year.test
  user_limits.test
  variables-notembedded.test
  variables_community.test
  view_alias.test
  wait_timeout.test
  warnings_engine_disabled.test
  wl6301_1_not_windows.test
  wl6301_2_not_windows.test
  wl6301_3.test
  wl6443_deprecation.test
  xml.test