Debian Codegraph @

mysql-test/suite/group_replication/t/gr_group_consistency_variable.test

raw
1 ###############################################################################
2 # The aim of the testcase is to test parameter 'group_replication_consistency'
3 #
4 # Test:
5 # 0. This test requires one server.
6 # 1. Verify group_replication_consistency with invalid values. Expect ERROR.
7 # 2. Verify group_replication_consistency with valid values. Expect SUCCESS.
8 # 3. Cleanup.
9 ###############################################################################
10
11 --source include/have_group_replication_plugin.inc
12 --source include/group_replication.inc
13
14 --echo #
15 --echo # 1. Verify group_replication_consistency with invalid values: string,
16 --echo # out of range, decimal, and NULL. Expect ERROR.
17 --echo #
18
19 # Take backup
20 --disable_query_log
21 --let $bkp_gr_consistency_g = `SELECT @@GLOBAL.group_replication_consistency`
22 --let $bkp_gr_consistency_s = `SELECT @@SESSION.group_replication_consistency`
23 --enable_query_log
24
25 --error ER_WRONG_VALUE_FOR_VAR
26 SET GLOBAL group_replication_consistency= ON;
27
28 --error ER_WRONG_VALUE_FOR_VAR
29 SET SESSION group_replication_consistency= OFF;
30
31 --error ER_WRONG_VALUE_FOR_VAR
32 SET GLOBAL group_replication_consistency= "";
33
34 --error ER_WRONG_VALUE_FOR_VAR
35 SET SESSION group_replication_consistency= "";
36
37 --error ER_WRONG_VALUE_FOR_VAR
38 SET GLOBAL group_replication_consistency= "B";
39
40 --error ER_WRONG_VALUE_FOR_VAR
41 SET SESSION group_replication_consistency= "E";
42
43 --error ER_WRONG_VALUE_FOR_VAR
44 SET GLOBAL group_replication_consistency= -1;
45
46 --error ER_WRONG_VALUE_FOR_VAR
47 SET SESSION group_replication_consistency= -1;
48
49 --error ER_WRONG_VALUE_FOR_VAR
50 SET GLOBAL group_replication_consistency= 5;
51
52 --error ER_WRONG_VALUE_FOR_VAR
53 SET SESSION group_replication_consistency= 5;
54
55 --error ER_WRONG_TYPE_FOR_VAR
56 SET GLOBAL group_replication_consistency= 1.0;
57
58 --error ER_WRONG_TYPE_FOR_VAR
59 SET SESSION group_replication_consistency= 1.0;
60
61 --error ER_WRONG_VALUE_FOR_VAR
62 SET GLOBAL group_replication_consistency= NULL;
63
64 --error ER_WRONG_VALUE_FOR_VAR
65 SET SESSION group_replication_consistency= NULL;
66
67 --echo #
68 --echo # 2. Verify group_replication_consistency with valid values.
69 --echo # Expect SUCCESS.
70 SET GLOBAL group_replication_consistency= 1;
71 SET SESSION group_replication_consistency= 1;
72 SET GLOBAL group_replication_consistency= 0;
73 SET SESSION group_replication_consistency= 0;
74 SET GLOBAL group_replication_consistency= DEFAULT;
75 SET SESSION group_replication_consistency= DEFAULT;
76 SET GLOBAL group_replication_consistency= "BEFORE_ON_PRIMARY_FAILOVER";
77 SET SESSION group_replication_consistency= "BEFORE_ON_PRIMARY_FAILOVER";
78 SET GLOBAL group_replication_consistency= "EVENTUAL";
79 SET SESSION group_replication_consistency= "EVENTUAL";
80
81 --echo #
82 --echo # 3. Clean up.
83 --echo #
84 --disable_query_log
85 --eval SET @@GLOBAL.group_replication_consistency= "$bkp_gr_consistency_g"
86 --eval SET @@SESSION.group_replication_consistency= "$bkp_gr_consistency_s"
87 --enable_query_log
88
89 --source include/group_replication_end.inc