Debian Codegraph @

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

raw
1 --echo #
2 --echo # WL#12261 Control (enforce and disable) table encryption
3 --echo #
4
5 --echo # Check for use of ENCRYPTION clause on tables using engines that
6 --echo # does not support encryption.
7
8 --echo #
9 --echo # 1. Requesting encryption on SE that does not support encryption.
10 --echo #
11 --error ER_CHECK_NOT_IMPLEMENTED
12 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=HEAP ENCRYPTION='y';
13 --error ER_CHECK_NOT_IMPLEMENTED
14 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=MyISAM ENCRYPTION='y';
15 --error ER_CHECK_NOT_IMPLEMENTED
16 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=MyISAM ENCRYPTION='w';
17
18 --echo # 2.
19 --echo # Requesting unencrypted tables on SE that does not support
20 --echo # encryption. This is allowed. Verify that we do not store
21 --echo # ENCRYPTION clause.
22 --echo #
23 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=HEAP ENCRYPTION='N';
24 SHOW CREATE TABLE t1;
25 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
26 WHERE TABLE_NAME='t1';
27 DROP TABLE t1;
28
29 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=HEAP ENCRYPTION='n';
30 SHOW CREATE TABLE t1;
31 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
32 WHERE TABLE_NAME='t1';
33 DROP TABLE t1;
34
35 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=MyISAM ENCRYPTION='';
36 SHOW CREATE TABLE t1;
37 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
38 WHERE TABLE_NAME='t1';
39 DROP TABLE t1;
40
41 --echo # 3.
42 --echo # Move tables to and from different storage engine.
43 --echo #
44
45 CREATE TABLE t1 (f1 INT NOT NULL) ENGINE=InnoDB ENCRYPTION='y';
46 SHOW CREATE TABLE t1;
47
48 --echo # 4.
49 --echo # Moving encrypted table to SE that doesn't support encryption.
50 --error ER_CHECK_NOT_IMPLEMENTED
51 ALTER TABLE t1 ENGINE=MyISAM;
52 --error ER_CHECK_NOT_IMPLEMENTED
53 ALTER TABLE t1 ENGINE=HEAP;
54
55 --echo # 5.
56 --echo # Moving encrypted table to SE that doesn't support encryption.
57 --echo # with a explicit request to decrypt the table is allowed.
58 ALTER TABLE t1 ENGINE=MyISAM ENCRYPTION='n';
59 SHOW CREATE TABLE t1;
60 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
61 WHERE TABLE_NAME='t1';
62 ALTER TABLE t1 ENGINE=Heap ENCRYPTION='N';
63 SHOW CREATE TABLE t1;
64 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
65 WHERE TABLE_NAME='t1';
66 ALTER TABLE t1 ENGINE=CSV ENCRYPTION='';
67 SHOW CREATE TABLE t1;
68 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
69 WHERE TABLE_NAME='t1';
70
71 --echo # 6.
72 --echo # Moving unencrypted table from SE that doesn't support encryption
73 --echo # to SE that does support encryption is allowed.
74 ALTER TABLE t1 ENGINE=InnoDB ENCRYPTION='y';
75 SHOW CREATE TABLE t1;
76 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
77 WHERE TABLE_NAME='t1';
78 DROP TABLE t1;
79
80 --echo # Same as 4/5/6 using general tablespace:
81 --echo #
82 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
83 CREATE TABLE t1 (f1 INT NOT NULL) TABLESPACE=ts1 ENCRYPTION='y';
84
85 --echo # 4.
86 --echo # Moving encrypted table to SE that doesn't support encryption.
87 --error ER_CHECK_NOT_IMPLEMENTED
88 ALTER TABLE t1 ENGINE=MyISAM;
89 --error ER_CHECK_NOT_IMPLEMENTED
90 ALTER TABLE t1 ENGINE=HEAP;
91
92 --echo # 5.
93 --echo # Moving encrypted table to SE that doesn't support encryption.
94 --echo # with a explicit request to decrypt the table is allowed.
95 ALTER TABLE t1 ENGINE=MyISAM ENCRYPTION='n';
96 SHOW CREATE TABLE t1;
97 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
98 WHERE TABLE_NAME='t1';
99
100 --echo # 6.
101 --echo # Moving unencrypted table from SE that doesn't support encryption
102 --echo # to SE that does support encryption is allowed.
103 ALTER TABLE t1 ENGINE=InnoDB TABLESPACE=innodb_file_per_table ENCRYPTION='n';
104 SHOW CREATE TABLE t1;
105 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
106 WHERE TABLE_NAME='t1';
107 ALTER TABLE t1 ENCRYPTION='y';
108 SHOW CREATE TABLE t1;
109 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES
110 WHERE TABLE_NAME='t1';
111 DROP TABLE t1;
112 DROP TABLESPACE ts1;