mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-10-15 12:12:10 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/binlog/t
History
Exact
Nikita Malyavin 2514baf8fe MDEV-35915 Implement Global temporary tables 
Global temporary table (GTT) is a table with globally defined metadata,
but per-session data.

That is, the life duration of this data is limited with session
duration. Here we have two options:

1. ON COMMIT DELETE ROWS: a default option. The life duration of data is
transaction duration.
2. ON COMMIT PRESERVE ROWS: The life duration of data is session
duration.

# Implementation

The implementation consists of the following fundamental parts.

## Part 1: CREATE TABLE + frm format

1. Store GLOBAL TEMPORARY and ON COMMIT bits in
   create_info->table_options
2. Store higher word of create_info->table_options in frm header
3. Also disallow ON COMMIT keyword for (local) temporary tables

As a result, the bits will be available in share->db_create_options.

New Table_type enum element: TABLE_TYPE_GLOBAL_TEMPORARY (datadict.h)

## Part 2: open_table: a local data table is created on demand

On open, a session-local temporary table copy is created from a global
TABLE_SHARE. Let us refer to the former as "local data table of GTT",
and the latter as "global metadata table of GTT".

There is a number of cases, when a global metadata table is opened
instead, like ALTER, DROP, SHOW CREATE

A local data table holds:

1. A reference to that share, and holds the increased
tdc reference count.
2. An explicit MDL lock to the duration of local copy's
existence.

While at least one local data table exists
(2) guarantees that ALTER, DROP or RENAME will not happen.
(1) guarantees that a global metadata table will not be flushed

At an implementation level, a local data table is a temporary table,
invisible for a user and augmented with (1) and (2).

The reference and lock are released upon dropping this local data table,
which happens due to:
a) TRUNCATE TABLE
b) Connection close
c) If ON COMMIT DELETE ROWS is used, then on transaction commit/rollback

## Part 3: ALTER, DROP, RENAME

These operations always open a real global temporary table.

ALTER, RENAME and DROP TABLE require all local data tables to be
destroyed, thus, having no references to a modified/deleted table.
For that, they:
1. acquire an EXCLUSIVE MDL lock. To match oracle behavior,
lock_wait_timeout is 0 in ALTER TABLE.
2. Check that there is no matching local temporary table in the same
connection (which is not guaranteed by 1)

## Part 4 ON COMMIT DELETE ROWS

This clause is assumed by default, i.e. it is implicit.

When ON COMMIT DELETE ROWS, the local data table is dropped on
commit/rollback.

On table open, global_temporary_tables handlerton is injected,
implementing this behavior.

# Limitations

The following is forbidden for GTT:
system versioning
partitioning
fk
ONLINE ALTER
CREATE GLOBAL TEMPORARY under LOCK TABLES
FLUSH TABLE on Global temporary table is no-op for now

# Refactorings, details

1. Extract drop_tmp_table_share (temporary_tables.cc)
2. Extract THD::open_temporary_table_impl (temporary_tables.cc)
3. information_schema support:
 x) "GLOBAL TEMPORARY" type is show in information_schema.tables
 y) an artifical temporary table is hidden from SHOW TABLE STATUS

4. VIEWs are supported.
5. AS SELECT support

 x) Made in Oracle style, so that the data is only inserted in the
 session that creates GTT
 y) ON COMMIT DELETE ROWS inserts the data for real, and then deletes
 the data table on implicit commit

6. CREATE TABLE ... LIKE is supported.

7. Replication support
 x) Set share->table_creation_was_logged to 0 to make the table ignored
 for replication.
 y) Statements with GTT involved will be logged in Row-based style
 (RBR)
 z) Global temporary table creation and alter/drop will be logged.
2025-10-10 19:56:24 +02:00
..
backup.test Fix that BACKUP STAGE BLOCK_COMMIT flushes binary log 2019-11-01 10:22:30 +02:00
binlog_1pc.test MDEV-28948 FLUSH BINARY LOGS waits/hangs on mysql_mutex_unlock(&LOCK_index) 2022-07-26 10:46:01 +03:00
binlog_admin_cmd_kill.test MDEV-22530: Aborting OPTIMIZE TABLE still logs in binary log and replicates to the Slave server. 2021-05-19 14:21:49 +05:30
binlog_autocommit_off_no_hang-master.opt DBAAS-7828: Primary/replica: configuration change of autocommit=0 can not be applied 2022-03-24 12:00:40 -06:00
binlog_autocommit_off_no_hang.test MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
binlog_base64_flag.test MDEV-30128 remove support for 5.1- replication events 2023-02-05 22:02:30 +01:00
binlog_bug23533.test MDEV-21087/MDEV-21433: ER_SLAVE_INCIDENT arrives at slave without failure specifics 2022-07-25 16:26:53 -06:00
binlog_bug36391-master.opt WL#5867, reorganize test cases of bugs suite 2011-04-14 00:18:08 +04:00
binlog_bug36391.test WL#5867, reorganize test cases of bugs suite 2011-04-14 00:18:08 +04:00
binlog_checkpoint.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_checkpoint_flush_logs.test MDEV-24526 binlog rotate via FLUSH LOGS may obsolate binlog file for recovery too eary 2021-04-21 15:39:32 +03:00
binlog_checksum.test Backport MySQL WL#2540 into MariaDB. 2011-05-03 14:01:11 +02:00
binlog_commit_by_rotate_atomic.test MDEV-32014: typo fix in test 2024-10-17 07:54:09 -06:00
binlog_commit_fail.test MDEV-35506 commit policy of one-phase-commit even at errored-out binlogging leads to assert 2025-04-03 20:13:10 +03:00
binlog_commit_wait.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_database.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_delete_and_flush_index-master.opt Added --log-basename to mysqld to allow one to set the prefix for all logs with one command 2011-03-23 17:59:41 +02:00
binlog_delete_and_flush_index.test BUG#34582: FLUSH LOGS does not close and reopen the binlog index 2009-10-20 09:39:40 +01:00
binlog_dmls_on_tmp_tables_readonly.test mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
binlog_drop_if_exists.test Make error messages from DROP TABLE and DROP TABLE IF EXISTS consistent 2020-06-14 19:39:42 +03:00
binlog_empty_xa_prepared.test mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
binlog_expire_logs_seconds.test MDEV-19371: Implement binlog_expire_logs_seconds for purging of binary logs 2021-05-17 12:48:37 +05:30
binlog_expire_warnings.opt Changed some startup warnings to notes 2023-02-03 11:26:07 +03:00
binlog_expire_warnings.test MDEV-19371: Implement binlog_expire_logs_seconds for purging of binary logs 2021-05-10 09:36:40 +05:30
binlog_flush_binlogs_delete_domain.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_format_switch_in_tmp_table.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_gis_user_var_stm.test MDEV-27666 User variable not parsed as geometry variable in geometry function 2024-01-16 18:53:23 +04:00
binlog_grant.test MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
binlog_gtid_delete_domain_debug.test MDEV-12012/MDEV-11969 Can't remove GTIDs for a stale GTID Domain ID 2017-11-15 22:26:32 +02:00
binlog_gtid_index.test MDEV-33145 Add FLUSH GLOBAL STATUS 2024-05-27 12:39:03 +02:00
binlog_gtid_index_crash.opt MDEV-4991: GTID binlog indexing 2024-01-27 12:09:54 +01:00
binlog_gtid_index_crash.test MDEV-4991: GTID binlog indexing 2024-01-27 12:09:54 +01:00
binlog_implicit_commit.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_incident.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_index-master.opt mtr: aix - stack-trace is optional 2021-07-22 15:22:47 +10:00
binlog_index.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_innodb.opt Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_innodb.test MDEV-33145 Add FLUSH GLOBAL STATUS 2024-05-27 12:39:03 +02:00
binlog_innodb_row.test Bug#12346411 SQL/LOG.CC:6509: ASSERTION `PREPARED_XIDS > 0' FAILED 2011-05-12 14:56:00 +02:00
binlog_innodb_stm.test MDEV-35081 - Assertion `!n_mysql_tables_in_use' failed after error upon binary logging of DML involving vector table 2025-02-03 19:41:33 +01:00
binlog_invalid_read_in_rotate.combinations After-merge fix: Actually apply the changes 2020-01-08 17:09:31 +05:30
binlog_invalid_read_in_rotate.test After-merge fix: Actually apply the changes 2020-01-08 17:09:31 +05:30
binlog_ioerr.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_killed.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_killed_simulate-master.opt MDEV-32104 remove deprecated features 2023-09-30 14:43:12 +02:00
binlog_killed_simulate.test cleanup: binlog.binlog_killed_simulate 2016-12-29 13:23:42 +01:00
binlog_max_binlog_stmt_cache_size.opt MDEV-4774 Strangeness with max_binlog_stmt_cache_size Settings 2017-01-20 21:33:36 +05:30
binlog_max_binlog_stmt_cache_size.test Mdev-4774- Fix tests cases 2017-01-31 10:12:22 +05:30
binlog_max_extension.test MDEV-23511 shutdown_server 10 times out, causing server kill at shutdown 2020-08-21 14:48:53 +03:00
binlog_mdev342-master.opt mtr: aix - stack-trace is optional 2021-07-22 15:22:47 +10:00
binlog_mdev342.test MDEV-515 Reduce InnoDB undo logging for insert into empty table 2021-01-25 18:41:27 +02:00
binlog_mdev717.test skip debug_sync test in release builds 2016-05-05 12:35:12 +02:00
binlog_mdev25611.test Fix binlog.binlog_mdev25611 test failure on non-debug build 2024-10-02 09:59:53 +02:00
binlog_mix1_drop_tmp_tbl.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_mix2_drop_tmp_tbl.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_mixed.test BINLOG with LOCK TABLES and SAVEPOINT could cause a crash in debug bin 2020-06-14 19:39:43 +03:00
binlog_mixed_cache_stat.opt Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_mixed_cache_stat.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_mixed_load_data.test Bug #34283 mysqlbinlog leaves tmpfile after termination if binlog contains load data infile 2010-08-03 10:22:19 +08:00
binlog_mysqlbinlog-cp932-master.opt BUG#14659685 - main.mysqlbinlog_row_myisam and 2012-10-30 10:40:07 +05:30
binlog_mysqlbinlog-cp932.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_mysqlbinlog2-master.opt mysql-5.1.67 merge 2013-01-09 23:51:51 +01:00
binlog_mysqlbinlog2.test Revert "MDEV-7850: Extend GTID Binlog Events with Thread Id" 2024-02-05 05:56:53 -07:00
binlog_mysqlbinlog_base64.test BUG#14659685 - main.mysqlbinlog_row_myisam and 2012-10-30 10:40:07 +05:30
binlog_mysqlbinlog_do_server_ids.test MDEV-20119: Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for mysqlbinlog 2022-04-19 11:09:24 -06:00
binlog_mysqlbinlog_glle_ordered.test MDEV-4989: Support for GTID in mysqlbinlog 2022-01-31 09:30:23 -07:00
binlog_mysqlbinlog_gtid_strict_mode.test MDEV-4989: Support for GTID in mysqlbinlog 2022-01-26 14:17:21 -07:00
binlog_mysqlbinlog_gtid_window.test MDEV-4989: Support for GTID in mysqlbinlog 2022-01-26 14:17:21 -07:00
binlog_mysqlbinlog_raw_flush.test Merge remote-tracking branch '11.3' into 11.4 2023-12-21 15:40:55 +01:00
binlog_mysqlbinlog_row-master.opt mysql-5.1.67 merge 2013-01-09 23:51:51 +01:00
binlog_mysqlbinlog_row.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
binlog_mysqlbinlog_row_frag.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
binlog_mysqlbinlog_row_innodb-master.opt mysql-5.1.67 merge 2013-01-09 23:51:51 +01:00
binlog_mysqlbinlog_row_innodb.test MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
binlog_mysqlbinlog_row_myisam-master.opt mysql-5.1.67 merge 2013-01-09 23:51:51 +01:00
binlog_mysqlbinlog_row_myisam.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_mysqlbinlog_row_trans-master.opt mysql-5.1.67 merge 2013-01-09 23:51:51 +01:00
binlog_mysqlbinlog_row_trans.test Merge 10.5 into 10.6 2023-03-22 15:54:45 +02:00
binlog_mysqlbinlog_start_alter_verbose.test MDEV-11675. Convert the new session var to bool type and test changes 2022-01-31 22:57:39 +02:00
binlog_mysqlbinlog_stop_never.test test fixes for FreeBSD 2022-05-04 19:34:20 +02:00
binlog_mysqlbinlog_suppress_O_TMPFILE.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_mysqlbinlog_warn_stop_datetime.inc MDEV-35528: mariadb-binlog cannot process more than 1 logfiles when --stop-datetime is specified 2025-01-12 11:03:10 -07:00
binlog_mysqlbinlog_warn_stop_datetime.test MDEV-35528: mariadb-binlog cannot process more than 1 logfiles when --stop-datetime is specified 2025-01-12 11:03:10 -07:00
binlog_mysqlbinlog_warn_stop_gtid.test MDEV-34614 mysqlbinlog warn on EOF before GTID in --stop-position 2025-07-14 18:07:04 -06:00
binlog_mysqlbinlog_warn_stop_position.inc Sort output of binlog_mysqlbinlog_warn_stop_gtid 2025-07-16 11:18:25 +10:00
binlog_mysqlbinlog_warn_stop_position.test MDEV-34614 mysqlbinlog warn on EOF before GTID in --stop-position 2025-07-14 18:07:04 -06:00
binlog_no_uniqfile_crash.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_parallel_replication_ddl.test MDEV-27365 CREATE-or-REPLACE SEQUENCE is binlogged without DDL flag 2022-01-03 17:39:23 +02:00
binlog_parallel_replication_marks_mix.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_parallel_replication_marks_row.test MDEV-8075: DROP TEMPORARY TABLE not marked as ddl, causing optimistic parallel replication to fail 2017-07-03 11:16:13 +03:00
binlog_parallel_replication_marks_stm.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_query_filter_rules-master.opt BUG#49978: Replication tests don't clean up replication state at the end 2010-12-19 18:07:28 +01:00
binlog_query_filter_rules.test BUG#49978: Replication tests don't clean up replication state at the end 2010-12-19 18:07:28 +01:00
binlog_recover_async_rollback_trx.test MDEV-33853 Async rollback prepared transactions during binlog 2024-09-05 21:19:25 +03:00
binlog_recover_checksum_error.test MDEV-34435 Increase code coverage for debug_dbug test case during startup 2024-06-21 17:24:29 +05:30
binlog_rotate_perf.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_row_annotate-master.opt Merge Percona patch MWL#47 into mariadb 5.2-percona. 2011-01-10 14:53:09 +01:00
binlog_row_annotate.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_binlog-master.opt MDEV-7635: Additional test fixes 2017-02-10 06:30:42 -05:00
binlog_row_binlog.test MDEV-8334: Rename utf8 to utf8mb3 2021-05-19 06:48:36 +02:00
binlog_row_cache_stat.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_ctype_cp932.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_ctype_ucs.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_drop_tbl.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_drop_tmp_tbl.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_img.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
binlog_row_innodb_stat-master.opt WL#3933 Split main test suite to rpl, rpl_ndb and ndb 2007-06-27 14:28:02 +02:00
binlog_row_insert_select.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_mix_innodb_myisam-master.opt merge. 2010-11-25 18:17:28 +01:00
binlog_row_mix_innodb_myisam.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_row_mysqlbinlog_db_filter.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_row_mysqlbinlog_options-master.opt Fix bad 5.1->5.2 merge: timezone must now be set explicitly for test cases that depend on it. 2010-02-01 20:05:19 +01:00
binlog_row_mysqlbinlog_options.test Merge 10.10 into 10.11 2023-03-29 16:53:37 +03:00
binlog_row_mysqlbinlog_verbose.test MDEV-34 delete storage/ndb and sql/*ndb* (and collateral changes) 2014-10-11 18:53:06 +02:00
binlog_server_id.test BUG#49978: Replication tests don't clean up replication state at the end 2010-12-19 18:07:28 +01:00
binlog_sf.test enable partition_open_files_limit test 2021-12-09 16:29:22 +01:00
binlog_show_binlog_event_random_pos.combinations After-merge fix: Actually apply the changes 2020-01-08 17:09:31 +05:30
binlog_show_binlog_event_random_pos.test MDEV-21839: Handle crazy offset to SHOW BINLOG EVENTS 2020-09-16 14:03:32 +05:30
binlog_show_binlog_events_invalid_offset_silent.test MDEV-32628: Cryptic ERROR message & inconsistent behavior on incorrect SHOW BINLOG EVENTS FROM ... 2023-11-17 09:43:56 -08:00
binlog_spurious_ddl_errors.test MDEV-33658 1/2 Refactoring: extract Key length initialization 2025-01-26 16:15:46 +01:00
binlog_sql_mode.test Bug#12601974 - STORED PROCEDURE SQL_MODE=NO_BACKSLASH_ESCAPES IGNORED AND BREAKS REPLICATION 2012-02-29 12:23:15 +05:30
binlog_start_comment.test Merge 5.0 -> 5.1 2008-09-30 15:32:35 -04:00
binlog_statement_insert_delayed.test Merge 10.2 into 10.3 2021-04-21 07:25:48 +03:00
binlog_stm_binlog-master.opt remove few obscure, unused, or misused mtr features 2012-02-06 18:42:18 +01:00
binlog_stm_binlog.test Merge 10.5 into 10.6 2022-12-13 16:58:58 +02:00
binlog_stm_blackhole.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_stm_cache_stat.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_stm_ctype_cp932.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_stm_ctype_ucs.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_stm_datetime_ranges_mdev15289.test MDEV 28970: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 16:34:55 +00:00
binlog_stm_do_db-master.opt remove few obscure, unused, or misused mtr features 2012-02-06 18:42:18 +01:00
binlog_stm_do_db.test MDEV-21921 Make transaction_isolation and transaction_read_only into system variables 2023-04-12 11:04:29 +10:00
binlog_stm_drop_tbl.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_stm_drop_tmp_tbl.test MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-04-28 12:59:38 +03:00
binlog_stm_innodb_stat-master.opt WL#3933 Split main test suite to rpl, rpl_ndb and ndb 2007-06-27 14:28:02 +02:00
binlog_stm_insert_select.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_stm_mix_innodb_myisam-master.opt merge. 2010-11-25 18:17:28 +01:00
binlog_stm_mix_innodb_myisam.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_stm_mysqlbinlog_collate_implicit.test MDEV-30164 System variable for default collations 2023-07-17 14:56:17 +04:00
binlog_stm_ps.test MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler 2017-11-29 10:03:51 +04:00
binlog_stm_row.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
binlog_stm_sp.test MDEV-16020 SP variables inside GROUP BY..WITH ROLLUP break replication 2018-04-27 22:11:18 +04:00
binlog_stm_sp_type_row.test MDEV-12291 Allow ROW variables as SELECT INTO targets 2017-04-05 15:03:00 +04:00
binlog_stm_unsafe_warning-master.opt Added --log-basename to mysqld to allow one to set the prefix for all logs with one command 2011-03-23 17:59:41 +02:00
binlog_stm_unsafe_warning.test MDEV-24617 OPTIMIZE on a sequence causes unexpected ER_BINLOG_UNSAFE_STATEMENT 2022-03-10 13:38:07 +02:00
binlog_stm_user_variables.test MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
binlog_switch_inside_trans.test Bug #15868071 USING SET GLOBAL SQL_LOG_BIN SHOULD NOT BE ALLOWED 2014-09-24 09:44:48 +08:00
binlog_table_map_optional_metadata.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_table_map_optional_metadata_binary.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
binlog_table_map_optional_metadata_ucs2.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
binlog_table_map_optional_metadata_utf32.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
binlog_tmp_table.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_tmp_table_row.test MDEV-9266 Creating index on temporaray table breaks replication 2018-07-18 17:13:24 +05:30
binlog_trigger.test Ensure that one can drop a trigger with an orphan .TRN file 2021-05-19 22:54:13 +02:00
binlog_truncate_active_log.inc MDEV-33465: an option to enable semisync recovery 2024-07-05 19:53:57 -06:00
binlog_truncate_active_log.test MDEV-33465: an option to enable semisync recovery 2024-07-05 19:53:57 -06:00
binlog_truncate_innodb.test Merge branch '10.2' into 10.3 2020-12-23 19:28:02 +01:00
binlog_truncate_kill.test mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
binlog_truncate_multi_engine.inc MDEV-28777 binlog.binlog_truncate_multi_engine failed in bb with Lost connection 2023-04-17 20:07:37 +03:00
binlog_truncate_multi_engine.opt MDEV-21117: refine the server binlog-based recovery for semisync 2021-06-11 19:49:39 +03:00
binlog_truncate_multi_engine.test Merge remote-tracking branch 'origin/10.11' into 11.1 2024-07-09 10:45:47 +04:00
binlog_truncate_multi_log.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_truncate_multi_log_unsafe.test MDEV-33465: an option to enable semisync recovery 2024-07-05 19:53:57 -06:00
binlog_truncate_myisam.test Move mysql-test-run/extra/binlog to suite/binlog/include 2018-03-29 13:59:44 +03:00
binlog_unsafe-master.opt post-merge fixes. 2011-07-02 22:12:12 +02:00
binlog_unsafe.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
binlog_variables_log_bin-master.opt MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_variables_log_bin.test Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_variables_log_bin_index-master.opt MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_variables_log_bin_index.test MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_variables_relay_log-master.opt MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_variables_relay_log.test Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
binlog_variables_relay_log_index-master.opt MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_variables_relay_log_index.test MDEV-7110 : Add missing MySQL variable log_bin_basename and log_bin_index 2015-06-09 13:38:29 -04:00
binlog_verbose_compressed_fields.test MDEV-25277: mysqlbinlog --verbose cannot read row events with compressed columns: Don't know how to handle column type: 140 2023-01-11 10:37:49 -07:00
binlog_write_error.test Revert MDEV-25292 Atomic CREATE OR REPLACE TABLE 2022-10-27 23:13:41 +02:00
binlog_xa_checkpoint.test MDEV-742 XA PREPAREd transaction survive disconnect/server restart 2020-03-14 22:45:48 +02:00
binlog_xa_handling.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
binlog_xa_prepared.inc MDEV-515 Reduce InnoDB undo logging for insert into empty table 2021-01-25 18:41:27 +02:00
binlog_xa_prepared_disconnect.test MDEV-742 XA PREPAREd transaction survive disconnect/server restart 2020-03-14 22:45:48 +02:00
binlog_xa_recover.opt mtr: aix - stack-trace is optional 2021-07-22 15:22:47 +10:00
binlog_xa_recover.test Add missing have_perfschema.inc 2021-03-30 16:14:19 +03:00
binlog_xa_recover_using_new_server_id.test MDEV-27342: Fix issue of recovery failure using new server id 2022-03-14 19:57:10 -07:00
create_like.test MDEV-36980 Assertion `thd->mdl_context.is_lock_owner()...fails in close_thread_table 2025-07-29 15:05:28 +02:00
flashback-largebinlog.test Extend have_sanitizer with ASAN+UBSAN and MSAN 2022-02-23 15:48:08 +02:00
flashback-master.opt [MDEV-10570] Add Flashback support 2017-01-20 15:33:28 +02:00
flashback.combinations MDEV-32894 mysqlbinlog flashback support binlog_row_image FULL_NODUP mode 2024-01-18 12:26:21 +00:00
flashback.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
foreign_key.test Clean up and speed up interfaces for binary row logging 2020-03-24 21:00:03 +02:00
global_temporary_table.test MDEV-35915 Implement Global temporary tables 2025-10-10 19:56:24 +02:00
innodb_autoinc_lock_mode_binlog.opt MDEV-19577 Replication does not work with innodb_autoinc_lock_mode=2 2022-03-10 15:38:43 +03:00
innodb_autoinc_lock_mode_binlog.test MDEV 28970: Add RESET MASTER to clear possible remaining binlog from previous test 2022-11-09 16:34:55 +00:00
innodb_rc_insert_before_delete.test mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
load_data_stm_view.test Cleanups 2017-12-08 11:38:22 +02:00
max_binlog_total_size-master.opt MDEV-31404 Implement binlog_space_limit 2024-02-14 15:02:21 +01:00
max_binlog_total_size.test MDEV-31404 Implement binlog_space_limit 2024-02-14 15:02:21 +01:00
mysqladmin.test MDEV-12612 mysqladmin --local flush... to use FLUSH LOCAL 2017-05-24 11:59:04 +02:00
read_only.inc MDEV-5215 prerequisite: remove test and test_* database hacks in the test suite 2022-11-01 16:33:00 +01:00
read_only.test Fixes for binary logging --read-only mode 2019-10-20 11:52:29 +03:00
read_only_statement.test Fixes for binary logging --read-only mode 2019-10-20 11:52:29 +03:00
show_concurrent_rotate.test MDEV-20215: binlog.show_concurrent_rotate failed in buildbot with wrong result 2021-08-13 10:53:19 -06:00
start_alter_mysqlbinlog_replay.test MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
temptable_uservar_disconnect-7938.test MDEV-7938 MariaDB Crashes Suddenly while writing binlogs 2015-04-27 15:42:12 +02:00
type_datetime_func_current_timestamp.test MDEV-15751 CURRENT_TIMESTAMP should return a TIMESTAMP [WITH TIME ZONE?] 2024-10-19 22:48:23 +02:00
type_timestamp_func_current_timestamp.test MDEV-15751 CURRENT_TIMESTAMP should return a TIMESTAMP [WITH TIME ZONE?] 2024-10-19 22:48:23 +02:00