Debian Codegraph @

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