Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate that clone threshold option only accepts valid values.
3 #
4 # Test:
5 # 0. The test requires two servers: M1 and M2.
6 # 1. Test invalid values.
7 # 2. Test valid values.
8 # 3. Clean up.
9 ################################################################################
10 --source include/have_group_replication_plugin.inc
11 --let $rpl_skip_group_replication_start= 1
12 --source include/group_replication.inc
13
14 SET @group_replication_clone_threshold_save= @@GLOBAL.group_replication_clone_threshold;
15
16
17 --echo
18 --echo ############################################################
19 --echo # 1. Test invalid values.
20
21 --error ER_WRONG_TYPE_FOR_VAR
22 SET @@GLOBAL.group_replication_clone_threshold= ON;
23
24 --error ER_WRONG_TYPE_FOR_VAR
25 SET @@GLOBAL.group_replication_clone_threshold= OFF;
26
27 --error ER_WRONG_TYPE_FOR_VAR
28 SET @@GLOBAL.group_replication_clone_threshold= " ";
29
30 --error ER_WRONG_TYPE_FOR_VAR
31 SET @@GLOBAL.group_replication_clone_threshold= "bar";
32
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET @@GLOBAL.group_replication_clone_threshold= 1.0;
35
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET @@GLOBAL.group_replication_clone_threshold= -1;
38
39 --error ER_WRONG_VALUE_FOR_VAR
40 SET @@GLOBAL.group_replication_clone_threshold= 0;
41
42 --error ER_WRONG_VALUE_FOR_VAR
43 SET @@GLOBAL.group_replication_clone_threshold= 9223372036854775808;
44
45
46 --echo
47 --echo ############################################################
48 --echo # 2. Test valid values.
49
50 SET @@GLOBAL.group_replication_clone_threshold= 1;
51 --let $assert_text= group_replication_clone_threshold is correct
52 --let $assert_cond= [SELECT @@GLOBAL.group_replication_clone_threshold] = 1
53 --source include/assert.inc
54
55 SET @@GLOBAL.group_replication_clone_threshold= 65535;
56 --let $assert_text= group_replication_clone_threshold is correct
57 --let $assert_cond= [SELECT @@GLOBAL.group_replication_clone_threshold] = 65535
58 --source include/assert.inc
59
60 SET @@GLOBAL.group_replication_clone_threshold= 4294967295;
61 --let $assert_text= group_replication_clone_threshold is correct
62 --let $assert_cond= [SELECT @@GLOBAL.group_replication_clone_threshold] = 4294967295
63 --source include/assert.inc
64
65 SET @@GLOBAL.group_replication_clone_threshold= 9223372036854775807;
66 --let $assert_text= group_replication_clone_threshold is correct
67 --let $assert_cond= [SELECT @@GLOBAL.group_replication_clone_threshold] = 9223372036854775807
68 --source include/assert.inc
69
70 SET @@GLOBAL.group_replication_clone_threshold= default;
71 --let $assert_text= group_replication_clone_threshold is correct
72 --let $assert_cond= [SELECT @@GLOBAL.group_replication_clone_threshold] = 9223372036854775807
73 --source include/assert.inc
74
75
76 --echo
77 --echo ############################################################
78 --echo # 3. Clean up.
79
80 SET @@GLOBAL.group_replication_clone_threshold= @group_replication_clone_threshold_save;
81
82 --source include/group_replication_end.inc