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.
Copyright (c) 2000, 2019, Oracle Corporation and/or its affiliates. All rights reserved.