Debian Codegraph @

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

raw
1 ################################################################################
2 # Verify that group_replication_transaction_size_limit options do behave as expected.
3 # 1. Test group_replication_transaction_size_limit option.
4 # 2. Change group_replication_transaction_size options while
5 # Group Replication is running.
6 # 3. Clean up.
7 ################################################################################
8 --source include/have_group_replication_plugin.inc
9 --let $rpl_skip_group_replication_start= 1
10 --source include/group_replication.inc
11
12 SET @group_replication_transaction_size_limit_save= @@GLOBAL.group_replication_transaction_size_limit;
13 --let $group_replication_transaction_size_limit_max = 2147483647
14 --let $group_replication_transaction_size_limit_min = 0
15 --let $group_replication_transaction_size_limit_default = 150000000
16 ################################################################################
17 --echo
18 --echo ## 1. Test group_replication_transaction_size_limit option.
19 # Invalid values
20 --error ER_WRONG_TYPE_FOR_VAR
21 SET GLOBAL group_replication_transaction_size_limit= "";
22
23 --error ER_WRONG_TYPE_FOR_VAR
24 SET GLOBAL group_replication_transaction_size_limit= "ABC";
25
26 --disable_warnings
27 SET GLOBAL group_replication_transaction_size_limit= 2147483648;
28 --let $assert_text= group_replication_transaction_size_limit is max
29 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
30 --source include/assert.inc
31
32 SET GLOBAL group_replication_transaction_size_limit= -1;
33 --let $assert_text= group_replication_transaction_size_limit is min
34 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
35 --source include/assert.inc
36
37 SET GLOBAL group_replication_transaction_size_limit= 3000000000;
38 --let $assert_text= group_replication_transaction_size_limit is max
39 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
40 --source include/assert.inc
41
42 SET GLOBAL group_replication_transaction_size_limit= -2;
43 --let $assert_text= group_replication_transaction_size_limit is min
44 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
45 --source include/assert.inc
46 --enable_warnings
47
48 # Valid values
49 SET GLOBAL group_replication_transaction_size_limit= 1;
50 --let $assert_text= group_replication_transaction_size_limit is correct
51 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 1
52 --source include/assert.inc
53
54 SET GLOBAL group_replication_transaction_size_limit= 0;
55 --let $assert_text= group_replication_transaction_size_limit is correct
56 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 0
57 --source include/assert.inc
58
59 SET GLOBAL group_replication_transaction_size_limit= 1024;
60 --let $assert_text= group_replication_transaction_size_limit is correct
61 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 1024
62 --source include/assert.inc
63
64 SET GLOBAL group_replication_transaction_size_limit= 2147483647;
65 --let $assert_text= group_replication_transaction_size_limit is correct
66 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 2147483647
67 --source include/assert.inc
68
69 # Reset value to default for further testing
70 SET GLOBAL group_replication_transaction_size_limit= default;
71 --let $assert_text= group_replication_transaction_size_limit is correct
72 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_default
73 --source include/assert.inc
74 ################################################################################
75 --echo
76 --echo ## 2. Change group_replication_transaction_size options while
77 --echo ## Group Replication is running.
78 --source include/start_and_bootstrap_group_replication.inc
79
80 # Invalid values
81 --error ER_WRONG_TYPE_FOR_VAR
82 SET GLOBAL group_replication_transaction_size_limit= "";
83
84 --error ER_WRONG_TYPE_FOR_VAR
85 SET GLOBAL group_replication_transaction_size_limit= "ABC";
86
87 --disable_warnings
88 SET GLOBAL group_replication_transaction_size_limit= 2147483648;
89 --let $assert_text= group_replication_transaction_size_limit is max
90 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
91 --source include/assert.inc
92
93 SET GLOBAL group_replication_transaction_size_limit= -1;
94 --let $assert_text= group_replication_transaction_size_limit is min
95 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
96 --source include/assert.inc
97
98 SET GLOBAL group_replication_transaction_size_limit= 3000000000;
99 --let $assert_text= group_replication_transaction_size_limit is max
100 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
101 --source include/assert.inc
102
103 SET GLOBAL group_replication_transaction_size_limit= -2;
104 --let $assert_text= group_replication_transaction_size_limit is min
105 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
106 --source include/assert.inc
107 --enable_warnings
108
109 #Valid values
110 SET GLOBAL group_replication_transaction_size_limit= 1024;
111 --let $assert_text= group_replication_transaction_size_limit is correct
112 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 1024
113 --source include/assert.inc
114
115 SET GLOBAL group_replication_transaction_size_limit= 2147483647;
116 --let $assert_text= group_replication_transaction_size_limit is correct
117 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 2147483647
118 --source include/assert.inc
119
120 SET GLOBAL group_replication_transaction_size_limit= 0;
121 --let $assert_text= group_replication_transaction_size_limit is correct
122 --let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 0
123 --source include/assert.inc
124
125 ################################################################################
126 --echo
127 --echo ## 3. Clean up.
128 SET GLOBAL group_replication_transaction_size_limit= @group_replication_transaction_size_limit_save;
129
130 --source include/group_replication_end.inc