Gecko [ www.jdcpatala.org ]

Name	Size	Permission
binlog_anonymous_ownership.tes...	11.78 KB	-rw-r--r--
binlog_bug23533.test	1.48 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1.18 KB	-rw-r--r--
binlog_cache_write_failure-mas...	97 B	-rw-r--r--
binlog_cache_write_failure.tes...	5.4 KB	-rw-r--r--
binlog_check_flush_log_asserti...	1.68 KB	-rw-r--r--
binlog_checksum.test	1.08 KB	-rw-r--r--
binlog_crash_safe_master_check...	51 B	-rw-r--r--
binlog_crash_safe_master_check...	2.6 KB	-rw-r--r--
binlog_database.test	370 B	-rw-r--r--
binlog_delete_and_flush_index....	3.53 KB	-rw-r--r--
binlog_dmls_on_tmp_tables_read...	2.38 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	2 KB	-rw-r--r--
binlog_drop_temp_table_on_disc...	1.75 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	379 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	378 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	1.46 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	3.75 KB	-rw-r--r--
binlog_enforce_gtid_consistenc...	314 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	313 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	739 B	-rw-r--r--
binlog_enforce_gtid_consistenc...	409 B	-rw-r--r--
binlog_error_action-master.opt	88 B	-rw-r--r--
binlog_error_action.test	17.12 KB	-rw-r--r--
binlog_flush_logs_error.test	1.72 KB	-rw-r--r--
binlog_foreign_key_parent_tabl...	44 B	-rw-r--r--
binlog_foreign_key_parent_tabl...	1.08 KB	-rw-r--r--
binlog_format_switch_in_tmp_ta...	2.77 KB	-rw-r--r--
binlog_grant.test	1.83 KB	-rw-r--r--
binlog_grant_alter_user-master...	32 B	-rw-r--r--
binlog_grant_alter_user.test	39.59 KB	-rw-r--r--
binlog_group_commit_flush_cras...	51 B	-rw-r--r--
binlog_group_commit_flush_cras...	2.17 KB	-rw-r--r--
binlog_group_commit_gtid_order...	4.6 KB	-rw-r--r--
binlog_group_commit_indefinite...	1.51 KB	-rw-r--r--
binlog_group_commit_sync_delay...	1.84 KB	-rw-r--r--
binlog_group_commit_sync_delay...	1.23 KB	-rw-r--r--
binlog_group_commit_sync_no_de...	3.72 KB	-rw-r--r--
binlog_gtid_automatic_using_ro...	2.02 KB	-rw-r--r--
binlog_gtid_cache-master.opt	117 B	-rw-r--r--
binlog_gtid_cache.test	635 B	-rw-r--r--
binlog_gtid_errors-master.opt	149 B	-rw-r--r--
binlog_gtid_errors.test	9.1 KB	-rw-r--r--
binlog_gtid_exhausted-master.o...	77 B	-rw-r--r--
binlog_gtid_exhausted.test	3.3 KB	-rw-r--r--
binlog_gtid_implicit_commit.te...	121 B	-rw-r--r--
binlog_gtid_innodb.test	132 B	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	131 B	-rw-r--r--
binlog_gtid_mix_ok_packet_all_...	1.63 KB	-rw-r--r--
binlog_gtid_mix_response_packe...	99 B	-rw-r--r--
binlog_gtid_mix_response_packe...	1.82 KB	-rw-r--r--
binlog_gtid_mode_set_gtid_next...	4.66 KB	-rw-r--r--
binlog_gtid_mysqlbinlog_row.te...	197 B	-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...	707 B	-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...	661 B	-rw-r--r--
binlog_gtid_mysqlbinlog_start_...	444 B	-rw-r--r--
binlog_gtid_mysqldump.test	2.09 KB	-rw-r--r--
binlog_gtid_next_begin_caused_...	948 B	-rw-r--r--
binlog_gtid_next_partially_fai...	2.93 KB	-rw-r--r--
binlog_gtid_next_partially_fai...	9.45 KB	-rw-r--r--
binlog_gtid_next_single_stmt_t...	968 B	-rw-r--r--
binlog_gtid_next_temporary_tab...	2.73 KB	-rw-r--r--
binlog_gtid_next_xa.test	241 B	-rw-r--r--
binlog_gtid_ps_reprepare.test	6.56 KB	-rw-r--r--
binlog_gtid_purge_binlog_at_st...	3.72 KB	-rw-r--r--
binlog_gtid_rbr_only_flag.test	2.51 KB	-rw-r--r--
binlog_gtid_reset_consistency_...	2.61 KB	-rw-r--r--
binlog_gtid_row_ctype_ucs.test	265 B	-rw-r--r--
binlog_gtid_simple_recovery.te...	6 KB	-rw-r--r--
binlog_gtid_state_update_deadl...	2.62 KB	-rw-r--r--
binlog_gtid_stm_ctype_ucs.test	280 B	-rw-r--r--
binlog_gtid_unknown_xid.test	5.39 KB	-rw-r--r--
binlog_gtid_utils.test	3.56 KB	-rw-r--r--
binlog_gtids_table_gcov.test	2.86 KB	-rw-r--r--
binlog_implicit_commit.test	290 B	-rw-r--r--
binlog_incident.test	1.39 KB	-rw-r--r--
binlog_incident_ignore-master....	24 B	-rw-r--r--
binlog_incident_ignore.test	152 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	16.86 KB	-rw-r--r--
binlog_innodb-master.opt	25 B	-rw-r--r--
binlog_innodb.test	139 B	-rw-r--r--
binlog_innodb_row.test	2.72 KB	-rw-r--r--
binlog_killed.test	9.71 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.7 KB	-rw-r--r--
binlog_max_extension.test	2.61 KB	-rw-r--r--
binlog_max_flush_queue_time_wa...	32 B	-rw-r--r--
binlog_max_flush_queue_time_wa...	850 B	-rw-r--r--
binlog_mixed_cache_stat.test	277 B	-rw-r--r--
binlog_mixed_load_data.test	535 B	-rw-r--r--
binlog_mts_logical_clock.test	2.35 KB	-rw-r--r--
binlog_mts_logical_clock_gtid....	318 B	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	1.11 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.64 KB	-rw-r--r--
binlog_mysqlbinlog_concat.test	4.28 KB	-rw-r--r--
binlog_mysqlbinlog_filter.test	2.07 KB	-rw-r--r--
binlog_mysqlbinlog_intvar.test	1.59 KB	-rw-r--r--
binlog_mysqlbinlog_raw.test	3.53 KB	-rw-r--r--
binlog_mysqlbinlog_rewrite_db....	6.58 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	204 B	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	714 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	669 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	4.07 KB	-rw-r--r--
binlog_mysqlbinlog_start_stop....	452 B	-rw-r--r--
binlog_mysqlbinlog_start_stop_...	1.95 KB	-rw-r--r--
binlog_nogtid_mix_response_pac...	480 B	-rw-r--r--
binlog_noop_dml_with_readonly....	2.4 KB	-rw-r--r--
binlog_old_versions.test	5.22 KB	-rw-r--r--
binlog_purge_binary_logs_stall...	70 B	-rw-r--r--
binlog_purge_binary_logs_stall...	1.36 KB	-rw-r--r--
binlog_purge_binary_logs_to.te...	3.45 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	855 B	-rw-r--r--
binlog_rbr_only_savepoint.test	2.83 KB	-rw-r--r--
binlog_reset_connection_not_re...	3.49 KB	-rw-r--r--
binlog_reset_master.test	996 B	-rw-r--r--
binlog_rewrite.test	2.99 KB	-rw-r--r--
binlog_rewrite_db_noleak.test	2.65 KB	-rw-r--r--
binlog_rewrite_order.test	1.07 KB	-rw-r--r--
binlog_rewrite_suppress_use.te...	2.25 KB	-rw-r--r--
binlog_rotate_bgc_sync.test	3.37 KB	-rw-r--r--
binlog_rotate_deadlock-master....	181 B	-rw-r--r--
binlog_rotate_deadlock.test	1.75 KB	-rw-r--r--
binlog_row_binlog-master.opt	55 B	-rw-r--r--
binlog_row_binlog.test	783 B	-rw-r--r--
binlog_row_cache_stat.test	274 B	-rw-r--r--
binlog_row_create_select_crash...	1.35 KB	-rw-r--r--
binlog_row_ctype_cp932.test	268 B	-rw-r--r--
binlog_row_ctype_ucs.test	272 B	-rw-r--r--
binlog_row_delete_all_rows.tes...	688 B	-rw-r--r--
binlog_row_drop_tbl.test	215 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	233 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_insert_select.test	708 B	-rw-r--r--
binlog_row_kill_create_select....	845 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	97 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	585 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.36 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	5.59 KB	-rw-r--r--
binlog_row_query_log_events.te...	942 B	-rw-r--r--
binlog_server_id.test	794 B	-rw-r--r--
binlog_server_start_options-ma...	54 B	-rw-r--r--
binlog_server_start_options.te...	1.14 KB	-rw-r--r--
binlog_set_gtid_mode_ongoing_t...	6.96 KB	-rw-r--r--
binlog_set_trans_dependency_de...	2.24 KB	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_shutdown_hang.test	1.14 KB	-rw-r--r--
binlog_simulate_crash_and_erro...	4.24 KB	-rw-r--r--
binlog_spurious_ddl_errors-mas...	20 B	-rw-r--r--
binlog_spurious_ddl_errors.tes...	4.16 KB	-rw-r--r--
binlog_sql_mode.test	4.75 KB	-rw-r--r--
binlog_start_comment.test	1.01 KB	-rw-r--r--
binlog_start_slave_heartbeat-s...	16 B	-rw-r--r--
binlog_start_slave_heartbeat.t...	1.33 KB	-rw-r--r--
binlog_stm_binlog-master.opt	55 B	-rw-r--r--
binlog_stm_binlog.test	741 B	-rw-r--r--
binlog_stm_blackhole.test	456 B	-rw-r--r--
binlog_stm_cache_stat.test	280 B	-rw-r--r--
binlog_stm_ctype_cp932.test	318 B	-rw-r--r--
binlog_stm_ctype_ucs.test	287 B	-rw-r--r--
binlog_stm_delete_all_rows.tes...	712 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.8 KB	-rw-r--r--
binlog_stm_drop_tbl.test	230 B	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	248 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_insert_select.test	489 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	145 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	552 B	-rw-r--r--
binlog_stm_ps.test	939 B	-rw-r--r--
binlog_stm_row.test	3.38 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	51 B	-rw-r--r--
binlog_stm_unsafe_warning.test	5.65 KB	-rw-r--r--
binlog_stm_user_variables.test	3.4 KB	-rw-r--r--
binlog_switch_inside_trans.tes...	7.63 KB	-rw-r--r--
binlog_temporary_tables_user_v...	1.14 KB	-rw-r--r--
binlog_tmp_table.test	4.53 KB	-rw-r--r--
binlog_transaction_dependency_...	90 B	-rw-r--r--
binlog_transaction_dependency_...	8.21 KB	-rw-r--r--
binlog_transaction_dependency_...	2.2 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.98 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.33 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	1.21 KB	-rw-r--r--
binlog_transaction_write_set_s...	44 B	-rw-r--r--
binlog_transaction_write_set_s...	4.15 KB	-rw-r--r--
binlog_truncate_kill.test	1.96 KB	-rw-r--r--
binlog_truncate_myisam.test	348 B	-rw-r--r--
binlog_unsafe-master.opt	65 B	-rw-r--r--
binlog_unsafe.test	25.95 KB	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	41 B	-rw-r--r--
binlog_unsafe_stmt_capable_eng...	12.55 KB	-rw-r--r--
binlog_use_gtid_skip.test	1.03 KB	-rw-r--r--
binlog_user_if_exists.test	9.22 KB	-rw-r--r--
binlog_variables_log_bin-maste...	16 B	-rw-r--r--
binlog_variables_log_bin.test	136 B	-rw-r--r--
binlog_variables_log_bin_index...	70 B	-rw-r--r--
binlog_variables_log_bin_index...	136 B	-rw-r--r--
binlog_variables_log_statement...	2.18 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	879 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	2.45 KB	-rw-r--r--
binlog_wait_for_executed_gtid_...	633 B	-rw-r--r--
binlog_wait_for_executed_gtid_...	801 B	-rw-r--r--
binlog_write_error.test	2.7 KB	-rw-r--r--
binlog_writeset_history_protec...	3.06 KB	-rw-r--r--
binlog_wrong_last_committed.te...	3.07 KB	-rw-r--r--
binlog_xa_handling.test	3.69 KB	-rw-r--r--
binlog_xa_modify_gtid_executed...	2.93 KB	-rw-r--r--
binlog_xa_prepare_failure.test	2.05 KB	-rw-r--r--
binlog_xa_prepared_disconnect....	628 B	-rw-r--r--
binlog_xa_rollback_failure.tes...	1.4 KB	-rw-r--r--
binlog_xa_select_gtid_executed...	2.41 KB	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	98 B	-rw-r--r--
binlog_xa_trx_gtid_response_pa...	1.1 KB	-rw-r--r--
binlog_xa_trx_split_across_bin...	2.51 KB	-rw-r--r--
disabled.def	404 B	-rw-r--r--
log_builtin_as_identified_by_p...	39 B	-rw-r--r--
log_builtin_as_identified_by_p...	128 B	-rw-r--r--
show_binlog_events_no_lock.tes...	2.27 KB	-rw-r--r--

Code Editor : binlog_gtid_errors.test

# ==== Purpose ====
#
# Test errors/restrictions/conditions for the following variables:
#
#  - GTID_EXECUTED
#     - readable, read-only, both session and global
#  - GTID_PURGED
#     - readable, read-only, global only
#  - GTID_OWNED
#     - readable, read-only, both session and global
#  - GTID_NEXT
#     - read-writable, session only
#     - must be set to UUID:NUMBER or AUTOMATIC (when gtid_mode=ON)
#     - only settable by SUPER
#     - not settable from sub-statement
#     - not settable from statement that also invokes sub-statement
#     - not settable inside transaction
#     - not settable when some gtid is owned
#
# Note: some variables related to GTIDs are tested in other files:
#   GTID_MODE - rpl_gtid_mode.test
#   ENFORCE_GTID_CONSISTENCY - binlog_enforce_gtid_consistency.test
#   GTID_PURGED - rpl_gtid_purged_*.test
#
# ==== Implementation ====
#
# Just try all possibilities, verify that the correct error message is
# given.
#
# ==== References ====
#
# Implemented in WL#3584: Global Transaction Identifiers
# Bug#20343644  ASSERTION AT BINLOG.CC:1120 WHEN GTID_MODE=ON, GTID_NEXT='UUID:NUMBER'

--source include/have_innodb.inc
--source include/have_log_bin.inc
--source include/have_gtid.inc
--source include/have_debug.inc

# Clean gtid_executed so that test can execute after other tests
RESET MASTER;

--let $ida= aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa
--let $idb= bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb
--let $idc= cccccccc-cccc-cccc-cccc-cccccccccccc
--let $idd= dddddddd-dddd-dddd-dddd-dddddddddddd
--let $ide= eeeeeeee-eeee-eeee-eeee-eeeeeeeeeeee
--let $idf= ffffffff-ffff-ffff-ffff-ffffffffffff
--let $tab= `SELECT '\t'`

--echo ==== Conditions for gtid_executed ====

--echo # Readable.
--replace_regex /[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}:[0-9-]*//
SELECT @@GLOBAL.GTID_EXECUTED;
SELECT @@SESSION.GTID_EXECUTED;
--echo # Read-only.
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
eval SET @@GLOBAL.GTID_EXECUTED= '$ida:1';
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
eval SET @@SESSION.GTID_EXECUTED= '$ida:2';

--echo ==== Conditions for gtid_purged ====

--echo # Readable global variable
--replace_regex /[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}:[0-9-]*//
SELECT @@GLOBAL.GTID_PURGED;
--echo # Not a session variable
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
SELECT @@SESSION.GTID_PURGED;
--echo # Read-only.
--error ER_GLOBAL_VARIABLE
eval SET @@SESSION.GTID_PURGED= '$ida:3';

--echo ==== Conditions for gtid_owned ====

--echo # Readable.
SELECT @@GLOBAL.GTID_OWNED;
SELECT @@SESSION.GTID_OWNED;
--echo # Read-only.
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
eval SET @@SESSION.GTID_OWNED= '$ida:5';
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
eval SET @@GLOBAL.GTID_OWNED= '$ida:6#1';

--echo ==== Valid and invalid values for gtid_next ====

--echo # Default should be AUTOMATIC
SELECT @@SESSION.GTID_NEXT;

SET @@SESSION.GTID_NEXT= 'AUTOMATIC';
SELECT @@SESSION.GTID_NEXT;

eval SET @@SESSION.GTID_NEXT= '$ida:10';
SELECT @@SESSION.GTID_NEXT;
ROLLBACK;

eval SET @@SESSION.GTID_NEXT= '
    $ida $tab : $tab 10
    ';
SELECT @@SESSION.GTID_NEXT;
ROLLBACK;

eval SET @@SESSION.GTID_NEXT= '$ida:0x10';
SELECT @@SESSION.GTID_NEXT;
ROLLBACK;

eval SET @@SESSION.GTID_NEXT= '$ida:010';
SELECT @@SESSION.GTID_NEXT;
ROLLBACK;

SET @@SESSION.GTID_NEXT= 'AUTOMATIC';

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:10#';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:1-10';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:1:3';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:1,$ida:3';
SELECT @@SESSION.GTID_NEXT;

--error ER_WRONG_VALUE_FOR_VAR
SET @@SESSION.GTID_NEXT= NULL;
SELECT @@SESSION.GTID_NEXT;

--error ER_WRONG_TYPE_FOR_VAR
SET @@SESSION.GTID_NEXT= 10;
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
SET @@SESSION.GTID_NEXT= '10';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:0';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:0x8000000000000000';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:-33';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:66-33';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida:33 33';
SELECT @@SESSION.GTID_NEXT;

--error ER_MALFORMED_GTID_SPECIFICATION
eval SET @@SESSION.GTID_NEXT= '$ida-33';
SELECT @@SESSION.GTID_NEXT;

--echo ==== Conditions for gtid_next ====

--echo # Initialize
--eval CREATE FUNCTION f() RETURNS INT BEGIN RETURN 1; END
CREATE TABLE t1 (a INT) ENGINE = InnoDB;
CREATE USER nonsuper@localhost;
GRANT SELECT ON *.* TO nonsuper@localhost;
--connect (nonsuper,localhost,nonsuper,,)
--connection default

--echo # Read/write session
SELECT @@SESSION.GTID_NEXT;
eval SET @@SESSION.GTID_NEXT= '$ida:7';
ROLLBACK;
--echo # not global
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
SELECT @@GLOBAL.GTID_NEXT;
--error ER_LOCAL_VARIABLE
eval SET @@GLOBAL.GTID_NEXT= '$ida:8';
ROLLBACK;
SET GTID_NEXT = 'AUTOMATIC';

--echo # Can't set value from stored function
--eval CREATE FUNCTION set_var() RETURNS INT BEGIN SET @@SESSION.GTID_NEXT = '$ida:9'; RETURN 1; END
--error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
SELECT set_var();
DROP FUNCTION set_var;

--echo # Can't set value from trigger
eval CREATE TRIGGER t BEFORE INSERT ON t1 FOR EACH ROW SET @@SESSION.GTID_NEXT = '$ida:10';
--error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
INSERT INTO t1 VALUES (1);
DROP TRIGGER t;

--echo # Can't set value when invoking SF
--error ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION
SET @@SESSION.GTID_NEXT = f();

--echo # must be SUPER
--connection nonsuper
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
eval SET @@SESSION.GTID_NEXT = '$ida:11';

--echo # can read even if non-SUPER
SELECT @@SESSION.GTID_NEXT;
--connection default

--echo # can't set inside transaction
BEGIN;
--error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
eval SET @@SESSION.GTID_NEXT = '$ida:12';
INSERT INTO t1 VALUES (4);
ROLLBACK;

--echo # can't set while owning a GTID
eval SET @@SESSION.GTID_NEXT = '$ida:13';
--error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
eval SET @@SESSION.GTID_NEXT = '$ida:14';
# the above error will clean owned_gtid
eval SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
ROLLBACK;

--echo # can't set while owning a GTID
eval SET @@SESSION.GTID_NEXT = '$ida:13';
--error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
eval SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
ROLLBACK;

--echo # Can't set while owning ANONYMOUS
--let $rpl_gtid_mode= OFF
--source include/rpl_set_gtid_mode.inc

SET GTID_NEXT = 'ANONYMOUS';
--error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
SET GTID_NEXT = 'ANONYMOUS';

SET GTID_NEXT = 'ANONYMOUS';
--error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
eval SET GTID_NEXT = '$ida:1';

SET GTID_NEXT = 'ANONYMOUS';
--error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
SET GTID_NEXT = 'AUTOMATIC';

SET GTID_NEXT = 'AUTOMATIC';

--let $rpl_gtid_mode= ON
--source include/rpl_set_gtid_mode.inc

eval SET @@SESSION.GTID_NEXT = '$ida:14';
--echo # can't do implicit commit while gtid_next=SID:GNO
BEGIN;
--error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
CREATE TABLE t2 (a INT);
ROLLBACK;

# ==== Purpose ====
#
# Verify that we can succeed to commit a transaction with a specified gtid,
# even if an error is caused by executing the statement 'CREATE TABLE'
# in the middle.
#
# ==== References ====
#
# Bug#20343644  ASSERTION AT BINLOG.CC:1120 WHEN GTID_MODE=ON, GTID_NEXT='UUID:NUMBER'

eval SET @@SESSION.GTID_NEXT= '$ida:15';
BEGIN;
INSERT INTO t1 VALUES (1);
--error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
CREATE TABLE t2 (a INT);
COMMIT;

# ==== Purpose ====
#
# Verify that we can succeed to commit a transaction with a specified gtid,
# even if an error is caused by executing the statement 'CREATE..SELECT'
# in the middle.
#
# ==== References ====
#
# Bug#20444828  WL7592: ASSERT `THD->VARIABLES.GTID_NEXT.TYPE == GTID_GROUP' ON CREATE..SELECT

--eval SET @@SESSION.GTID_NEXT= '$ida:16'
--error ER_GTID_UNSAFE_CREATE_SELECT
CREATE TABLE t2 AS SELECT * FROM t1;
COMMIT;

eval SET @@SESSION.GTID_NEXT = '$ida:17';
--echo # can't do implicit commit while gtid_next=SID:GNO
SET AUTOCOMMIT = 0;
INSERT INTO t1 VALUES (1);
--error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
CREATE TABLE t2 (a INT);
ROLLBACK;

SELECT @@SESSION.GTID_NEXT;
eval SET @@SESSION.GTID_NEXT = 'AUTOMATIC';

DROP TABLE t1;
DROP FUNCTION f;
DROP USER nonsuper@localhost;

# It is (unfortunately) possible to set the value from a stored
# procedure.  No user should do this, it's just weird, but was hard
# to prevent so instead we allow it.  Although this is unsupported, we
# have to check that at least there is no crash.
--delimiter |
eval CREATE PROCEDURE p ()
BEGIN
  SET @@SESSION.GTID_NEXT = '$ida:16';
  ROLLBACK;
  SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
END|
--delimiter ;
CALL p();
DROP PROCEDURE p;

${this.title}

Code Editor : binlog_gtid_errors.test