# 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 <https://www.gnu.org/licenses/>.
psmall_test=[
###=== sql engine 3.0 test
'static_engine.table_insert',
'static_engine.hash_set',
'static_engine.merge_set',
'static_engine.hash_distinct',
'static_engine.nested_loop_join',
'static_engine.merge_join',
'static_engine.explicit_cast',
'static_engine.expr_abs',
'static_engine.expr_and_or',
'static_engine.expr_ascii',
'static_engine.expr_bool',
'static_engine.expr_collation',
'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',
'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_insert',
'static_engine.expr_is_serving_tenant',
'static_engine.expr_is',
'static_engine.expr_left',
'static_engine.expr_length',
'static_engine.expr_lnnvl',
'static_engine.expr_location',
'static_engine.expr_lower_upper',
'static_engine.expr_math',
'static_engine.expr_md5',
'static_engine.expr_mid',
'static_engine.expr_neg',
'static_engine.expr_not',
'static_engine.expr_nullif_ifnull',
'static_engine.expr_nvl',
'static_engine.expr_pad',
'static_engine.expr_part_hash',
'static_engine.expr_part_key',
'static_engine.expr_regexp_func',
'static_engine.expr_regexp',
'static_engine.expr_repeat',
'static_engine.expr_replace',
'static_engine.expr_space',
'static_engine.expr_str',
'static_engine.expr_substring_index',
'static_engine.expr_substr',
'static_engine.expr_sys_privilege_check',
'static_engine.expr_time_diff',
'static_engine.expr_timestampadd',
'static_engine.expr_todays',
'static_engine.expr_trim',
'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',
'static_engine.merge_set',
'static_engine.monitoring_dump',
'static_engine.nested_loop_join',
'static_engine.partition_split',
'static_engine.px_basic',
'static_engine.static_engine_case',
'static_engine.static_engine_cmp_null',
'static_engine.static_engine_hash',
'static_engine.subplan_filter',
'static_engine.table_insert',
'static_engine.table_scan',
'static_engine.subplan_scan',
'static_engine.expr_nextval',
'static_engine.expr_unix_timestamp',
'static_engine.expr_char_length',
'static_engine.expr_assign',
'static_engine.expr_get_user_var',
'static_engine.expr_sign',
###=== sql engine 3.0 test end
#####'partition_split',
'execution_partition_pruning_mysql',
'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',
'driver5114_bug',
'chinese',
'distinct',
'type_date.timestamp2',
'ms_lose_rollback',
'column_alias',
'h',
'number.bug229955_positive_int',
'bug233498_rename_table_jianming',
'bug200747',
'alias3',
'expr.expr_ceil',
'expr.func_length',
'replace_null',
'func_group_5',
'explain',
'bool',
'outer_join_where_is_null',
'groupby.group_by_4',
'datatype_java',
'bug5910265_update_orderby_limit_dilang',
'join_basic',
'type_varchar_2',
'sq_from_2',
'compare',
'func_group_6',
'join.nested_loop_join_right_null_joinon_where',
'type_date.add_timestamp_column',
'trx_4',
'safe_null_test',
'null2',
'join.nested_loop_join_right_null_joinon',
'limit',
'alias2',
'join_many_table_single_field',
'non_reserved_keyword',
'update_column_use_other',
'empty_table',
'expr.expr_nseq',
'expr.expr_floor',
'groupby.group_by_2',
'trx_5',
'join_many_table',
'type_date.expr_date_add_sub',
'expr.func_equal',
'truncate_table',
####'select_bug',
'duplicate_key',
'type_date.timefuncnull',
'get',
'join.nested_loop_join_right_null',
'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',
'jp_length_utf8',
'rowkey_update_datatype_convert',
'join_equivalent_transfer',
'update_range',
'ddlrollback',
'bench_count_distinct',
'expr.func_regexp',
'join_using1',
'type_date.updaterowkeymoditime',
'except',
'func_group_1',
'rowkey_is_char',
'type_date.type_create_time',
'delete.delete_range',
'groupby.group_by_basic',
'range',
'select_basic',
'type_date.type_modify_time',
'fin',
'func_group_7',
'expr.expr_instr',
'autocommit',
'connection',
'view',
'bug_different_tranid_intrx',
'createvarchar',
'createsql',
'plan_cache.plan_cache_multi_query',
'plan_cache.neg_sign',
'bug_setEmptyPwd',
'trx_6',
'add',
'minus',
'div',
'expr.mul',
'expr.expr_locate',
'trx_timeout_bug',
'a_trade_quick',
'view_2',
'big_trans_with_mutil_redo',
'idx_unique_many_idx_one_ins',
'two_order_by',
'parallel_insert',
'index_49_alias',
'index_47_NULL',
'index_14_hint',
'idx_const_basic_one_bool',
'trx_timeout',
'update_delete_limit_unique_key',
'a_trade_notify',
'information_schema',
'information_schema.information_schema-big',
'information_schema.information_schema_desc',
'inner_table.all_virtual_sys_parameter_stat',
'inner_table.schemata',
'inner_table.session_status',
'inner_table.all_virtual_upgrade_inspection',
'inner_table.session_variables',
'inner_table.character_sets',
'inner_table.table_constraints',
'inner_table.all_virtual_data_type_class',
'inner_table.collation_character_set_applicability',
'inner_table.table_privileges',
'inner_table.all_virtual_data_type',
'inner_table.collations',
'inner_table.tables',
'inner_table.tenant_virtual_event_name',
'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.user_privileges',
'inner_table.partitions',
'inner_table.views',
'inner_table.all_virtual_tenant_partition_meta_table',
'inner_table.all_virtual_pg_partition_info',
'inner_table.inner_table_overall',
'create_using_type',
'topk',
'dist_nest_loop_simple',
'executor.basic',
'executor.trx',
'skyline.skyline_basic_mysql',
'skyline.skyline_complicate_mysql',
'skyline.skyline_business_mysql',
'skyline.skyline_index_back_mysql',
'trx.trans_consistency_type',
'trx.ts_source',
'transformer.transformer_add_limit_for_union',
'transformer.transformer_outer_join_simplification',
'transformer.transformer_predicate_deduce',
'transformer.transformer_simplify',
'global_index.global_index_select',
'replace',
'generated_column',
'window_function.farm',
'join.anti_semi_join',
'join.join_merge',
'executor.full_join',
'create_tablegroup_with_tablegroup_id',
'show_create_tablegroup',
'optimizer.bushy_leading_hint',
'optimizer.default_statistic',
'optimizer.equal_set_mysql',
'optimizer.union_sort_opt',
'optimizer.estimate_cost',
'optimizer.optimizer_bug12484726_mysql',
'optimizer.optimizer_bug13058938_mysql',
'optimizer.optimizer_bug15188850_mysql',
'optimizer.optimizer_bug15439492_mysql',
'optimizer.optimizer_bug16207306_mysql',
'optimizer.optimizer_bug17500767_mysql',
'optimizer.optimizer_bug18058771_mysql',
'optimizer.optimizer_bug18135868_mysql',
'optimizer.optimizer_bug18595461_mysql',
'optimizer.optimizer_bug19634818_mysql',
'optimizer.optimizer_bug21444584_mysql',
'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_material',
'px.agg',
'px.alloc_material_for_producer_consumer_schedule_mode',
'px.default_open_px',
'px.join_hash',
'px.join_mj',
'px.join_nlj',
'px.join_pwj',
'px.sql_audit',
'px.tsc',
'px.union',
'px.unmatched_distribution',
'px.dml_use_px',
'px_gi_aff_bug_28565554',
'hierarchical_query.hierarchical_basic_mysql',
'foreign_key.dml_147',
'trx.pg_trans',
'trx.serializable_constrains',
'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',

'alter.alter_log_archive_option',
'duplicate_table.test_duplicate_table',
'sql_throttle',
]