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