1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
# ==== 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;
|
