WL#7411: Migrate tests that do not show any result difference when run with innodb engine
Status: Complete
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
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.