Debian Codegraph @

mysql-test/suite/encryption/t/database.test

raw
1 --echo #
2 --echo # WL#12261 Control (enforce and disable) table encryption
3 --echo #
4 --source include/have_debug.inc
5
6 --echo # Pre-define user u1, which is used in different tests below.
7 CREATE USER u1@localhost;
8 GRANT ALL ON db1.* TO u1@localhost;
9 GRANT CREATE TABLESPACE, PROCESS, SYSTEM_VARIABLES_ADMIN ON *.* TO u1@localhost;
10 SET GLOBAL debug= '+d,skip_table_encryption_admin_check_for_set';
11 connect (con1, localhost, u1);
12
13 --echo # This test run CREATE/ALTER DATABASE in different configurations,
14 --echo #
15 --echo # - Setting table_encryption_privilege_check to true/false.
16 --echo # - Setting default_table_encryption to true/false.
17 --echo # - With and without ENCRYPTION clause.
18 --echo # - With and without user holding TABLE_ENCRYPTION_ADMIN privilege.
19 --echo # - Test SHOW CREATE DATABASE
20 --echo # - Test INFORMATION_SCHEMA.SCHEMATA
21 --echo # - Check for warnings generated.
22 --echo #
23
24 # Initialization
25 --let caseno=0
26 --let expected_error=0
27 --let has_grant=false
28 --let with_default=true
29
30 --echo `````````````````````````````````````````````````````````
31 --echo # CREATE DATABASE without DEFAULT ENCRYPTION clause
32 --echo # and with different values for system variable
33 --echo # 'table_encryption_privilege_check' and 'default_table_encryption'
34
35 --let explicit_encryption_clause=false
36 --let privilege_check=false
37 --let global_database_encryption_default=false;
38 --source ./create_database.inc
39 --let global_database_encryption_default=true;
40 --source ./create_database.inc
41
42 --let privilege_check=true
43 --let global_database_encryption_default=false;
44 --source ./create_database.inc
45 --let global_database_encryption_default=true;
46 --source ./create_database.inc
47
48 --let has_grant=true
49 --let global_database_encryption_default=false;
50 --source ./create_database.inc
51 --let global_database_encryption_default=true;
52 --source ./create_database.inc
53 --let has_grant=false
54
55 --echo `````````````````````````````````````````````````````````
56 --echo # CREATE DATABASE with DEFAULT ENCRYPTION clause 'y/n'
57 --echo # and with different values for system variable
58 --echo # 'table_encryption_privilege_check' and 'default_table_encryption'.
59 --let explicit_encryption_clause=true
60
61 --let privilege_check=false
62 --let global_database_encryption_default=false;
63 --let database_encryption='y'
64 --source ./create_database.inc
65 --let database_encryption='n'
66 --source ./create_database.inc
67 --let global_database_encryption_default=true;
68 --let database_encryption='y'
69 --source ./create_database.inc
70 --let database_encryption='n'
71 --source ./create_database.inc
72
73 --echo `````````````````````````````````````````````````````````
74 --echo # Without the keyword DEFAULT.
75 --let with_default=false
76 --let global_database_encryption_default=false;
77 --let database_encryption='y'
78 --source ./create_database.inc
79 --let database_encryption='n'
80 --source ./create_database.inc
81 --let global_database_encryption_default=true;
82 --let database_encryption='y'
83 --source ./create_database.inc
84 --let database_encryption='n'
85 --source ./create_database.inc
86 --let with_default=true
87
88 --let privilege_check=true
89 --let global_database_encryption_default=false;
90 --echo `````````````````````````````````````````````````````````
91 --echo # We expect failure because the encryption request is different from
92 --echo # global 'default_table_encryption' setting.
93 --let database_encryption='y'
94 --let expected_error=ER_CANNOT_SET_DATABASE_ENCRYPTION
95 --source ./create_database.inc
96 --let expected_error=0
97 --let database_encryption='n'
98 --source ./create_database.inc
99 --let global_database_encryption_default=true;
100 --let database_encryption='y'
101 --source ./create_database.inc
102 --echo `````````````````````````````````````````````````````````
103 --echo # We expect failure because the encryption request is different from
104 --echo # global 'default_table_encryption' setting.
105 --let database_encryption='n'
106 --let expected_error=ER_CANNOT_SET_DATABASE_ENCRYPTION
107 --source ./create_database.inc
108
109 --let has_grant=true
110 --let global_database_encryption_default=false;
111 --let expected_error=0
112 --let database_encryption='y'
113 --source ./create_database.inc
114 --let expected_error=0
115 --let database_encryption='n'
116 --source ./create_database.inc
117 --let global_database_encryption_default=true;
118 --let database_encryption='y'
119 --source ./create_database.inc
120 --let expected_error=0
121 --let database_encryption='n'
122 --source ./create_database.inc
123 --let has_grant=false
124 --let privilege_check=false
125 --let global_database_encryption_default=false;
126
127 --echo `````````````````````````````````````````````````````````
128 --echo # With invalid value for DEFAULT ENCRYPTION
129 --let expected_error=ER_WRONG_VALUE
130 --let database_encryption='k'
131 --source ./create_database.inc
132
133 --echo `````````````````````````````````````````````````````````
134 --echo # Check with legacy syntax.
135 CREATE DATABASE `db1` /*!80016 DEFAULT ENCRYPTION='Y' */;
136 SHOW CREATE DATABASE db1;
137 DROP DATABASE db1;
138 --echo `````````````````````````````````````````````````````````
139 --echo # See that we ignore the clause with invalid mysql version.
140 CREATE DATABASE `db1` /*!99999 DEFAULT ENCRYPTION='Y' */;
141 SHOW CREATE DATABASE db1;
142 DROP DATABASE db1;
143
144 --echo `````````````````````````````````````````````````````````
145 --echo # ALTER DATABASE withDEFAULT ENCRYPTION clause 'y/n'
146 --echo # and with different values for system variable
147 --echo # 'table_encryption_privilege_check' and 'default_table_encryption'
148
149 --let expected_error=0
150 --let caseno=0
151
152 --echo `````````````````````````````````````````````````````````
153 --echo # Following cases are with database DEFAULT ENCRYPTION 'y'
154 --let database_encryption='n'
155
156 --let privilege_check=false
157 --let global_database_encryption_default=false;
158 --let alter_encryption='n'
159 --source ./alter_database.inc
160 --let alter_encryption='y'
161 --source ./alter_database.inc
162 --let global_database_encryption_default=true;
163 --let alter_encryption='n'
164 --source ./alter_database.inc
165 --let alter_encryption='y'
166 --source ./alter_database.inc
167
168 --let privilege_check=true
169 --let global_database_encryption_default=false;
170 --let alter_encryption='n'
171 --source ./alter_database.inc
172 --echo `````````````````````````````````````````````````````````
173 --echo # We expect failure because the encryption request is different from
174 --echo # global 'default_table_encryption' setting.
175 --let alter_encryption='y'
176 --let expected_error=ER_CANNOT_SET_DATABASE_ENCRYPTION
177 --source ./alter_database.inc
178 --let global_database_encryption_default=true;
179 --echo `````````````````````````````````````````````````````````
180 --echo # We expect failure because the encryption request is different from
181 --echo # global 'default_table_encryption' setting.
182 --let alter_encryption='n'
183 --let expected_error=ER_CANNOT_SET_DATABASE_ENCRYPTION
184 --source ./alter_database.inc
185 --let expected_error=0
186 --let alter_encryption='y'
187 --source ./alter_database.inc
188
189 --let has_grant=true
190 --let global_database_encryption_default=false;
191 --let alter_encryption='n'
192 --source ./alter_database.inc
193 --let alter_encryption='y'
194 --let expected_error=0
195 --source ./alter_database.inc
196 --let global_database_encryption_default=true;
197 --let expected_error=0
198 --let alter_encryption='n'
199 --source ./alter_database.inc
200 --let expected_error=0
201 --let alter_encryption='y'
202 --source ./alter_database.inc
203 --let has_grant=false
204
205 --echo `````````````````````````````````````````````````````````
206 --echo # Following cases are with database DEFAULT ENCRYPTION 'y'
207 --let database_encryption='y'
208
209 --let privilege_check=false
210 --let global_database_encryption_default=false;
211 --let alter_encryption='n'
212 --source ./alter_database.inc
213 --let alter_encryption='y'
214 --source ./alter_database.inc
215 --let global_database_encryption_default=true;
216 --let alter_encryption='n'
217 --source ./alter_database.inc
218 --let alter_encryption='y'
219 --source ./alter_database.inc
220
221 --let privilege_check=true
222 --let global_database_encryption_default=false;
223 --let alter_encryption='n'
224 --source ./alter_database.inc
225 --echo `````````````````````````````````````````````````````````
226 --echo # We expect failure because the encryption request is different from
227 --echo # global 'default_table_encryption' setting.
228 --let alter_encryption='y'
229 --let expected_error=ER_CANNOT_SET_DATABASE_ENCRYPTION
230 --source ./alter_database.inc
231
232 --echo `````````````````````````````````````````````````````````
233 --echo # We expect failure because the encryption request is different from
234 --echo # global 'default_table_encryption' setting.
235 --let global_database_encryption_default=true;
236 --let alter_encryption='n'
237 --let expected_error=ER_CANNOT_SET_DATABASE_ENCRYPTION
238 --source ./alter_database.inc
239 --let expected_error=0
240 --let alter_encryption='y'
241 --source ./alter_database.inc
242
243 --let has_grant=true
244 --let global_database_encryption_default=false;
245 --let alter_encryption='n'
246 --source ./alter_database.inc
247 --let expected_error=0
248 --let alter_encryption='y'
249 --source ./alter_database.inc
250 --let global_database_encryption_default=true;
251 --let expected_error=0
252 --let alter_encryption='n'
253 --source ./alter_database.inc
254 --let expected_error=0
255 --let alter_encryption='y'
256 --source ./alter_database.inc
257 --let has_grant=false
258
259 --echo `````````````````````````````````````````````````````````
260 --echo # Invalid encryption option.
261 --let privilege_check=false
262 --let global_database_encryption_default=false;
263 --let expected_error=ER_WRONG_VALUE
264 --let alter_encryption='k'
265 --source ./alter_database.inc
266
267 --echo # Cleanup
268 disconnect con1;
269 connection default;
270 DROP USER u1@localhost;
271 SET GLOBAL debug= '-d,skip_table_encryption_admin_check_for_set';