1call mtr.add_suppression("Encryption can't find master key, please check the keyring plugin is loaded");
2CREATE TABLESPACE t1 ENCRYPT='y';
3ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENCRYPT='y'' at line 1
4CREATE TABLESPACE ts_valid2 ADD DATAFILE 'ts_valid2.ibd' ENCRYPTION='';
5CREATE TABLESPACE t2 ADD DATAFILE 't2.ibd' ENCRYPTION='y';
6ERROR HY000: Failed to create TABLESPACE t2
7CREATE TABLESPACE t3 ENCRYPTION='y' ADD DATAFILE 't3.ibd';
8ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENCRYPTION='y' ADD DATAFILE 't3.ibd'' at line 1
9CREATE TABLESPACE t4 ADD DATAFILE 't4.ibd' ENCRYPTION='xyz';
10ERROR HY000: Invalid encryption option.
11CREATE TABLESPACE t5 ADD DATAFILE 't5.ibd' ENCRYPTION=y;
12ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'y' at line 1
13CREATE TABLESPACE t6 ADD DATAFILE 't6.ibd' ENCRYPTION=1;
14ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1
15CREATE TABLESPACE t7 ADD DATAFILE 't7.ibd' ENCRYPTION=y;
16ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'y' at line 1
17CREATE TABLESPACE t8 ADD DATAFILE 't8.ibd' ENCRYPTION 'xyz';
18ERROR HY000: Invalid encryption option.
19CREATE TABLESPACE t9 ADD DATAFILE 't9.ibd' ENCRYPTION y;
20ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'y' at line 1
21ALTER TABLESPACE t10 ENCRYPTION='y';
22ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENCRYPTION='y'' at line 1
23