Debian Codegraph @

mysql-test/suite/sys_vars/t/skip_replica_start.test

raw
1 # Variable Name: skip_replica_start
2 # Scope: Global
3 # Access Type: Persist-only
4 # Data Type: boolean
5 #
6 # Creation Date: 2020-12-14
7 # Author : Pedro Figueiredo
8
9 ####################################################################
10 # Displaying default value #
11 ####################################################################
12
13 --let $assert_text = Default GLOBAL value is FALSE
14 --let $assert_cond = [SELECT @@global.skip_replica_start = 0]
15 --source include/assert.inc
16
17 ####################################################################
18 # Check if Value can set and that P_S reports the correct value #
19 ####################################################################
20
21 --let $ps_table = global_variables
22
23 # 1, TRUE, ON, 0, FALSE, OFF with `SET PERSIST_ONLY`
24 --let $j = 6
25
26 while($j > 0)
27 {
28 if ($j == 6)
29 {
30 --let $to_set = ON
31 --let $expected = ON
32 }
33 if ($j == 5)
34 {
35 --let $to_set = OFF
36 --let $expected = OFF
37 }
38 if ($j == 4)
39 {
40 --let $to_set = TRUE
41 --let $expected = ON
42 }
43 if ($j == 3)
44 {
45 --let $to_set = FALSE
46 --let $expected = OFF
47 }
48 if ($j == 2)
49 {
50 --let $to_set = 1
51 --let $expected = ON
52 }
53 if ($j == 1)
54 {
55 --let $to_set = 0
56 --let $expected = OFF
57 }
58
59 --let $scope = PERSIST_ONLY
60 --let $ps_table = global_variables
61
62 --eval SET $scope skip_replica_start = $to_set
63
64 --source include/restart_mysqld.inc
65
66 --let $reported=`SELECT variable_value FROM performance_schema.$ps_table WHERE variable_name = 'skip_replica_start'`
67 --let $assert_text= Reported value matches the one set (set $to_set in $scope scope)
68 --let $assert_cond = "$reported" = "$expected"
69 --source include/assert.inc
70
71 --dec $j
72 }
73 RESET PERSIST skip_replica_start;
74
75 # 1, TRUE, ON, 0, FALSE, OFF with `--skip-replica-start`
76 --let $j = 6
77
78 while($j > 0)
79 {
80 if ($j == 6)
81 {
82 --let $to_set = ON
83 --let $expected = ON
84 }
85 if ($j == 5)
86 {
87 --let $to_set = OFF
88 --let $expected = OFF
89 }
90 if ($j == 4)
91 {
92 --let $to_set = TRUE
93 --let $expected = ON
94 }
95 if ($j == 3)
96 {
97 --let $to_set = FALSE
98 --let $expected = OFF
99 }
100 if ($j == 2)
101 {
102 --let $to_set = 1
103 --let $expected = ON
104 }
105 if ($j == 1)
106 {
107 --let $to_set = 0
108 --let $expected = OFF
109 }
110
111 --let $restart_parameters = restart: --skip-replica-start=$to_set
112 --source include/restart_mysqld.inc
113
114 --let $reported=`SELECT variable_value FROM performance_schema.$ps_table WHERE variable_name = 'skip_replica_start'`
115 --let $assert_text= Reported value matches the one set (set $to_set in `--skip-replica-start` parameter)
116 --let $assert_cond = "$reported" = "$expected"
117 --source include/assert.inc
118
119 --dec $j
120 }
121
122 ####################################################################
123 # Privileges #
124 ####################################################################
125
126 CREATE USER user1;
127 --connect(conn_user1,localhost,user1,,)
128
129 # assert that one cannot change the value without privileges
130 --error ER_PERSIST_ONLY_ACCESS_DENIED_ERROR
131 SET PERSIST_ONLY skip_replica_start = 1;
132 --disconnect conn_user1
133
134 # assert that one can change the value if SYSTEM_VARIABLES_ADMIN and
135 # PERSIST_RO_VARIABLES_ADMIN is given
136 --connection default
137 GRANT SYSTEM_VARIABLES_ADMIN, PERSIST_RO_VARIABLES_ADMIN ON *.* TO user1@'%';
138 FLUSH PRIVILEGES;
139
140 --connect(conn2_user1,localhost,user1,,)
141 SET PERSIST_ONLY skip_replica_start = 1;
142 --disconnect conn2_user1
143
144 --connection default
145 DROP USER user1;
146 RESET PERSIST skip_replica_start;
147
148 ####################################################################
149 # Transactional context #
150 ####################################################################
151
152 BEGIN;
153
154 # can change the variable's value in global scope while inside a transaction
155 SET PERSIST_ONLY skip_replica_start = ON;
156
157 ROLLBACK;
158
159 ####################################################################
160 # End of tests #
161 ####################################################################
162
163 RESET PERSIST skip_replica_start;