WL#7264: Migrate tests that do not have any engine dependencies
Affects: Server-8.0 — Status: Complete — Priority: Medium
Tests from main suite failing when run with default engine as innodb. Currently, these test have "have_myisam.inc" hence running with myisam. As a part of task we have to remove these inc file call and modify/fix test/result files according to innodb engine. Each test need to be analyzed well before making any changes.
Tests to be fixed. (please refer the attached file, test having "NO" for column "Engine Dependent" are consider for fixing. Comment field specifies reason of failure or what need to be changed ) Following tests are failing and failure has to be analysed and fixed. It is assumed that the tests do not have any engine dependency and differences seen will be minor like show create table, # rows in explain etc. If there are big differences and if the test is suspected to have any engine dependence please retain innodb and myisam variations of the test. main.sp main.show_check main.ps_ddl main.status main.multi_statement main.log_state main.union main.warnings main.flush_table main.events_bugs main.alter_table alter_table-big.test main.information_schema_part main.insert_notembedded main.case main.sp_notembedded main.count_distinct main.create_w_max_indexes_64 main.limit main.profiling main.ps_1general main.replace main.row main.delete main.select_found main.distinct main.errors main.flush main.foreign_key main.func_compress main.func_concat main.func_default main.func_group main.select_safe main.trigger_notembedded main.trigger_wl6030 main.type_blob main.type_date main.func_math main.type_datetime main.type_ranges main.func_str main.func_test main.type_temporal_fractional main.update main.user_var main.varbinary main.func_time main.view main.view_grant main.grant main.ssl main.grant2 main.grant4 main.greedy_search main.group_by main.ssl_compress main.wl6219-innodb main.mysqlbinlog main.handler_read_last main.having main.multi_update main.information_schema main.user_var-binlog main.metadata main.mysql main.negation_elimination main.null main.null_key_all main.null_key_icp main.null_key_none main.outfile main.parser main.query_cache main.trigger User Documentation ================== 5.8.0 changelog entry: Test cases that were intended to be storage engine-agnostic but were actually using a specific engine were corrected.
Copyright (c) 2000, 2019, Oracle Corporation and/or its affiliates. All rights reserved.