# coding: utf-8 # OceanBase Deploy. # Copyright (C) 2021 OceanBase # # This file is part of OceanBase Deploy. # # OceanBase Deploy is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # OceanBase Deploy is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with OceanBase Deploy. If not, see . psmall_test=[ ###=== sql engine 3.0 test 'static_engine.table_scan_oracle', 'static_engine.table_insert_oracle', 'static_engine.table_insert', 'static_engine.hash_set', 'static_engine.merge_set', 'static_engine.merge_set_oracle', 'static_engine.hash_distinct', 'static_engine.nested_loop_join', 'static_engine.nested_loop_join_oracle', 'static_engine.merge_join', 'static_engine.merge_join_oracle', 'static_engine.explicit_cast', 'static_engine.expr_abs', 'static_engine.expr_add_months_oracle', 'static_engine.expr_and_or_oracle', 'static_engine.expr_and_or', 'static_engine.expr_arith_oracle', #'static_engine.expr_arith', 'static_engine.expr_ascii_oracle', 'static_engine.expr_ascii', 'static_engine.expr_bit_andor_oracle', 'static_engine.expr_bool', 'static_engine.expr_chr_oracle', #'static_engine.expr_coalesce_oracle', #'static_engine.expr_coalesce', 'static_engine.expr_collation', 'static_engine.expr_concat_oracle', 'static_engine.expr_concat', 'static_engine.expr_conv', 'static_engine.expr_datediff', 'static_engine.expr_date', 'static_engine.expr_des_hex_str', 'static_engine.expr_dump_oracle', 'static_engine.expr_dump', 'static_engine.expr_elt', 'static_engine.expr_empty_arg', 'static_engine.expr_estimate_ndv', 'static_engine.expr_field', 'static_engine.expr_find_in_set', 'static_engine.expr_from_unixtime', 'static_engine.expr_get_sys_var', 'static_engine.expr_hextoraw_oracle', 'static_engine.expr_initcap_oracle', 'static_engine.expr_insert', 'static_engine.expr_instr_oracle', 'static_engine.expr_is_oracle', 'static_engine.expr_is_serving_tenant', 'static_engine.expr_is', 'static_engine.expr_last_day_oracle', 'static_engine.expr_least_oracle', #'static_engine.expr_least', 'static_engine.expr_left', 'static_engine.expr_lengthb_oracle', 'static_engine.expr_length_oracle', 'static_engine.expr_length', 'static_engine.expr_lnnvl_oracle', 'static_engine.expr_lnnvl', 'static_engine.expr_location', 'static_engine.expr_lower_upper_oracle', 'static_engine.expr_lower_upper', 'static_engine.expr_math', 'static_engine.expr_md5', 'static_engine.expr_mid', 'static_engine.expr_months_between_oracle', 'static_engine.expr_neg_oracle', 'static_engine.expr_neg', 'static_engine.expr_next_day_oracle', 'static_engine.expr_not', 'static_engine.expr_nullif_ifnull', 'static_engine.expr_nullif_oracle', 'static_engine.expr_nvl', 'static_engine.expr_pad_oracle', 'static_engine.expr_pad', 'static_engine.expr_part_hash_oracle', 'static_engine.expr_part_hash', 'static_engine.expr_part_key', 'static_engine.expr_regexp_func_oracle', 'static_engine.expr_regexp_func', 'static_engine.expr_regexp', 'static_engine.expr_repeat', 'static_engine.expr_replace_oracle', 'static_engine.expr_replace', 'static_engine.expr_space', 'static_engine.expr_str', 'static_engine.expr_substring_index', 'static_engine.expr_substr_oracle', 'static_engine.expr_substr', 'static_engine.expr_sys_privilege_check', 'static_engine.expr_time_diff', 'static_engine.expr_time_oracle', 'static_engine.expr_timestampadd', 'static_engine.expr_todays', 'static_engine.expr_to_interval_oracle', 'static_engine.expr_to_number_oracle', 'static_engine.expr_translate_oracle', 'static_engine.expr_trigonometric_oracle', 'static_engine.expr_trim_oracle', 'static_engine.expr_trim', 'static_engine.expr_trunc_oracle', 'static_engine.expr_trunc', 'static_engine.expr_unhex', 'static_engine.expr_xor', 'static_engine.hash_distinct', 'static_engine.hash_set', 'static_engine.material', 'static_engine.merge_join_oracle', 'static_engine.merge_join', 'static_engine.merge_set_oracle', 'static_engine.merge_set', 'static_engine.monitoring_dump', 'static_engine.nested_loop_join_oracle', 'static_engine.nested_loop_join', 'static_engine.partition_split_oracle', 'static_engine.partition_split', 'static_engine.px_basic', 'static_engine.sort_oracle', 'static_engine.static_engine_case_oracle', 'static_engine.static_engine_case', 'static_engine.static_engine_cmp_null', 'static_engine.static_engine_hash', 'static_engine.static_engine_implicit_cast_oracle', 'static_engine.subplan_filter', 'static_engine.table_insert_oracle', 'static_engine.table_insert', 'static_engine.table_scan_oracle', 'static_engine.table_scan', 'static_engine.subplan_scan_oracle', 'static_engine.subplan_scan', 'static_engine.expr_nextval', 'static_engine.expr_decode_oracle', 'static_engine.expr_unix_timestamp', 'static_engine.expr_char_length', 'static_engine.expr_assign', 'static_engine.expr_get_user_var', 'static_engine.expr_get_user_var_oracle', 'static_engine.expr_orahash_oracle', 'static_engine.expr_sign', #'static_engine.expr_decode_oracle', #'static_engine.datetime_exprs_oracle', farm多了一行 #'static_engine.expr_to_temporal_oracle', farm多了一行 #'static_engine.expr_abs_oracle', farm多了一行 #'static_engine.sort_year_bug', #'static_engine.plan_cache_check_right_oracle', #'static_engine.expr_between', #'static_engine.expr_bitwise', #'static_engine.expr_date_add', #'static_engine.expr_empty_arg_oracle', #'static_engine.expr_math_oracle', #'static_engine.expr_nvl_oracle', #'static_engine.expr_round_oracle', #'static_engine.expr_round', #'static_engine.expr_sign_oracle', #'static_engine.expr_time', #'static_engine.groupby_oracle', #'static_engine.groupby', #'static_engine.hash_groupby_oracle', #'static_engine.hash_groupby', #'static_engine.hash_join', #'static_engine.merge_distinct', #'static_engine.plan_cache_check_right_oracle', #'static_engine.px_repart', #'static_engine.sort', #'static_engine.static_engine_compare', #'static_engine.static_engine_implicit_cast', #'static_engine.static_engine_row_cmp', #'static_engine.topk.test', ###=== sql engine 3.0 test end #####'partition_split', #'rowscn_oracle', 'execution_partition_pruning_mysql', 'execution_partition_pruning_oracle', 'part_mg.basic_partition_mg1', 'part_mg.basic_partition_mg_pg3', 'bulk_insert', 'sfu_norow_alias', 'global_index.global_index_lookup_1', 'global_index.global_index_lookup_2', 'global_index.global_index_lookup_3', 'global_index.global_index_lookup_4', 'global_index.global_index_lookup_5', 'empty_input', 'selectotherdb', 'special_hook', 'substring_index', 'special_stmt', 'bug210026', ####'default_system_variable', ####'java', 'escape', 'largetimeout', 'count', 'expr.expr_position', 'type_date.test_select_usec_to_time', 'aggr_bug200109', 'aggr_bug200109_oracle', 'driver5114_bug', ####'teststricttime', 'chinese', 'distinct', 'type_date.timestamp2', 'ms_lose_rollback', 'ms_lose_rollback_oracle', 'column_alias', 'h', ####'r_trx', 'number.bug229955_positive_int', 'bug233498_rename_table_jianming', 'bug200747', 'alias3', 'expr.expr_ceil', 'expr.func_length', ####'trans_query', 'replace_null', 'func_group_5', 'explain', 'bool', ####'hints', 'outer_join_where_is_null', 'groupby.group_by_4', 'groupby.group_by_4_oracle', 'datatype_java', 'bug5910265_update_orderby_limit_dilang', 'join_basic', 'type_varchar_2', 'sq_from_2', ####'idx_unique_gmt', 'compare', 'func_group_6', 'join.nested_loop_join_right_null_joinon_where', 'join.nested_loop_join_right_null_joinon_where_oracle', 'type_date.add_timestamp_column', 'trx_4', ####'sp_trans', 'safe_null_test', 'null2', 'join.nested_loop_join_right_null_joinon', 'join.nested_loop_join_right_null_joinon_oracle', 'limit', 'alias2', 'join_many_table_single_field', 'non_reserved_keyword', 'update_column_use_other', 'update_column_use_other_oracle', 'empty_table', 'expr.expr_nseq', 'expr.expr_floor', 'groupby.group_by_2', 'groupby.group_by_2_oracle', 'trx_5', 'join_many_table', 'type_date.expr_date_add_sub', 'expr.func_equal', 'truncate_table', ####'select_bug', 'duplicate_key', 'type_date.timefuncnull', 'get', 'get_oracle', 'join.nested_loop_join_right_null', 'join.nested_loop_join_right_null_oracle', 'trans_ac', 'delete.deleteV2', 'rowkey_is_null', ####'subquery', 'rowkey_is_int', ####'tsc', 'sq_from', 'rename_table2', 'join_star', ####'create_view', 'pk_num_boundary', 'type_date.daylight_saving_time', 'intersect', 'join_null', 'identifier_name_length', 'delete.delete', 'delete.delete_from_mysql', 'type_date.datetime_java', 'expr.collation_expr', #'ddl_operation', 'jp_length_utf8', #'jp_length_utf8_oracle', 'rowkey_update_datatype_convert', 'join_equivalent_transfer', 'update_range', #'jdbc_autocommit', 'ddlrollback', 'bench_count_distinct', ####'sfu', ####'update_behavior', 'expr.func_regexp', 'join_using1', 'type_date.updaterowkeymoditime', 'except', 'except_oracle', ####'truncate', 'func_group_1', 'rowkey_is_char', 'type_date.type_create_time', ####'write_consistency_byjiuman', 'delete.delete_range', 'groupby.group_by_basic', 'range', 'range_oracle', 'select_basic', 'type_date.type_modify_time', 'fin', 'func_group_7', 'expr.expr_instr', 'insert.insert_and_update_not_null_oracle', #'auto_increment', 'autocommit', ####'privilege', 'connection', 'view', 'bug_different_tranid_intrx', 'createvarchar', 'createsql', ####'join', #'plan_cache.plan_cache_check_right', #'plan_cache.plan_cache_basic', 'plan_cache.plan_cache_basic_oracle', 'plan_cache.plan_cache_select_list', 'plan_cache.plan_cache_select_list_oracle', 'plan_cache.plan_cache_check_right_oracle', 'plan_cache.plan_cache_multi_query_oracle', 'plan_cache.plan_cache_multi_query', 'plan_cache.neg_sign', 'plan_cache.neg_sign_oracle', #'plan_cache.char_and_varchar_oracle', #'plan_cache.all_type_hit_count_oracle', 'with_clause.cte_without_explain_a_oracle', 'with_clause.cte_without_explain_b_oracle', 'with_clause.cte_without_explain_c_oracle', 'bug_setEmptyPwd', 'trx_6', 'add', 'minus', 'div', 'expr.minus_oracle', 'expr.mul', 'expr.mul_oracle', 'expr.div_oracle', 'expr.expr_is_oracle', 'expr.expr_locate', ####'trx_basic', 'trx_timeout_bug', ####'minitest', 'a_trade_quick', 'view_2', ####'big_trans', 'big_trans_with_mutil_redo', ####'tenant2', ####'trx_rowkey_range_in', ####'trx_3', ####'trx_2', #'show', 'idx_unique_many_idx_one_ins', ####'idx_with_const_expr_24_select_for_update_dilang', ####'parallel_update_rollback', ####'sfu_norow_type', ####'index_aggrigate', 'two_order_by', ####'update_test', ####'index_27_trx_concu_dml_samerow_rollback', ####'index_23_trx_concu_trxs_with_storing', ####'index_22_trx_concu_trxs', ####'trx_rowkey_range', 'parallel_insert', 'parallel_insert_oracle', #'index_21_trx_concu_default', ####'index_basic', 'index_49_alias', 'index_49_alias_oracle', #'selbug', #'create_index_in_table_select_get', 'index_47_NULL', 'index_47_NULL_oracle', ####'trx_update', ####'index_15_range', ####'index_08_insert_null_after_freeze', 'index_14_hint', #'parallel_insert_rollback', ####'trx_for_update', ####'index_25_trx_concu_dml_samerow_with_storing', ####'index_20_trx_concu_multi_dml', ####'index_15_single_trx', ####'a_trade_timeout', ####'trx_rowkey_range_or', ####'update_delete_limit_index', ####'trx_select_for_update', 'idx_const_basic_one_bool', ####'a_trade_xts', ####'create', ####'sfu_norow_one_select_idx', #'many_table_join', ####'index_16_trx_concu_insert', ####'index_41_cover_index_get', 'trx_timeout', #'testlimit_index', 'update_delete_limit_unique_key', ####'idx_unique_insert_replace', ####'index', 'a_trade_notify', 'a_trade_notify_oracle', ####'update_delete_limit_merge_alltype', ####'merge_update', ####'replace_and_insert_ondup', 'information_schema', #'information_schema.desc_in_sys_and_normal_tenant', #'information_schema.show_create_in_sys_and_normal_tenant', #'information_schema.select_in_sys_and_normal_tenant', 'information_schema.information_schema-big', 'information_schema.information_schema_desc', 'inner_table.all_virtual_sys_parameter_stat', ####'inner_table.all_virtual_trans_mgr_stat', 'comment_oracle', 'inner_table.schemata', ####'inner_table.all_virtual_trans_stat', 'inner_table.session_status', ####'inner_table.all_virtual_concurrency_object_pool', ####'inner_table.all_virtual_partition_info', 'inner_table.all_virtual_upgrade_inspection', 'inner_table.session_variables', ####'inner_table.all_virtual_core_inner_table', #'inner_table.all_virtual_partition_sstable_image_info',// TODO(yongle.xh): fix it later #'inner_table.all_virtual_zone_stat', #'inner_table.statistics', ####'inner_table.all_virtual_core_meta_table', ####'inner_table.all_virtual_plan_cache_stat', 'inner_table.character_sets', 'inner_table.table_constraints', 'inner_table.all_virtual_data_type_class', ####'inner_table.all_virtual_plan_stat', 'inner_table.collation_character_set_applicability', 'inner_table.table_privileges', 'inner_table.all_virtual_data_type', ####'inner_table.all_virtual_rebalance_task_stat', 'inner_table.collations', 'inner_table.tables', ####'inner_table.all_virtual_election_info', ####'inner_table.all_virtual_server_stat', ####'inner_table.columns', 'inner_table.tenant_virtual_event_name', ####'inner_table.all_virtual_sql_audit', 'inner_table.global_status', 'inner_table.tenant_virtual_partition_stat', 'inner_table.all_virtual_engine', 'inner_table.global_variables', 'inner_table.tenant_virtual_statname', 'inner_table.all_virtual_interm_result', ####'inner_table.all_virtual_tenant_memstore_info', 'inner_table.user_privileges', ####'inner_table.all_virtual_kvcache_info', ####'inner_table.all_virtual_tenant_stat', 'inner_table.partitions', 'inner_table.views', 'inner_table.dict_and_dictionary_oracle', ####'inner_table.all_virtual_memory_info', ####'inner_table.all_virtual_trans_mem_stat', ####'inner_table.schema_privileges', 'inner_table.agent_virtual_table_oracle', 'inner_table.show_oracle', 'inner_table.objects_oracle', 'inner_table.all_virtual_tenant_partition_meta_table', 'inner_table.all_virtual_pg_partition_info', 'inner_table.all_virtual_pg_partition_info_oracle', 'inner_table.inner_table_overall', 'select.order_by_oracle', 'create_using_type', 'charset.underline_oracle', #'plan_base_line', 'topk', 'dist_nest_loop_simple', 'executor.basic', ####'executor.join_x1', ####'executor.join_x2', 'executor.trx', #'skyline.add_access_path_by_heuristics_mysql', 'skyline.skyline_basic_mysql', 'skyline.skyline_complicate_mysql', 'skyline.skyline_business_mysql', 'skyline.skyline_index_back_mysql', 'skyline.skyline_basic_oracle', #'skyline.skyline_complicate_oracle', #'skyline.skyline_business_oracle', #'skyline.skyline_index_back_oracle', #'executor.join_with_part_ddl', 'trx.trans_consistency_type', 'trx.trans_start_oracle', 'trx.serializable_transaction_oracle', #'trx.trans_idle_timeout', 'trx.ts_source', 'transformer.transformer_add_limit_for_union', #'transformer.transformer_aggregate', #'transformer.transformer_any_all', 'transformer.transformer_outer_join_simplification', #'transformer.transformer_join_eliminate', #'transformer.transformer_or_expansion', 'transformer.transformer_predicate_deduce', #'transformer.transformer_set_op', 'transformer.transformer_simplify', #'transformer.transformer_view_merge', 'transformer.transformer_add_limit_for_union_oracle', #'transformer.transformer_aggregate_oracle', #'transformer.transformer_any_all_oracle', 'transformer.transformer_outer_join_simplification_oracle', #'transformer.transformer_join_eliminate_oracle', #'transformer.transformer_limit_push_down_oracle', #'transformer.transformer_or_expansion_oracle', 'transformer.transformer_predicate_deduce_oracle', #'transformer.transformer_set_op_oracle', #'transformer.transformer_simplify_oracle', 'transformer.transformer_subquery_pullup_oracle', 'transformer.transformer_view_merge_oracle', #'transformer.transformer_win_magic', #'partition.ob_partition_list', 'partition.distributed_dml_oracle', 'global_index.global_index_select', #'groupby.groupby_check_expr_oracle', 'select.escape_oracle', 'replace', #'opt_stat_correctness_validation', 'generated_column', 'window_function.farm', 'window_function.farm_oracle', 'join.anti_semi_join', #'join.anti_semi_join_oracle', 'join.join_merge', #'constraint.base' 'executor.full_join', #'acs_basic', #'create_table.create_table_with_max_used_part_id', 'create_tablegroup_with_tablegroup_id', #'ddl.ctas_partition_farm_mysql', #'ddl.ctas_partition_farm_oracle', 'show_create_tablegroup', #'rownum.rownum_basic_oracle', #'rownum.rownum_complicate_oracle', #'rownum.rownum_partitioned_oracle', 'optimizer.bushy_leading_hint', #'optimizer.cbo', 'optimizer.default_statistic', 'optimizer.equal_set_mysql', #'optimizer.unique_set_mysql', 'optimizer.union_sort_opt', 'optimizer.estimate_cost', 'optimizer.optimizer_bug12484726_mysql', 'optimizer.optimizer_bug12484726_oracle', 'optimizer.optimizer_bug13058938_mysql', 'optimizer.optimizer_bug13058938_oracle', 'optimizer.optimizer_bug15188850_mysql', 'optimizer.optimizer_bug15188850_oracle', 'optimizer.optimizer_bug15439492_mysql', 'optimizer.optimizer_bug15439492_oracle', 'optimizer.optimizer_bug16207306_mysql', 'optimizer.optimizer_bug16207306_oracle', #'optimizer.optimizer_bug16873635_mysql', #'optimizer.optimizer_bug16873635_oracle', 'optimizer.optimizer_bug17500767_mysql', 'optimizer.optimizer_bug17500767_oracle', 'optimizer.optimizer_bug18058771_mysql', 'optimizer.optimizer_bug18135868_mysql', 'optimizer.optimizer_bug18135868_oracle', 'optimizer.optimizer_bug18551931_oracle', 'optimizer.optimizer_bug18595461_mysql', 'optimizer.optimizer_bug18595461_oracle', #'optimizer.optimizer_bug18729881_mysql', 'optimizer.optimizer_bug19634818_mysql', 'optimizer.optimizer_bug21444584_mysql', 'optimizer.optimizer_bug21444584_oracle', 'optimizer.order_null_oracle', #'optimizer.plan_base_line_for_schema', #'optimizer.plan_hash_value', 'subquery.idx_with_const_expr_21_subquery_dilang', 'subquery.optimizer_subquery_bug', 'subquery.order_by_subquery', 'subquery.rqg_ob_subquery_semijoin_nested_sql_parameterization', 'subquery.rqg_subquery_materialization_oop', 'subquery.rqg_subquery_semijoin_mismatch', 'subquery.rqg_subquery_semijoin_nested_timeout', 'subquery.spf_bug13044302', 'subquery.subquery', 'subquery.subquery_sj_firstmatch', 'subquery.subquery_sj_innodb', #'px.add_id_for_sql_audit', 'px.add_material', 'px.agg', 'px.alloc_material_for_producer_consumer_schedule_mode', #'px.broadcast_anti_semi_outer_join', #'px.broadcast', 'px.default_open_px', 'px.default_open_px_oracle', #'px.hash_value_calculate_bug', #'px.join_anti_semi', #'px.join_hash_copy_from_join_test_suite', #'px.join_hash_copy_from_join_test_suite_oracle', 'px.join_hash', 'px.join_mj', 'px.join_nlj', 'px.join_pwj', #'px.mj_early_termination', 'px.parallel_execution_oracle', #'px.px_hint', 'px.sql_audit', 'px.tsc', 'px.union', 'px.unmatched_distribution', 'px.unmatched_distribution_oracle', #'px.add_id_for_sql_audit_oracle', 'px.agg_oracle', 'px.join_hash_oracle', 'px.join_mj_oracle', 'px.join_nlj_oracle', 'px.join_pwj_oracle', 'px.tsc_oracle', 'px.union_oracle', 'px.dml_use_px', 'px.px_table_dop_oracle', 'px_gi_aff_bug_28565554', 'sequence.basic_oracle', 'hierarchical_query.hierarchical_basic_mysql', 'hierarchical_query.hierarchical_without_explain_basic_oracle', 'hierarchical_query.hierarchical_without_explain_ddl_oracle', 'hierarchical_query.hierarchical_without_explain_dml_oracle', 'hierarchical_query.hierarchical_without_explain_pseudo_oracle', 'hierarchical_query.hierarchical_without_explain_odd_oracle', 'hierarchical_query.hierarchical_without_explain_sort_oracle', #'hierarchical_query.hierarchical_without_explain_select_oracle', 'hierarchical_query.hierarchical_without_explain_error_oracle', #'part_mg.basic_partition_mg1', #'part_mg.basic_partition_mg2', #'part_mg.basic_partition_mg3', #'part_mg.basic_partition_mg4', 'foreign_key.dml_147', #'connect_oracle', 'expr.func_without_param_oracle', 'update_column_use_other_oracle', 'func_group_1_oracle', 'bug233498_rename_table_jianming_oracle', 'order_fill_sortbuf_oracle', 'negation_elimination_oracle', 'order_by_sortkey_oracle', 'update_for_oracle', 'trx_for_update_oracle', 'trans_ac_oracle', 'sfu_oracle', 'sfu2_oracle', 'plan_expression_slave_oracle', 'otimestamp.otimestamp_basic_oracle', #'column_item_sensitive_oracle', 'charset.case_sensitive_oracle', 'trx.pg_trans', 'trx.serializable_constrains', 'q_quote_oracle', 'meta_info.meta_build_in_func_test', 'meta_info.meta_func', 'meta_info.meta_func_ceil', 'meta_info.meta_func_floor', 'meta_info.meta_test_func_return_type', 'meta_info.meta_const', #'meta_info.meta_type', 'pdml.update_with_all_features_oracle', 'pdml.pdml_delete_oracle', # 'pdml.pdml_update_part_global_index', # 'pdml.insert_all_feature', #'bigvarchar_1_25M', #'bigvarchar_1_25M_idx', #'type_date.bigvarchar_1_25M_time', 'dblink.select_basic_oracle', #'tenant_parameter_info', 'alter.alter_log_archive_option', 'rowid.ddl_oracle', 'rowid.dml_oracle', 'rowid.expr_oracle', 'rowid.pesudo_column_oracle', 'rowid.index_plan_oracle', 'duplicate_table.test_duplicate_table', 'sql_throttle', #'merge_uncommitted.query_uncommitted_data', #'merge_uncommitted.lock_uncommitted_data', ]