Debian Codegraph @

mysql-test/suite/sys_vars/t/sql_replica_skip_counter_basic.test

raw
1 # ==== Purpose ====
2 #
3 # Check corner cases related to setting sql_replica_skip_counter.
4 #
5 # Note: most of the "basic" tests for this variable are in
6 # variables_with_aliases.
7
8 #
9 # Verify that sql_slave_skip_counter settable when irrespective of GTID_MODE
10 # but gives a warning with GTID_MODE = ON
11 #
12
13 SET @@global.enforce_gtid_consistency = on;
14 SET @@global.gtid_mode = off_permissive;
15 set global sql_replica_skip_counter= 1;
16 set global sql_replica_skip_counter= 0;
17
18 SET @@global.gtid_mode = on_permissive;
19 set global sql_replica_skip_counter= 1;
20 set global sql_replica_skip_counter= 0;
21
22 SET @@global.gtid_mode = on;
23 set global sql_replica_skip_counter= 1;
24 --let $assert_text= A warning will be generated stating "The value of sql_replica_skip_counter will only take effect for channels running with"
25 --let $warning_code= query_get_value(SHOW WARNINGS, Code, 1)
26 --let $expected_code= convert_error(ER_SQL_REPLICA_SKIP_COUNTER_USED_WITH_GTID_MODE_ON)
27 --let $assert_cond= $warning_code = $expected_code
28 --source include/assert.inc
29
30 select @@global.sql_replica_skip_counter;
31 # No warnings while setting the value to 0
32 set global sql_replica_skip_counter= 0;
33 select @@global.sql_replica_skip_counter;
34
35 SET @@global.gtid_mode = on_permissive;
36 SET @@global.gtid_mode = off_permissive;
37 SET @@global.gtid_mode = off;
38 SET @@global.enforce_gtid_consistency = off;