Debian Codegraph @

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

raw
1 # Parameter to set before including this file.
2
3 # $privilege_check = true/false
4 # $database_encryption = 'n' or 'y'
5 # $table_encryption = 'n' or 'y'
6 # $alter_tablespace_name = 'ts1' or predefined names.
7 # $alter_encryption = 'n' or 'y'
8 #
9 # $expected_error1 = ER_*
10 # $expected_error2 = ER_*
11 # $expected_error3 = ER_*
12 # $expected_error4 = ER_*
13
14 --let caseno=`SELECT $caseno+1`
15 --echo # [ALTER TABLE ... RENAME ...] Case $caseno )
16 --echo `````````````````````````````````````````````````````````
17
18 eval CREATE DATABASE db1 DEFAULT ENCRYPTION='y';
19 eval CREATE DATABASE db2 DEFAULT ENCRYPTION='n';
20
21 eval CREATE DATABASE sch1 DEFAULT ENCRYPTION='y';
22 eval CREATE DATABASE sch2 DEFAULT ENCRYPTION='n';
23
24 if ($alter_tablespace_name == 'ts1')
25 {
26 eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION=$table_encryption;
27 }
28
29 eval CREATE TABLE db1.fpt1 (f1 int) ENCRYPTION=$table_encryption;
30 eval CREATE TABLE db1.fpt2 (f1 int) ENCRYPTION=$table_encryption;
31 eval CREATE TABLE db1.ts1 (f1 int) TABLESPACE=$alter_tablespace_name ENCRYPTION=$table_encryption;
32 eval CREATE TABLE db1.ts2 (f1 int) TABLESPACE=$alter_tablespace_name ENCRYPTION=$table_encryption;
33 eval CREATE TABLE db2.fpt1 (f1 int) ENCRYPTION=$table_encryption;
34 eval CREATE TABLE db2.fpt2 (f1 int) ENCRYPTION=$table_encryption;
35 eval CREATE TABLE db2.ts1 (f1 int) TABLESPACE=$alter_tablespace_name ENCRYPTION=$table_encryption;
36 eval CREATE TABLE db2.ts2 (f1 int) TABLESPACE=$alter_tablespace_name ENCRYPTION=$table_encryption;
37
38 eval CREATE TABLE sch1.fpt (f1 int) ENCRYPTION=$table_encryption;
39 eval CREATE TABLE sch1.ts (f1 int) TABLESPACE=$alter_tablespace_name ENCRYPTION=$table_encryption;
40 eval CREATE TABLE sch2.fpt (f1 int) ENCRYPTION=$table_encryption;
41 eval CREATE TABLE sch2.ts (f1 int) TABLESPACE=$alter_tablespace_name ENCRYPTION=$table_encryption;
42
43 eval SET GLOBAL table_encryption_privilege_check=$privilege_check;
44
45 if ($has_grant == 'true')
46 {
47 connection default;
48 --echo # Grant user with TABLE_ENCRYPTION_ADMIN
49 GRANT TABLE_ENCRYPTION_ADMIN ON *.* TO u1@localhost;
50 connection con1;
51 }
52
53 if ($algo == 'copy')
54 {
55 --let clause=,MODIFY f1 CHAR(30)
56 }
57 if ($algo == 'inplace')
58 {
59 --let clause=,ADD f2 CHAR(30)
60 }
61
62 --echo # $caseno.1.
63 --echo # Rename table using file-per-table tablespace from db encryption='y'
64 --echo # to db with encryption='n' and viceversa
65 --error $expected_error1
66 eval ALTER TABLE db1.fpt1 RENAME db2.fpt1_renamed $clause;
67 --error $expected_error2
68 eval ALTER TABLE db2.fpt1 RENAME db1.fpt1_renamed $clause;
69
70 --echo # $caseno.2.
71 --echo # Rename table using general tablespace from db encryption='y'
72 --echo # to db with encryption='n' and viceversa
73 --error $expected_error3
74 eval ALTER TABLE db1.ts1 RENAME db2.ts1_rename $clause;
75 --error $expected_error4
76 eval ALTER TABLE db2.ts1 RENAME db1.ts1_rename $clause;
77
78 --echo # $caseno.3.
79 --echo # Rename table (using file-per-table/general tablespace)
80 --echo # within the database never fails.
81 eval ALTER TABLE sch1.fpt RENAME sch1.fpt_renamed $clause;
82 eval ALTER TABLE sch1.ts RENAME sch1.ts_renamed $clause;
83 eval ALTER TABLE sch2.fpt RENAME sch2.fpt_renamed $clause;
84 eval ALTER TABLE sch2.ts RENAME sch2.ts_renamed $clause;
85
86 eval SET GLOBAL table_encryption_privilege_check=false;
87 SHOW TABLES IN db1;
88 SHOW TABLES IN db2;
89 SHOW TABLES IN sch1;
90 SHOW TABLES IN sch2;
91
92 if ($has_grant == 'true')
93 {
94 connection default;
95 --echo # Revoke TABLE_ENCRYPTION_ADMIN from user.
96 REVOKE TABLE_ENCRYPTION_ADMIN ON *.* FROM u1@localhost;
97 connection con1;
98 }
99
100 # clean up
101 DROP DATABASE db1;
102 DROP DATABASE db2;
103 DROP DATABASE sch1;
104 DROP DATABASE sch2;
105
106 if ($alter_tablespace_name == 'ts1')
107 {
108 eval DROP TABLESPACE $alter_tablespace_name;
109 }
110
111 --let expected_error1=0
112 --let expected_error2=0
113 --let expected_error3=0
114 --let expected_error4=0