Debian Codegraph @

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

raw
1 ###############################################################################
2 # Variable Name: binlog_encryption
3 # Scope: global
4 # Access Type: dynamic
5 # Data Type: boolean
6 #
7 # Description: Test case for checking the behavior of dynamic system variable
8 # "binlog_encryption", specifically regarding:
9 # - Scope & access type
10 # - Valid & default value
11 # - Invalid values
12 # - Required privileges
13 #
14 # Reference: WL#10957
15 ###############################################################################
16
17 # Save initial value
18 --let $saved_binlog_encryption= `SELECT @@global.binlog_encryption`
19
20 #
21 # Scope: Global only
22 #
23 SELECT COUNT(@@GLOBAL.binlog_encryption);
24
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 SELECT COUNT(@@SESSION.binlog_encryption);
27
28 --disable_warnings
29 SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_encryption';
30 SELECT VARIABLE_NAME FROM performance_schema.session_variables WHERE VARIABLE_NAME='binlog_encryption';
31 --enable_warnings
32
33 #
34 # Access Type: Dynamic
35 #
36 SET GLOBAL binlog_encryption= ON;
37 --let $assert_text= 'binlog_encryption is a dynamic variable'
38 --let $assert_cond= "[SELECT @@GLOBAL.binlog_encryption]" = "1"
39 --source include/assert.inc
40
41 #
42 # Valid values and Default value
43 #
44 SET GLOBAL binlog_encryption= OFF;
45 --let $assert_text= 'binlog_encryption should be OFF'
46 --let $assert_cond= "[SELECT @@GLOBAL.binlog_encryption]" = "0"
47 --source include/assert.inc
48
49 SET GLOBAL binlog_encryption= ON;
50 --let $assert_text= 'binlog_encryption should be ON'
51 --let $assert_cond= "[SELECT @@GLOBAL.binlog_encryption]" = "1"
52 --source include/assert.inc
53
54 SET GLOBAL binlog_encryption= 0;
55 --let $assert_text= 'binlog_encryption should be OFF'
56 --let $assert_cond= "[SELECT @@GLOBAL.binlog_encryption]" = "0"
57 --source include/assert.inc
58
59 SET GLOBAL binlog_encryption= 1;
60 --let $assert_text= 'binlog_encryption should be ON'
61 --let $assert_cond= "[SELECT @@GLOBAL.binlog_encryption]" = "1"
62 --source include/assert.inc
63
64 SET GLOBAL binlog_encryption= DEFAULT;
65 --let $assert_text= 'binlog_encryption should be OFF'
66 --let $assert_cond= "[SELECT @@GLOBAL.binlog_encryption]" = "0"
67 --source include/assert.inc
68
69 #
70 # Invalid values
71 #
72 --error ER_WRONG_VALUE_FOR_VAR
73 SET GLOBAL binlog_encryption= NULL;
74
75 --error ER_WRONG_VALUE_FOR_VAR
76 SET GLOBAL binlog_encryption= '';
77
78 --error ER_WRONG_VALUE_FOR_VAR
79 SET GLOBAL binlog_encryption= -1;
80
81 --error ER_WRONG_TYPE_FOR_VAR
82 SET GLOBAL binlog_encryption= 1.0;
83
84 --error ER_WRONG_VALUE_FOR_VAR
85 SET GLOBAL binlog_encryption= 'GARBAGE';
86
87 --error ER_WRONG_VALUE_FOR_VAR
88 SET GLOBAL binlog_encryption= 2;
89
90 --echo Expect value still set to "OFF"
91 SELECT @@global.binlog_encryption;
92
93 #
94 # Privileges
95 #
96
97 CREATE USER user1;
98 --connect(conn_user1,localhost,user1,,)
99
100 --Error ER_SPECIFIC_ACCESS_DENIED_ERROR
101 SET GLOBAL binlog_encryption=ON;
102 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
103 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
104
105 --connection default
106 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO user1@'%';
107 --connection conn_user1
108 # SYSTEM_VARIABLES_ADMIN is not enough
109 --Error ER_SPECIFIC_ACCESS_DENIED_ERROR
110 SET GLOBAL binlog_encryption=ON;
111 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
112 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
113
114 --connection default
115 GRANT BINLOG_ENCRYPTION_ADMIN ON *.* TO user1@'%';
116 --connection conn_user1
117 SET GLOBAL binlog_encryption=ON;
118 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
119
120 --connection default
121 REVOKE SYSTEM_VARIABLES_ADMIN ON *.* FROM user1@'%';
122 --connection conn_user1
123 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
124 # BINLOG_ENCRYPTION_ADMIN is not enough
125 --Error ER_SPECIFIC_ACCESS_DENIED_ERROR
126 SET GLOBAL binlog_encryption=OFF;
127 --connection default
128 REVOKE BINLOG_ENCRYPTION_ADMIN ON *.* FROM user1@'%';
129
130 --connection default
131 --disconnect conn_user1
132 DROP USER user1;
133
134 # Clean up
135 --disable_query_log
136 --eval SET GLOBAL binlog_encryption= $saved_binlog_encryption
137 --enable_query_log