Debian Codegraph @

mysql-test/suite/encryption/t/alter_database.inc

raw
1 # Parameter to set before including this file.
2
3 # $privilege_check = 'true' or 'false'
4 # $global_database_encryption_default = 'true' or 'false'
5 # $database_encryption = 'y' or 'n'
6 # $alter_encryption = 'y' or 'n'
7 # $expected_error = ER_*
8
9 --let caseno=`SELECT $caseno+1`
10 --echo # [ALTER DATABASE] Case $caseno )
11 --echo `````````````````````````````````````````````````````````
12
13 eval CREATE DATABASE db1 DEFAULT ENCRYPTION=$database_encryption;
14 SHOW CREATE DATABASE db1;
15
16 if ($has_grant == 'true')
17 {
18 --echo # GRANT TABLE_ENCRYPTION_ADMIN
19 connection default;
20 GRANT TABLE_ENCRYPTION_ADMIN ON *.* TO u1@localhost;
21 connection con1;
22 }
23
24 eval SET SESSION default_table_encryption=$global_database_encryption_default;
25 eval SET GLOBAL table_encryption_privilege_check=$privilege_check;
26 --error $expected_error
27 eval ALTER DATABASE db1 DEFAULT ENCRYPTION=$alter_encryption;
28 SHOW WARNINGS;
29 SHOW CREATE DATABASE db1;
30 SELECT SCHEMA_NAME, DEFAULT_ENCRYPTION
31 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='db1';
32 DROP DATABASE db1;
33
34 if ($has_grant == 'true')
35 {
36 --echo # REVOKE TABLE_ENCRYPTION_ADMIN
37 connection default;
38 REVOKE TABLE_ENCRYPTION_ADMIN ON *.* FROM u1@localhost;
39 connection con1;
40 }
41
42
43 eval SET GLOBAL table_encryption_privilege_check=false;
44 eval SET SESSION default_table_encryption=false;