1# Parser test for tablespace encrypt option
2
3call mtr.add_suppression("Encryption can't find master key, please check the keyring plugin is loaded");
4
5--error ER_PARSE_ERROR
6CREATE TABLESPACE t1 ENCRYPT='y';
7
8CREATE TABLESPACE ts_valid2 ADD DATAFILE 'ts_valid2.ibd' ENCRYPTION='';
9
10--error ER_CREATE_FILEGROUP_FAILED
11CREATE TABLESPACE t2 ADD DATAFILE 't2.ibd' ENCRYPTION='y';
12--error ER_PARSE_ERROR
13CREATE TABLESPACE t3 ENCRYPTION='y' ADD DATAFILE 't3.ibd';
14
15--error ER_INVALID_ENCRYPTION_OPTION
16CREATE TABLESPACE t4 ADD DATAFILE 't4.ibd' ENCRYPTION='xyz';
17
18--error ER_PARSE_ERROR
19CREATE TABLESPACE t5 ADD DATAFILE 't5.ibd' ENCRYPTION=y;
20
21--error ER_PARSE_ERROR
22CREATE TABLESPACE t6 ADD DATAFILE 't6.ibd' ENCRYPTION=1;
23
24--error ER_PARSE_ERROR
25CREATE TABLESPACE t7 ADD DATAFILE 't7.ibd' ENCRYPTION=y;
26
27--error ER_INVALID_ENCRYPTION_OPTION
28CREATE TABLESPACE t8 ADD DATAFILE 't8.ibd' ENCRYPTION 'xyz';
29
30--error ER_PARSE_ERROR
31CREATE TABLESPACE t9 ADD DATAFILE 't9.ibd' ENCRYPTION y;
32
33--error ER_PARSE_ERROR
34ALTER TABLESPACE t10 ENCRYPTION='y';
35