Debian Codegraph @

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

raw
1 # Parameter to set before including this file.
2 # $privilege_check = 'true' or 'false'
3 # $global_database_encryption_default = 'true' or 'false'
4 # $explicit_encryption_clause = 'true' or 'false'
5 # $tablespace_encryption = 'y' or 'n'
6 # $expected_error = ER_*
7
8 --let caseno=`SELECT $caseno+1`
9 --echo # [ALTER TABLESPACE] Case $caseno )
10 --echo `````````````````````````````````````````````````````````
11
12 eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION=$tablespace_encryption;
13 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
14 WHERE NAME LIKE 'ts1';
15
16 eval SET SESSION default_table_encryption=$global_database_encryption_default;
17 eval SET GLOBAL table_encryption_privilege_check=$privilege_check;
18
19 --error $expected_error
20 eval ALTER TABLESPACE ts1 ENCRYPTION=$alter_encryption;
21 SHOW WARNINGS;
22 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
23 WHERE NAME LIKE 'ts1';
24 DROP TABLESPACE ts1;
25
26 if ($privilege_check == 'true')
27 {
28 --echo # Check that we never fail with TABLE_ENCRYPTION_ADMIN
29 connection default;
30 --echo # Grant user with TABLE_ENCRYPTION_ADMIN
31 GRANT TABLE_ENCRYPTION_ADMIN ON *.* TO u1@localhost;
32 connection con1;
33
34 SET GLOBAL table_encryption_privilege_check=false;
35 eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION=$tablespace_encryption;
36 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
37 WHERE NAME LIKE 'ts1';
38
39 eval SET GLOBAL table_encryption_privilege_check=$privilege_check;
40 eval ALTER TABLESPACE ts1 ENCRYPTION=$alter_encryption;
41 SHOW WARNINGS;
42 SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
43 WHERE NAME LIKE 'ts1';
44 DROP TABLESPACE ts1;
45
46 connection default;
47 --echo # Revoke TABLE_ENCRYPTION_ADMIN from user.
48 REVOKE TABLE_ENCRYPTION_ADMIN ON *.* FROM u1@localhost;
49 connection con1;
50 }
51
52 # Clean up
53 SET GLOBAL table_encryption_privilege_check=false;
54 SET SESSION default_table_encryption=false;