mariadb/mysql-test/collections/10.0-compatible.list

# All lines which have a hash sign *anywhere* will be ignored

main.1st
main.adddate_454
main.almost_full
main.alter_table_autoinc-5574
main.alter_table_errors
main.alter_table_mdev539_maria
main.alter_table_mdev539_myisam
main.alter_table_online
main.alter_table_trans
main.analyze
main.analyze_stmt
main.analyze_stmt_orderby
main.analyze_stmt_slow_query_log
main.ansi
main.assign_key_cache
main.auth_rpl
main.auto_increment
main.auto_increment_ranges_innodb
main.auto_increment_ranges_myisam
main.bad_frm_crash_5029
main.bench_count_distinct
main.bigint
main.binary
main.binary_to_hex
main.blackhole
main.blackhole_plugin
main.bool
main.bootstrap
main.bug12427262
main.bug13633383
main.bug46760
main.bug47671
main.bulk_replace
main.case
main.change_user
main.check_constraint_show
main.client_xml
main.comment_column
main.comment_column2
main.comment_index
main.comments
main.comment_table
main.commit_1innodb
main.compare
main.compound
main.contributors
main.count_distinct
main.count_distinct2
main.create_drop_db
main.create_drop_event
main.create_drop_function
main.create_drop_index
main.create_drop_procedure
main.create_drop_server
main.create_drop_trigger
main.create_drop_user
main.create_drop_view
main.create_not_windows
main.create_select_tmp
main.create-uca
main.create_user
main.create_w_max_indexes_64
main.ctype_ascii
main.ctype_big5
main.ctype_binary
main.ctype_collate
main.ctype_cp1250_ch
main.ctype_cp1251
main.ctype_cp850
main.ctype_cp932
main.ctype_cp932_binlog_row
main.ctype_cp932_binlog_stm
main.ctype_create
main.ctype_eucjpms
main.ctype_euckr
main.ctype_filename
main.ctype_filesystem
main.ctype_gb2312
main.ctype_gbk
main.ctype_gbk_binlog
main.ctype_gbk_export_import
main.ctype_hebrew
main.ctype_latin1
main.ctype_latin1_de
main.ctype_latin2
main.ctype_latin2_ch
main.ctype_ldml
main.ctype_many
main.ctype_mb
main.ctype_nopad_8bit
main.ctype_partitions
main.ctype_recoding
main.ctype_sjis
main.ctype_swe7
main.ctype_tis620
main.ctype_uca
main.ctype_uca_innodb
main.ctype_uca_partitions
main.ctype_ucs
main.ctype_ucs2_def
main.ctype_ucs2_query_cache
main.ctype_ucs2_uca
main.ctype_ujis
main.ctype_ujis_ucs2
main.ctype_upgrade
main.ctype_utf16
main.ctype_utf16_def
main.ctype_utf16le
main.ctype_utf16_uca
main.ctype_utf32
main.ctype_utf32_uca
main.ctype_utf8
main.ctype_utf8mb4
main.ctype_utf8mb4_heap
main.ctype_utf8mb4_innodb
main.ctype_utf8mb4_myisam
main.ctype_utf8mb4_uca
main.ctype_utf8_uca
main.date_formats
main.datetime_456
main.default_storage_engine
main.delete
main.delete_returning
main.deprecated_features
main.derived_cond_pushdown
main.derived_opt
main.derived_view
main.distinct
main.drop-no_root
main.dyncol
main.empty_server_name-8224
main.empty_table
main.endspace
main.enforce_storage_engine_opt
main.errors
main.events_2
main.events_logs_tests
main.events_microsec
main.events_restart
main.events_scheduling
main.events_slowlog
main.events_trans
main.execution_constants
main.explain
main.explain_json
main.explain_json_format_partitions
main.explain_json_innodb
main.explain_non_select
main.ext_key_noPK_6794
main.fast_prefix_index_fetch_innodb
main.features
main.filesort_bad_i_s-7585
main.flush2
main.foreign_key
main.frm_bad_row_type-7333
main.fulltext
main.fulltext2
main.fulltext3
main.fulltext_cache
main.fulltext_charsets
main.fulltext_derived_4257
main.fulltext_derived_4316
main.fulltext_distinct
main.fulltext_left_join
main.fulltext_multi
main.fulltext_order_by
main.fulltext_update
main.fulltext_var
main.func_analyse
main.func_concat
main.func_crypt
main.func_date_add
main.func_default
main.func_des_encrypt
main.func_digest
main.func_encrypt
main.func_encrypt_ucs2
main.func_equal
main.func_gconcat
main.func_group_innodb
main.func_hybrid_type
main.func_if
main.func_in
main.func_isnull
main.func_like
main.func_math
main.func_op
main.func_regexp
main.func_regexp_pcre
main.func_rollback
main.func_sapdb
main.func_set
main.func_system
main.func_test
main.func_time
main.func_time_hires
main.func_timestamp
main.function_defaults
main.function_defaults_innodb
main.gcc296
main.get_diagnostics
main.gis
main.gis-alter_table_online
main.gis-precise
main.gis-rt-precise
main.gis-rtree
main.grant_4332
main.greedy_optimizer
main.group_by
main.group_by_innodb
main.group_by_null
main.group_min_max
main.group_min_max_innodb
main.handler_read_last
main.handlersocket
main.having
main.help
main.host_cache_size_functionality
main.huge_frm-6224
main.implicit_char_to_num_conversion
main.implicit_commit
main.in_datetime_241
main.index_intersect
main.index_intersect_innodb
main.index_merge_innodb
main.index_merge_myisam
main.information_schema2
main.information_schema_all_engines
main.information_schema_chmod
main.information_schema_inno
main.information_schema_parameters
main.information_schema_part
main.information_schema_routines
main.information_schema_stats
main.init_file
main.init_file_longline_3816
main.init_file_set_password-7656
main.innodb_bug878769
main.innodb_ext_key
main.innodb_group
main.innodb_icp
main.innodb_ignore_builtin
main.innodb_mrr_cpk
main.innodb_utf8
main.insert
main.insert_innodb
main.insert_select
main.insert_update
main.insert_update_autoinc-7150
main.join
main.join_cache
main.join_crash
main.join_nested
main.join_nested_jcl6
main.join_optimizer
main.join_outer
main.join_outer_innodb
main.join_outer_jcl6
main.key
main.key_cache
main.key_diff
main.key_primary
main.keyread
main.keywords
main.last_value
main.limit
main.limit_rows_examined
main.loaddata_autocom_innodb
main.locale
main.log_errchk
main.log_slow
main.log_state_bug33693
main.log_tables_upgrade
main.long_tmpdir
main.lowercase_mixed_tmpdir
main.lowercase_table
main.lowercase_table5
main.lowercase_table_grant
main.lowercase_table_qcache
main.lowercase_utf8
main.lowercase_view
main.mdev13607
main.mdev_14586
main.mdev316
main.mdl
main.merge_innodb
main.merge_mmap
main.metadata
main.mix2_myisam_ucs2
main.mrr_derived_crash_4610
main.mrr_icp_extra
main.multi_statement
main.multi_update2
main.multi_update_innodb
main.multi_update_tiny_hash
main.myisam-blob
main.myisam_enable_keys-10506
main.myisam_explain_non_select_all
main.myisam_icp
main.myisam_mrr
main.myisampack
main.myisam-system
main.mysql
main.mysql5613mysql
main.mysql57_virtual
main.mysqladmin
main.mysql_binary_mode
main.mysqlcheck
main.mysql_comments
main.mysql_cp932
main.mysqld--defaults-file
main.mysqld--help
main.mysqld_help_crash-9183
main.mysqld_option_err
main.mysqldump-compat
main.mysqldump-nl
main.mysqldump-no-binlog
main.mysqldump_restore
main.mysql_not_windows
main.mysql_protocols
main.mysqlshow
main.mysqlslap
main.mysqltest_256
main.mysqltest_cont_on_error
main.mysql_tzinfo_to_sql_symlink
main.mysql_upgrade_noengine
main.mysql_upgrade_no_innodb
main.mysql_upgrade_ssl
main.mysql_upgrade_view
main.negation_elimination
main.no_binlog
main.no_password_column-mdev-11170
main.null
main.null_key
main.odbc
main.olap
main.old-mode
main.order_by
main.order_by_innodb
main.order_by-mdev-10122
main.order_by_optimizer
main.order_by_optimizer_innodb
main.order_by_sortkey
main.order_by_zerolength-4285
main.order_fill_sortbuf
main.outfile_loaddata
main.parser
main.parser_bug21114_innodb
main.parser_precedence
main.parser_stack
main.partition
main.partition_binlog
main.partition_binlog_stmt
main.partition_blackhole
main.partition_bug18198
main.partition_cache_innodb
main.partition_cache_myisam
main.partition_charset
main.partition_column
main.partition_column_prune
main.partition_datatype
main.partition_disabled
main.partition_error
main.partition_example
main.partition_exchange
main.partition_explicit_prune
main.partition_hash
main.partition_key_cache
main.partition_list
main.partition_mgm
main.partition_mgm_err
main.partition_mgm_err2
main.partition_myisam
main.partition_not_blackhole
main.partition_not_windows
main.partition_order
main.partition_pruning
main.partition_range
main.partition_rename_longfilename
main.partition_truncate
main.partition_utf8
main.perror
main.plugin
main.plugin_auth_qa
main.plugin_auth_qa_2
main.plugin_auth_qa_3
main.plugin_innodb
main.plugin_load
main.plugin_loaderr
main.plugin_load_option
main.plugin_maturity
main.preload
main.profiling
main.progress_976225
main.ps_10nestset
main.ps_11bugs
main.ps_1general
main.ps_2myisam
main.ps_3innodb
main.ps_4heap
main.ps_5merge
main.ps_change_master
main.ps_ddl1
main.ps_max_subselect-5113
main.ps_not_windows
main.query_cache
main.query_cache_innodb
main.query_cache_merge
main.query_cache_with_views
main.range
main.range_innodb
main.range_mrr_icp
main.range_vs_index_merge
main.range_vs_index_merge_innodb
main.renamedb
main.reopen_temp_table
main.repair
main.repair_symlink-5543
main.replace
main.rollback
main.round
main.row
main.row-checksum
main.row-checksum-old
main.rowid_order_innodb
main.rpl_mysqldump_slave
main.second_frac-9175
main.select
main.select_found
main.selectivity
main.selectivity_innodb
main.selectivity_no_engine
main.select_jcl6
main.select_pkeycache
main.select_safe
main.servers
main.set_password
main.set_statement_notembedded
main.set_statement_notembedded_binlog
main.show
main.show_bad_definer-5553
main.show_create_user
main.show_function_with_pad_char_to_full_length
main.show_profile
main.show_row_order-9226
main.sighup-6580
main.signal
main.signal_demo1
main.signal_demo2
main.signal_demo3
main.signal_sqlmode
main.single_delete_update
main.single_delete_update_innodb
main.skip_grants
main.skip_log_bin
main.sp-big
main.sp-bugs
main.sp-bugs2
main.sp-destruct
main.sp-dynamic
main.sp-error
main.sp-fib
main.sp_gis
main.sp-group
main.sp_missing_4665
main.sp-no-code
main.sp-prelocking
main.sp_stress_case
main.sp_trans
main.sp_trans_log
main.sp-ucs2
main.sp-vars
main.ssl_7937
main.ssl_8k_key
main.ssl_and_innodb
main.ssl_ca
main.ssl_cert_verify
main.ssl_connect
main.ssl_crl_clients
main.stack-crash
main.statistics
main.statistics_index_crash-7362
main.stat_tables
main.stat_tables_disabled
main.stat_tables_innodb
main.stat_tables_partition
main.stat_tables_repl
main.strict
main.strict_autoinc_1myisam
main.strict_autoinc_2innodb
main.strict_autoinc_3heap
main.str_to_datetime_457
main.subselect2
main.subselect3
main.subselect3_jcl6
main.subselect4
main.subselect_cache
main.subselect-crash_15755
main.subselect_exists2in
main.subselect_exists2in_costmat
main.subselect_extra
# Disabled due to connect log output
# main.subselect_extra_no_semijoin
main.subselect_gis
main.subselect_innodb
main.subselect_mat
main.subselect_mat_cost
main.subselect_mat_cost_bugs
main.subselect_notembedded
main.subselect_nulls
main.subselect_partial_match
main.subselect_sj2
main.subselect_sj2_jcl6
main.subselect_sj2_mat
main.subselect_sj_aria
main.subselect_sj_mat
main.subselect_sj_nonmerged
main.sum_distinct
main.sysdate_is_now
main.system_mysql_db
main.system_mysql_db_refs
main.table_elim
main.table_elim_debug
main.table_keyinfo-6838
main.tablelock
main.table_options
main.table_options-5867
main.temporal_literal
main.temporal_scale_4283
main.temp_table_frm
main.timezone
main.timezone2
main.timezone3
main.timezone4
main.tmp_table_count-7586
main.trigger_no_defaults-11698
main.trigger_null-8605
main.truncate
main.truncate_badse
main.truncate-stale-6500
main.type_binary
main.type_bit
main.type_bit_innodb
main.type_blob
main.type_datetime_hires
main.type_decimal
main.type_enum
main.type_float
main.type_int
main.type_nchar
main.type_newdecimal
main.type_num
main.type_num_innodb
main.type_ranges
main.type_set
main.type_temporal_innodb
main.type_temporal_mysql56
main.type_time
main.type_time_6065
main.type_time_hires
main.type_timestamp_hires
main.type_uint
main.type_varchar
main.type_year
main.update_ignore_216
main.update_innodb
main.upgrade
main.user_var
main.varbinary
main.variables_community
main.view_alias
main.warnings_engine_disabled
main.win_avg
main.win_big
main.win_big-mdev-10092
main.win_big-mdev-11697
main.win_bit
main.win_empty_over
main.win_first_last_value
main.win_insert_select
main.win_i_s
# Disabled due to unknown SQL error name
# main.win_lead_lag
main.win_min_max
main.win_nth_value
main.win_orderby
main.win_percent_cume
main.win_rank
main.win_sum
main.xa_binlog
main.xml
main.xtradb_mrr