# ==== Purpose ==== # # Check corner cases related to setting sql_replica_skip_counter. # # Note: most of the "basic" tests for this variable are in # variables_with_aliases. # # Verify that sql_slave_skip_counter settable when irrespective of GTID_MODE # but gives a warning with GTID_MODE = ON # SET @@global.enforce_gtid_consistency = on; SET @@global.gtid_mode = off_permissive; set global sql_replica_skip_counter= 1; set global sql_replica_skip_counter= 0; SET @@global.gtid_mode = on_permissive; set global sql_replica_skip_counter= 1; set global sql_replica_skip_counter= 0; SET @@global.gtid_mode = on; set global sql_replica_skip_counter= 1; --let $assert_text= A warning will be generated stating "The value of sql_replica_skip_counter will only take effect for channels running with" --let $warning_code= query_get_value(SHOW WARNINGS, Code, 1) --let $expected_code= convert_error(ER_SQL_REPLICA_SKIP_COUNTER_USED_WITH_GTID_MODE_ON) --let $assert_cond= $warning_code = $expected_code --source include/assert.inc select @@global.sql_replica_skip_counter; # No warnings while setting the value to 0 set global sql_replica_skip_counter= 0; select @@global.sql_replica_skip_counter; SET @@global.gtid_mode = on_permissive; SET @@global.gtid_mode = off_permissive; SET @@global.gtid_mode = off; SET @@global.enforce_gtid_consistency = off;