MariaDB-server/mysql-test/include
Monty c419413ec4 MDEV-25292 Atomic CREATE OR REPLACE TABLE
Atomic CREATE OR REPLACE allows to keep an old table intact if the
command fails or during the crash. That is done by renaming the
original table to temporary name, as a backup and restoring it if the
CREATE fails. When the command is complete and logged the backup
table is deleted.

Atomic replace algorithm

  Two DDL chains are used for CREATE OR REPLACE:
  ddl_log_state_create (C) and ddl_log_state_rm (D).

  1. (C) Log rename of ORIG to TMP table (Rename TMP to original).
  2. Rename orignal to TMP.
  3. (C) Log CREATE_TABLE_ACTION of ORIG (drops ORIG);
  4. Do everything with ORIG (like insert data)
  5. (D) Log drop of TMP
  6. Write query to binlog (this marks (C) to be closed in
     case of failure)
  7. Execute drop of TMP through (D)
  8. Close (C) and (D)

  If there is a failure before 6) we revert the changes in (C)
  Chain (D) is only executed if 6) succeded (C is closed on
  crash recovery).

Foreign key errors will be found at the 1) stage.

Additional notes

  - CREATE TABLE without REPLACE and temporary tables is not affected
    by this commit.
    set @@drop_before_create_or_replace=1 can be used to
    get old behaviour where existing tables are dropped
    in CREATE OR REPLACE.

  - CREATE TABLE is reverted if binlogging the query fails.

  - Engines having HTON_EXPENSIVE_RENAME flag set are not affected by
    this commit. Conflicting tables marked with this flag will be
    deleted with CREATE OR REPLACE.

  - Replication execution is not affected by this commit.
    - Replication will first drop the conflicting table and then
      creating the new one.

  - CREATE TABLE .. SELECT XID usage is fixed and now there is no need
    to log DROP TABLE via DDL_CREATE_TABLE_PHASE_LOG (see comments in
    do_postlock()). XID is now correctly updated so it disables
    DDL_LOG_DROP_TABLE_ACTION. Note that binary log is flushed at the
    final stage when the table is ready. So if we have XID in the
    binary log we don't need to drop the table.

  - Three variations of CREATE OR REPLACE handled:

    1. CREATE OR REPLACE TABLE t1 (..);
    2. CREATE OR REPLACE TABLE t1 LIKE t2;
    3. CREATE OR REPLACE TABLE t1 SELECT ..;

  - Test case uses 6 combinations for engines (aria, aria_notrans,
    myisam, ib, lock_tables, expensive_rename) and 2 combinations for
    binlog types (row, stmt). Combinations help to check differences
    between the results. Error failures are tested for the above three
    variations.

  - expensive_rename tests CREATE OR REPLACE without atomic
    replace. The effect should be the same as with the old behaviour
    before this commit.

  - Triggers mechanism is unaffected by this change. This is tested in
    create_replace.test.

  - LOCK TABLES is affected. Lock restoration must be done after new
    table is created or TMP is renamed back to ORIG

  - Moved ddl_log_complete() from send_eof() to finalize_ddl(). This
    checkpoint was not executed before for normal CREATE TABLE but is
    executed now.

  - CREATE TABLE will now rollback also if writing to the binary
    logging failed. See rpl_gtid_strict.test

backup ddl log changes

- In case of a successfull CREATE OR REPLACE we only log
  the CREATE event, not the DROP TABLE event of the old table.

ddl_log.cc changes

  ddl_log_execute_action() now properly return error conditions.
  ddl_log_disable_entry() added to allow one to disable one entry.
  The entry on disk is still reserved until ddl_log_complete() is
  executed.

On XID usage

  Like with all other atomic DDL operations XID is used to avoid
  inconsistency between master and slave in the case of a crash after
  binary log is written and before ddl_log_state_create is closed. On
  recovery XIDs are taken from binary log and corresponding DDL log
  events get disabled.  That is done by
  ddl_log_close_binlogged_events().

On linking two chains together

  Chains are executed in the ascending order of entry_pos of execute
  entries. But entry_pos assignment order is undefined: it may assign
  bigger number for the first chain and then smaller number for the
  second chain. So the execution order in that case will be reverse:
  second chain will be executed first.

  To avoid that we link one chain to another. While the base chain
  (ddl_log_state_create) is active the secondary chain
  (ddl_log_state_rm) is not executed. That is: only one chain can be
  executed in two linked chains.

  The interface ddl_log_link_chains() was defined in "MDEV-22166
  ddl_log_write_execute_entry() extension".

Atomic info parameters in HA_CREATE_INFO

  Many functions in CREATE TABLE pass the same parameters. These
  parameters are part of table creation info and should be in
  HA_CREATE_INFO (or whatever). Passing parameters via single
  structure is much easier for adding new data and
  refactoring.

InnoDB changes
  Added ha_innobase::can_be_renamed_to_backup() to check if
  a table with foreign keys can be renamed.

Aria changes:
- Fixed issue in Aria engine with CREATE + locked tables
  that data was not properly commited in some cases in
  case of crashes.

Other changes:
- Removed some auto variables in log.cc for better code readability.
- Fixed old bug that CREATE ... SELECT would not be able to auto repair
  a table that is part of the SELECT.
- Marked MyISAM that it does not support ROLLBACK (not required but
  done for better consistency with other engines).

Known issues:
- InnoDB tables with foreign key definitions are not fully supported
  with atomic create and replace:
  - ha_innobase::can_be_renamed_to_backup() can detect some cases
    where InnoDB does not support renaming table with foreign key
    constraints.  In this case MariaDB will drop the old table before
    creating the new one.
    The detected cases are:
    - The new and old table is using the same foreign key constraint
      name.
    - The old table has self referencing constraints.
  - If the old and new table uses the same name for a constraint the
    create of the new table will fail. The orignal table will be
    restored in this case.
  - The above issues will be fixed in a future commit.
- CREATE OR REPLACE TEMPORARY table is not full atomic. Any conflicting
  table will always be dropped before creating a new one. (Old behaviour).

Bug fixes related to this MDEV:

MDEV-36435 Assertion failure in finalize_locked_tables()
MDEV-36439 Assertion `thd_arg->lex->sql_command != SQLCOM_CREATE_SEQUENCE...
MDEV-36498 Failed CoR in non-atomic mode no longer generates DROP in RBR...
MDEV-36508 Temporary files #sql-create-....frm occasionally stay after
           crash recovery

Reverted commits:
MDEV-36685 "CREATE-SELECT may lose in binlog side-effects of
stored-routine" as it did not take into account that it safe to clear
binlogs if the created table is non transactional and there are no
other non transactional tables used.
- This was done because it caused extra logging when it is not needed
  (not using any non transactional tables) and it also did not solve
  side effects when using statement based loggging.
2025-12-27 14:31:51 +02:00
..
add_anonymous_users.inc
alter_table_mdev539.inc
analyze-format.inc Merge branch '10.11' into 11.1 2024-08-03 09:32:42 +02:00
analyze-no-filtered.inc MDEV-30032: EXPLAIN FORMAT=JSON output: print costs 2023-02-03 11:01:24 +03:00
analyze-sync_with_master.test
analyze-timeout.test
aria_log_control_load.inc MDEV-32932 Port backup features from ES 2024-02-27 20:55:54 +02:00
assert_grep.inc
assert.inc
autoinc_mdev15353.inc
begin_include_file.inc
big_test.inc
big_test.require
binlog_combinations.combinations tests: move around, add new 2023-08-15 10:16:11 +02:00
binlog_combinations.inc tests: move around, add new 2023-08-15 10:16:11 +02:00
binlog_format_combinations.combinations binlog_combinations.inc -> binlog_format_combinations.inc 2023-08-15 10:16:11 +02:00
binlog_format_combinations.inc binlog_combinations.inc -> binlog_format_combinations.inc 2023-08-15 10:16:11 +02:00
binlog_inject_error.inc MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-12-27 14:31:51 +02:00
binlog_parallel_replication_marks.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_start_pos.inc
bool_to_char.inc MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-04-19 10:59:58 +04:00
boolean_factor.inc MDEV-34189 Unexpected error on WHERE inet6col 2025-01-29 09:08:19 +04:00
bug38347.inc
bytes2.inc
bytes.inc
case_insensitive_file_system.require
case_insensitive_fs.require
case_sensitive_file_system.require
check_concurrent_insert.inc
check_digest_end.inc check_digest() tests 2023-12-07 14:27:42 +03:00
check_digest.inc check_digest() tests 2023-12-07 14:27:42 +03:00
check_events_off.inc
check_ftwrl_compatible.inc
check_ftwrl_incompatible.inc
check_ipv6.inc
check_key_reads.inc MDEV-33145 Add FLUSH GLOBAL STATUS 2024-05-27 12:39:03 +02:00
check_key_req.inc
check_no_concurrent_insert.inc
check_no_row_lock.inc
check_qep.inc Merge branch '10.9' into 10.10 2023-08-05 20:34:09 +02:00
check_shared_row_lock.inc
check_slave_is_running.inc
check_slave_no_error.inc
check_slave_param.inc
check_utf8_cli.inc
check_var_limit.inc
check_var_limit.require
check_windows_admin.inc
check-testcase.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
check-warnings.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
cleanup_fake_relay_log.inc
column_compression_rpl.inc Merge branch '10.4' into 10.5 2023-07-27 15:43:21 +02:00
column_compression_syntax_varbinary.inc remove deprecated since 10.4 2024-02-17 17:10:25 +01:00
column_compression_syntax_varchar.inc remove deprecated since 10.4 2024-02-17 17:10:25 +01:00
commit.inc MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
common-tests.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
concurrent.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
connect2.inc
count_sessions.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
crash_mysqld.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
ctype_8bit.inc
ctype_ascii_order.inc
ctype_casefolding_supplementary.inc MDEV-30577 Case folding for uca1400 collations is not up to date 2023-04-18 11:31:05 +04:00
ctype_casefolding.inc MDEV-30577 Case folding for uca1400 collations is not up to date 2023-04-18 11:31:05 +04:00
ctype_common.inc Merge branch 'bb-10.4-all-builders' into bb-10.5-all-builders 2022-09-26 10:24:59 +07:00
ctype_czech.inc
ctype_datetime.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
ctype_E05C.inc fix string literal escaping in views 2023-06-02 17:51:40 +02:00
ctype_filesort2.inc
ctype_filesort.inc
ctype_german.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
ctype_heap.inc
ctype_ident_sys.inc
ctype_innodb_like.inc
ctype_like_cond_propagation_utf8_german.inc
ctype_like_cond_propagation.inc
ctype_like_escape.inc
ctype_like_ignorable.inc
ctype_like_range_f1f2.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
ctype_like_range_mdev14350.inc
ctype_like.inc
ctype_mdev13118.inc
ctype_myanmar.inc Removing MDEV-27871 from tastcases because it is not a bug 2024-06-28 16:45:50 +07:00
ctype_nopad_prefix_unique.inc remove features that were deprecated in 10.5 2025-04-29 16:53:02 +02:00
ctype_numconv.inc Merge 10.11 into 11.2 2024-10-03 13:24:43 +03:00
ctype_pad_all_engines.inc
ctype_pad_space.inc
ctype_pad.inc Removing MDEV-27871 from tastcases because it is not a bug 2024-06-28 16:45:50 +07:00
ctype_regex_utf8.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
ctype_regex.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
ctype_special_chars.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
ctype_str_to_date.inc Removing MDEV-27871 from tastcases because it is not a bug 2024-06-28 16:45:50 +07:00
ctype_strtoll10.inc
ctype_supplementary_chars.inc MDEV-29968 Functions in default values in tables with some character sets break SHOW CREATE (and mysqldump) 2025-01-17 15:39:55 +04:00
ctype_thai.inc
ctype_uca1400_ids_using_convert.inc MDEV-27009 Add UCA-14.0.0 collations 2022-08-10 15:04:24 +02:00
ctype_uca1400_ids_using_set_names.inc MDEV-27009 Add UCA-14.0.0 collations 2022-08-10 15:04:24 +02:00
ctype_uca_w2.inc
ctype_unescape.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
ctype_unicode520.inc
ctype_unicode_allchars.inc
ctype_unicode_casefold_bmp.inc MDEV-33696 main.dyncol and ctype_unicode_casefold_bmp.inc in --view 2024-05-27 11:55:32 +04:00
ctype_unicode_casefold_supplementary.inc MDEV-30716 Wrong casefolding in xxx_unicode_520_ci for U+0700..U+07FF 2023-02-23 23:40:45 +04:00
ctype_unicode_latin.inc
ctype_unicode_ws_bmp.inc Merge branch '10.6' into 10.9 2023-08-04 08:01:06 +02:00
ctype_unicode_ws_supplementary.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
ctype_utf8_ilseq.inc
ctype_utf8_table.inc
ctype_utf8mb3_uca_char.inc remove features that were deprecated in 10.5 2025-04-29 16:53:02 +02:00
ctype_utf8mb4.inc Merge remote-tracking branch 'origin/11.4' into 11.5 2024-07-10 12:17:09 +04:00
daemon_example_bad_format.ini
daemon_example_bad_soname.ini
dbms_output.inc MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-04-19 10:59:58 +04:00
dbt3_s001.inc
ddl_i18n.check_events.inc
ddl_i18n.check_sp.inc
ddl_i18n.check_triggers.inc
ddl_i18n.check_views.inc
deadlock.inc MDEV-26642/MDEV-26643/MDEV-32898 Implement innodb_snapshot_isolation 2024-03-20 09:48:03 +02:00
default_charset.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
default_client.cnf MDEV-31857 enable --ssl-verify-server-cert by default 2024-02-04 22:19:15 +01:00
default_group_order.cnf
default_my.cnf test.cnf files should !include default_my.cnf 2024-02-03 11:22:20 +01:00
default_mysqld.cnf Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
default_optimizer_switch.inc MDEV-34888 Implement SEMIJOIN() and SUBQUERY() hints 2025-05-05 12:02:47 +07:00
delete_anonymous_users.inc MDEV-26875: Wrong user in SET DEFAULT ROLE error 2023-10-30 18:39:56 +01:00
delete_use_source_cases_memory.inc update results for ps2 mode 2023-08-17 17:20:44 +02:00
delete_use_source_cases_non_innodb.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
delete_use_source_cases.inc update results for ps2 mode 2023-08-17 17:20:44 +02:00
delete_use_source_innodb.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
delete_use_source_memory.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
delete_use_source.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
diff_servers.inc
diff_tables.inc cleanup: select ... into tests 2025-02-11 20:31:25 +01:00
empty_string_literal.inc Removing MDEV-27871 from tastcases because it is not a bug 2024-06-28 16:45:50 +07:00
end_include_file.inc
endspace.inc
ensure_binlog_row_event_columns.inc MDEV-28487: sequences not respect value of binlog_row_image with select nextval(seq_gen) 2022-07-13 09:03:32 -06:00
equal_fields_propagation_datetime.inc
execute_with_statistics.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
expect_crash.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
expect_qep.inc Merge branch '10.9' into 10.10 2023-08-05 20:34:09 +02:00
explain_non_select.inc Merge branch '10.11' into 11.0 2023-12-19 15:53:18 +01:00
explain_utils.inc Merge 10.5 into 10.6 2024-10-03 09:31:39 +03:00
explain-no-costs-filtered.inc MDEV-30032: EXPLAIN FORMAT=JSON output: print costs 2023-02-03 11:01:24 +03:00
explain-no-costs.inc MDEV-30032: EXPLAIN FORMAT=JSON output: print costs 2023-02-03 11:01:24 +03:00
fetch_one_value.inc MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-04-19 10:59:58 +04:00
file_does_not_exist.inc
filter_file.inc
force_restart.inc
func_hybrid_type.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
func_str_ascii_checksum.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
function_defaults_notembedded.inc
function_defaults.inc cleanup: select ... into tests 2025-02-11 20:31:25 +01:00
galera_clear_sync_point.inc
galera_cluster.inc sporadic failures of galera.galera_sst_mariabackup 2024-05-12 14:56:45 +02:00
galera_connect.inc
galera_diff.inc
galera_end.inc
galera_have_debug_sync.inc
galera_init.inc
galera_no_debug_sync.inc
galera_set_sync_point.inc
galera_signal_sync_point.inc
galera_sst_method.combinations MDEV-31905 GTID inconsistency 2023-12-22 00:10:23 +01:00
galera_sst_method.inc MDEV-31905 GTID inconsistency 2023-12-22 00:10:23 +01:00
galera_suspend.inc
galera_variables_ok_debug.inc galera tests: more informative messages about the number of variables 2025-01-27 19:05:26 +01:00
galera_variables_ok.inc Merge branch '10.11 into 11.4 2025-01-30 12:01:11 +01:00
galera_wait_ready.inc
galera_wait_sync_point.inc
gap_lock_error_all.inc
gap_lock_error_cleanup.inc
gap_lock_error_init.inc
gap_lock_error_select.inc
gap_lock_error_update.inc
get_relay_log_pos.inc
gis_debug.inc Removing MDEV-27871 from tastcases because it is not a bug 2024-06-28 16:45:50 +07:00
gis_generic.inc Merge branch '10.6' into 10.11 2024-07-22 15:14:50 +02:00
gis_keys.inc
grant_cache.inc Merge 10.6 into 10.11 2024-10-03 10:55:08 +03:00
grep.inc MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range 2024-05-27 12:39:02 +02:00
have_32bit_timestamp.inc MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range 2024-05-27 12:39:02 +02:00
have_32bit.inc
have_64bit_timestamp.inc MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range 2024-05-27 12:39:02 +02:00
have_64bit.inc
have_archive.inc
have_archive.opt
have_aria_used_for_temp_tables.inc
have_aria.inc
have_auth_named_pipe.inc
have_big5.inc
have_binlog_checksum_off.inc
have_binlog_format_mixed_or_row.inc
have_binlog_format_mixed_or_statement.inc
have_binlog_format_mixed.inc
have_binlog_format_mixed.opt
have_binlog_format_row_or_statement.combinations MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-12-27 14:31:51 +02:00
have_binlog_format_row_or_statement.inc MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-12-27 14:31:51 +02:00
have_binlog_format_row.inc
have_binlog_format_row.opt
have_binlog_format_statement.inc
have_binlog_format_statement.opt
have_blackhole.inc
have_blackhole.opt
have_case_insensitive_file_system.inc
have_case_insensitive_fs.inc
have_case_sensitive_file_system.inc
have_cet_timezone.require MDEV-35088 main.timezone failing - MEST vs CET time zone difference 2024-11-13 17:39:47 +11:00
have_cgroupv2.inc MDEV-34753 memory pressure - erroneous termination condition 2024-10-19 17:20:27 +11:00
have_collation.inc
have_compress.inc
have_compress.require
have_cp866.inc
have_cp932.inc
have_cp1250_ch.inc
have_cp1251.inc
have_crypt.inc MDEV-27964: tests - enable msan tests on have_crypt.inc 2025-06-16 12:00:45 +10:00
have_csv.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
have_dbi_dbd-mariadb.inc
have_debug_sync.inc
have_debug.inc
have_des.inc
have_eucjpms.inc
have_euckr.inc
have_example_plugin.inc
have_file_key_management.inc Enable valgrind for replication test 2022-11-29 03:34:35 +02:00
have_gb2312.inc
have_gbk.inc
have_geometry.inc
have_geometry.require
have_gzip.inc MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY 2022-12-27 00:02:02 +03:00
have_hostname_cache.inc
have_innodb_4k.inc
have_innodb_4k.opt MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
have_innodb_8k.inc
have_innodb_8k.opt MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
have_innodb_16k.inc
have_innodb_16k.opt MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
have_innodb_32k.inc
have_innodb_32k.opt MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
have_innodb_64k.inc
have_innodb_64k.opt MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
have_innodb_max_16k.inc
have_innodb.inc MDEV-23974 fixup: Cover all debug builds 2024-04-25 07:48:57 +03:00
have_innodb.opt mtr: remove innodb combinations 2024-05-05 21:37:08 +02:00
have_ipv4_mapped.inc
have_koi8r.inc
have_latin2_ch.inc
have_local_infile.inc
have_local_infile.require
have_log_bin-master.opt
have_log_bin-slave.opt
have_log_bin.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
have_lowercase0.inc
have_lowercase1.inc
have_lowercase2.inc
have_maria.inc
have_mariabackup.inc
have_max_indexes_64.inc
have_max_indexes_128.inc
have_metadata_lock_info.inc
have_metadata_lock_info.opt
have_moscow_leap_timezone.require
have_mutex_deadlock_detector.inc
have_normal_zlib.inc Fix test failures on s390x in test following main.column_compression_rpl 2024-01-12 17:22:08 +01:00
have_numa.inc
have_openssl.inc
have_partition.inc
have_partition.opt
have_perfschema.inc
have_perror.require
have_plugin_auth.inc
have_plugin_auth.opt
have_plugin_interface.inc
have_plugin_server.inc
have_pool_of_threads.inc
have_pool_of_threads.require
have_profiling.inc
have_profiling.require
have_query_cache_disabled.inc Merge branch 'merge-perfschema-5.7' into 10.5 2022-08-02 09:34:15 +02:00
have_query_cache.inc
have_query_cache.require
have_rocksdb.inc MDEV-35748 : Attempting to create a CONNECT engine Table results in non-InnoDB sequences in Galera cluster error 2025-02-01 16:53:39 +01:00
have_rocksdb.opt mtr: use plugin-load-add in have_rocksdb.opt 2025-04-18 09:41:23 +02:00
have_s3.inc
have_sequence.inc
have_sequence.opt
have_simple_parser.inc
have_sjis.inc
have_ssl_communication.inc
have_ssl_crypto_functs.inc
have_stat_tables.inc
have_stat_tables.opt
have_static_innodb.inc
have_symlink.inc
have_symlink.require
have_tis620.inc
have_tlsv13.inc ssl_cipher parameter cannot configure TLSv1.3 and TLSv1.2 ciphers at the same time 2024-09-26 11:50:20 +02:00
have_type_mysql_json.inc
have_type_mysql_json.opt
have_ucs2.inc
have_udf.inc
have_ujis.inc
have_unix_socket.inc
have_unix_socket.opt
have_utf8.inc
have_utf8mb4.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
have_utf16.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
have_utf32.inc MDEV-25829 Change default Unicode collation to uca1400_ai_ci 2024-05-24 15:50:05 +04:00
have_view_protocol.inc
have_working_dns.inc
have_working_dns.require
have_wsrep_enabled.inc sporadic failures of galera.galera_sst_mariabackup 2024-05-12 14:56:45 +02:00
have_wsrep_provider.inc
have_wsrep.inc
have_xtrabackup.inc
histogram_replaces.inc
icp_debug_kill.inc
icp_tests.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
implicit_commit_helper.inc
index_merge1.inc Merge branch '10.11' into 11.1 2024-07-08 22:40:16 +02:00
index_merge2.inc
index_merge_2sweeps.inc
index_merge_ror_cpk.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
index_merge_ror.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
innodb_checksum_algorithm.combinations
innodb_checksum_algorithm.inc
innodb_encrypt_log.combinations
innodb_encrypt_log.inc
innodb_encrypt_tables.combinations
innodb_encrypt_tables.inc
innodb_page_size_small.combinations
innodb_page_size_small.inc
innodb_page_size.combinations
innodb_page_size.inc
innodb_prefix_index_cluster_optimization.combinations
innodb_prefix_index_cluster_optimization.inc
innodb_rollback_on_timeout.inc MDEV-24035 Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0 causing disruption and replication failure 2024-12-12 18:02:00 +02:00
innodb_row_format.combinations
innodb_row_format.inc
innodb_stable_estimates.inc MDEV-32901: innodb.mdev-14846 fails in 11.0 2023-12-05 19:26:30 +03:00
innodb_stable_estimates.opt MDEV-32901: innodb.mdev-14846 fails in 11.0 2023-12-05 19:26:30 +03:00
innodb_trx_weight.inc
innodb_undo_tablespaces.combinations
innodb_undo_tablespaces.inc
innodb-index.inc
install_plugin_if_exists.inc
io_thd_fault_injection.inc
ipv6_clients.inc
ipv6.inc MDEV-27682: bundled wsrep_notify.sh causes mariadbd to freeze during start 2022-10-04 13:16:17 +02:00
is_embedded_no_privileges.inc
is_embedded.inc
json_hb_histogram.inc
keyword_non_reserved.inc MDEV-35229 NOCOPY has become reserved word bringing wide incompatibility 2024-10-30 13:58:20 +04:00
kill_and_restart_mysqld.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
kill_binlog_dump_threads.inc
kill_galera.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
kill_mysqld.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
kill_query_and_diff_master_slave.inc
kill_query.inc
last_query_cost.inc Update row and key fetch cost models to take into account data copy costs 2023-02-02 21:43:30 +03:00
lcase_names.combinations
lcase_names.inc
libdaemon_example.ini
linux_sys_vars.inc
linux.inc "un-skip" more skipped tests 2023-09-11 11:23:26 +02:00
load_dump_and_upgrade.inc MDEV-30498 Rename mysql_upgrade state file to mariadb_upgrade 2023-02-07 07:29:04 +00:00
load_sysvars.inc
log_bin.combinations MDEV-34269 : 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning 2024-06-07 18:26:08 +02:00
log_bin.inc MDEV-34269 : 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning 2024-06-07 18:26:08 +02:00
log_grep.inc MDEV-9101 Limit size of created disk temporary files and tables 2024-05-27 12:39:04 +02:00
log_slow_cleanup.inc MDEV-31558 Add InnoDB engine information to the slow query log 2023-07-07 12:53:18 +03:00
log_slow_debug_common.inc
log_slow_grep.inc MDEV-34190: r_engine_stats.pages_read_count is unrealistically low 2024-07-04 15:24:49 +03:00
log_slow_prepare.inc MDEV-31558 Add InnoDB engine information to the slow query log 2023-07-07 12:53:18 +03:00
log_slow_start.inc MDEV-31558 Add InnoDB engine information to the slow query log 2023-07-07 12:53:18 +03:00
log_slow_stop.inc MDEV-31558 Add InnoDB engine information to the slow query log 2023-07-07 12:53:18 +03:00
long_test.inc Add --source include/long_test.inc to some tests 2025-03-15 11:15:54 +01:00
lowercase0.require
lowercase1.require
lowercase2.require
maria_empty_logs.inc Merge 10.5 into 10.6 2023-10-19 13:50:00 +03:00
maria_make_snapshot_for_comparison.inc
maria_make_snapshot_for_feeding_recovery.inc
maria_make_snapshot.inc
maria_verify_recovery.inc
master-slave.inc MDEV-30423 Deadlock on Replica during BACKUP STAGE BLOCK_COMMIT on XA transactions 2023-01-23 19:01:48 +02:00
max_indexes.inc
maybe_debug.combinations
maybe_debug.inc
maybe_pool_of_threads.combinations
maybe_pool_of_threads.inc
maybe_versioning.combinations MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY 2022-12-27 00:02:02 +03:00
maybe_versioning.inc MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY 2022-12-27 00:02:02 +03:00
min_null_cond.inc
mix1.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
mix2_ucs2.inc
mix2.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
mrr_tests.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
mtr_check.sql MDEV-35810 Missing error handling in log resizing 2025-01-13 10:41:40 +02:00
mtr_warnings.sql MDEV-29827 collateral cleanup 2023-07-02 12:15:11 +02:00
mysql_upgrade_preparation.inc
mysqladmin_shutdown.inc
mysqlbinlog_have_debug.inc
mysqldump.inc
mysqlhotcopy.inc Merge branch 'bb-10.4-all-builders' into bb-10.5-all-builders 2022-09-26 10:24:59 +07:00
mysqltest-x.inc
no_msan_without_big.inc MDEV-36848: identify tests with various MSAN suitability 2025-05-28 16:33:49 +10:00
no_protocol.inc
no_running_event_scheduler.inc
no_running_events.inc
no_utf8_cli.inc
no_valgrind_without_big.inc
no_view_protocol.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
not_aix.inc
not_as_root.inc
not_asan.inc
not_binlog_format_row.inc
not_blackhole.inc
not_crashrep.inc
not_debug.inc
not_embedded.inc
not_encrypted.inc
not_msan_with_debug.inc MDEV-36848: identify tests with various MSAN suitability 2025-05-28 16:33:49 +10:00
not_msan.inc MDEV-36848: identify tests with various MSAN suitability 2025-05-28 16:33:49 +10:00
not_parallel.inc
not_ssl.inc
not_staging.inc
not_staging.require
not_threadpool.inc
not_ubsan.inc
not_valgrind_build.inc Revert "mtr: remove not_valgrind_build" 2024-08-19 10:59:57 +03:00
not_valgrind.inc fix not_valgrind.inc not to error out in embedded 2022-05-30 09:58:40 +02:00
not_valgrind.require
not_var_link.inc
not_windows_embedded.inc
not_windows.inc
one_thread_per_connection.inc
one_thread_per_connection.require
optimizer_trace_no_costs.inc Fix main.order_by_join_limit on x86-debian-12: Mask the cost numbers. 2024-09-11 14:21:22 +03:00
parser_bug21114.inc
partition_date_range.inc
partition_mrr.inc
percona_nonflushing_analyze_debug.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
platform.combinations
platform.inc
plugin.defs Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
print_ddl_log.inc
protocol.combinations
protocol.inc
ps_conv.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
ps_create.inc
ps_ddl_1.inc
ps_modify1.inc
ps_modify.inc
ps_query.inc
ps_renew.inc
query_cache_partitions.inc Merge 11.4 into 11.6 2024-10-03 16:09:56 +03:00
query_cache_sql_prepare.inc MDEV-33145 Add FLUSH GLOBAL STATUS 2024-05-27 12:39:03 +02:00
query_cache.inc Merge 11.4 into 11.6 2024-10-03 16:09:56 +03:00
read_head.inc MDEV-27087: Add thread ID and database / table, where the error occured 2024-01-23 13:39:22 +05:30
read_many_rows.inc
relocate_binlogs.inc
require_openssl_client.inc
reset_master_slave.inc
reset_slave.inc Merge branch '10.9' into 10.10 2022-08-09 09:47:16 +02:00
restart_mysqld.inc Improvements to mtr 2025-04-28 12:59:39 +03:00
restart_slave_sql.inc
restore_charset.inc
rowid_filter_debug_kill.inc Merge branch '10.11' into 11.1 2024-07-08 22:40:16 +02:00
rowid_order.inc
rpl_assert.inc
rpl_change_topology.inc Merge branch '11.2' into 11.4 2024-05-21 19:38:51 +02:00
rpl_clone_slave_using_mariadb-backup.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
rpl_connect.inc MDEV-32004: Cosmetic fixes 2023-09-14 21:35:40 +02:00
rpl_connection.inc
rpl_diff.inc
rpl_end.inc Merge 10.6 into 10.10 2023-10-14 13:36:11 +03:00
rpl_for_each_slave.inc MDEV-32004: Cosmetic fixes 2023-09-14 21:35:40 +02:00
rpl_generate_sync_chain.inc
rpl_init.combinations
rpl_init.inc Merge branch '10.4' into 10.5 2023-09-15 12:04:44 +10:00
rpl_ip_mix2.inc
rpl_ip_mix.inc
rpl_ipv6.inc
rpl_loaddata_charset.inc
rpl_multi_engine2.inc
rpl_multi_engine3.inc
rpl_multi_engine.inc
rpl_reconnect.inc MDEV-32004: Remove extra server_<num>_1 connections during initialization 2023-09-14 21:35:40 +02:00
rpl_reset.inc MDEV-19801: Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it 2022-07-26 13:31:27 -06:00
rpl_restart_server.inc
rpl_row_img_general_loop.inc
rpl_row_img_set.inc
rpl_start_server.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
rpl_start_slaves.inc MDEV-32004: Cosmetic fixes 2023-09-14 21:35:40 +02:00
rpl_stmt_seq.inc
rpl_stop_server.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
rpl_stop_slaves.inc
rpl_sync.inc
rpl_udf.inc
running_event_scheduler.inc
sargable_casefold.inc MDEV-31496: Make optimizer handle UCASE(varchar_col)=... 2023-09-12 17:14:43 +03:00
save_master_gtid.inc
save_master_pos.inc
search_condition.inc MDEV-34123 CONCAT Function Returns Unexpected Empty Set in Query 2024-10-08 11:58:46 +02:00
search_pattern_in_file.inc Merge 10.6 into 10.11 2024-11-29 13:43:17 +02:00
set_binlog_format_mixed.sql
set_binlog_format_row.sql
set_binlog_format_statement.sql
setup_fake_relay_log.inc MDEV-19801: Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it 2022-07-26 13:31:27 -06:00
show_all_slaves_status.inc
show_binary_logs.inc
show_binlog_events2.inc
show_binlog_events.inc MDEV-34150 Assertion failure in Diagnostics_area::set_error_status upon binary logging hitting tmp space limit 2024-05-27 12:39:04 +02:00
show_binlog_using_logname.inc
show_delayed_slave_state.inc
show_events.inc MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range 2024-05-27 12:39:02 +02:00
show_gtid_list.inc
show_master_logs.inc
show_master_status.inc
show_msg80.inc
show_msg.inc
show_relaylog_events.inc
show_rpl_debug_info.inc Merge 10.5 -> 10.6 2024-12-05 09:20:36 +01:00
show_slave_hosts.inc
show_slave_status.inc MDEV-33856: Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps 2024-07-25 08:57:27 -06:00
shutdown_mysqld.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
slow_environ.inc mtr: increase timeouts under ASAN/UBSAN/MSAN 2024-04-05 12:40:49 +02:00
sp-cursor-pkg-01.inc MDEV-36047 Package body variables are not allowed as FETCH targets 2025-02-09 13:56:19 +04:00
sp-cursor-pkg-02.inc MDEV-36047 Package body variables are not allowed as FETCH targets 2025-02-09 13:56:19 +04:00
sp-cursor-pkg-03.inc MDEV-36047 Package body variables are not allowed as FETCH targets 2025-02-09 13:56:19 +04:00
sp-vars.inc
sql_mode_pad_char_to_full_length.inc MDEV-28190 sql_mode makes MDEV-371 virtual column expressions nondeterministic 2023-04-06 16:17:50 +04:00
start_mysqld.inc MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
start_slave.inc
stop_dump_threads.inc
stop_slave_io.inc rpl.rpl_domain_id_filter_master_crash failed on msan builder 2024-04-05 12:40:49 +02:00
stop_slave_sql.inc
stop_slave.inc
strict_autoinc.inc
subselect_mat_cost.inc
support_long_file_names.inc
switch_to_mysql_global_priv.inc
switch_to_mysql_user.inc
sync_io_with_master.inc Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
sync_slave_io_with_master.inc
sync_slave_sql_with_io.inc mtr: increase timeouts under ASAN/UBSAN/MSAN 2024-04-05 12:40:49 +02:00
sync_slave_sql_with_master.inc
sync_with_master_gtid.inc Improve mtr replication setup 2025-04-28 12:59:39 +03:00
sync_with_master.inc
system_db_struct.inc
test_db_charset_latin1.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
test_db_charset_restore.inc MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
test_fieldsize.inc MDEV-19801: Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it 2022-07-26 13:31:27 -06:00
testdb_only.inc
tpcb_disk_data.inc
tpcb.inc
true.require
truncate_file.inc
type_hrtime.inc
type_mix_incompatible.inc MDEV-29159 Patch for MDEV-28918 introduces more inconsistency than it solves, breaks usability 2022-08-05 22:23:40 +04:00
type_temporal_zero_default.inc cleanup: select ... into tests 2025-02-11 20:31:25 +01:00
unsafe_binlog.inc Merge branch 'bb-10.4-all-builders' into bb-10.5-all-builders 2022-09-26 10:24:59 +07:00
update_use_source_cases.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
update_use_source_ext.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
update_use_source.inc MDEV-29390: Improve coverage for UPDATE and DELETE statements in MTR test suites 2023-03-15 17:35:22 -07:00
uses_vardir.inc
varchar.inc
view_alias.inc
wait_condition_sp.inc
wait_condition_with_debug.inc
wait_condition.inc
wait_for_binlog_checkpoint.inc
wait_for_binlog_event.inc
wait_for_line_count_in_file.inc
wait_for_purge.inc MDEV-34504 PURGE BINARY LOGS not working anymore 2024-07-10 18:50:08 +03:00
wait_for_query_to_fail.inc
wait_for_query_to_succeed.inc
wait_for_slave_io_error.inc MDEV-32168: slave_error_param condition is never checked from the wait_for_slave_param.inc 2023-11-16 10:41:11 +01:00
wait_for_slave_io_to_start.inc MDEV-32004: Cosmetic fixes 2023-09-14 21:35:40 +02:00
wait_for_slave_io_to_stop.inc MDEV-32168: slave_error_param condition is never checked from the wait_for_slave_param.inc 2023-11-28 19:10:42 +01:00
wait_for_slave_param.inc mtr: increase timeouts under ASAN/UBSAN/MSAN 2024-04-05 12:40:49 +02:00
wait_for_slave_sql_error_and_skip.inc
wait_for_slave_sql_error.inc
wait_for_slave_sql_to_start.inc MDEV-32004: Cosmetic fixes 2023-09-14 21:35:40 +02:00
wait_for_slave_sql_to_stop.inc MDEV-32168: slave_error_param condition is never checked from the wait_for_slave_param.inc 2023-11-17 19:44:11 +01:00
wait_for_slave_to_start.inc MDEV-32004: Cosmetic fixes 2023-09-14 21:35:40 +02:00
wait_for_slave_to_stop.inc
wait_for_sql_thread_read_all.inc
wait_for_status_var.inc
wait_show_condition.inc
wait_until_connected_again.inc MDEV-33211 : Galera SST on maria-backup causes donor node to be unresponsive 2024-02-27 20:55:54 +02:00
wait_until_count_sessions.inc
wait_until_disconnected.inc CC 3.1 update 2022-07-29 13:39:12 +02:00
wait_until_no_pidfile.inc MDEV-31349 test maria.maria-purge failed on 'aria_log.00000002 not found' 2023-10-08 18:16:20 +03:00
wait_until_ready.inc
wait_until_rows_count.inc
wait_wsrep_ready.inc
weight_string_8EA1.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_8FA2C3.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_8140.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_A1A1.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_chde.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_euro.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_l1.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_l2.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
weight_string_l3.inc
weight_string_l4.inc
weight_string_l12.inc
weight_string_l14.inc
weight_string.inc MDEV-27691: make working view-protocol 2022-09-23 17:36:20 +07:00
windows_sys_vars.inc
windows.inc
word_size.combinations
word_size.inc
world_schema1.inc
world_schema_utf8.inc
world_schema.inc
world.inc Merge 10.11 into 11.0 2023-02-16 13:34:45 +02:00
write_result_to_file.inc
write_var_to_file.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
wsrep_wait_condition.inc
wsrep_wait_disconnect.inc
wsrep_wait_membership.inc