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