1SET @start_global_value = @@global.innodb_temp_tablespace_encrypt;
2SELECT @start_global_value;
3@start_global_value
40
5SELECT @@global.innodb_temp_tablespace_encrypt IN (0, 1);
6@@global.innodb_temp_tablespace_encrypt IN (0, 1)
71
8SELECT @@global.innodb_temp_tablespace_encrypt;
9@@global.innodb_temp_tablespace_encrypt
100
11SELECT @@session.innodb_temp_tablespace_encrypt;
12ERROR HY000: Variable 'innodb_temp_tablespace_encrypt' is a GLOBAL variable
13SHOW GLOBAL VARIABLES LIKE 'innodb_temp_tablespace_encrypt';
14Variable_name	Value
15innodb_temp_tablespace_encrypt	OFF
16SHOW SESSION VARIABLES LIKE 'innodb_temp_tablespace_encrypt';
17Variable_name	Value
18innodb_temp_tablespace_encrypt	OFF
19SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt';
20VARIABLE_NAME	VARIABLE_VALUE
21innodb_temp_tablespace_encrypt	OFF
22SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt';
23VARIABLE_NAME	VARIABLE_VALUE
24innodb_temp_tablespace_encrypt	OFF
25SET GLOBAL innodb_temp_tablespace_encrypt = 1;
26Warnings:
27Warning	1210	 Temporary tablespace couldn't be encrypted. Check if keyring plugin is loaded.
28SELECT @@global.innodb_temp_tablespace_encrypt;
29@@global.innodb_temp_tablespace_encrypt
300
31SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt';
32VARIABLE_NAME	VARIABLE_VALUE
33innodb_temp_tablespace_encrypt	OFF
34SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt';
35VARIABLE_NAME	VARIABLE_VALUE
36innodb_temp_tablespace_encrypt	OFF
37SET @@global.innodb_temp_tablespace_encrypt = 0;
38SELECT @@global.innodb_temp_tablespace_encrypt;
39@@global.innodb_temp_tablespace_encrypt
400
41SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt';
42VARIABLE_NAME	VARIABLE_VALUE
43innodb_temp_tablespace_encrypt	OFF
44SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt';
45VARIABLE_NAME	VARIABLE_VALUE
46innodb_temp_tablespace_encrypt	OFF
47SET SESSION innodb_temp_tablespace_encrypt = 'some';
48ERROR HY000: Variable 'innodb_temp_tablespace_encrypt' is a GLOBAL variable and should be set with SET GLOBAL
49SET @@session.innodb_temp_tablespace_encrypt = 'some';
50ERROR HY000: Variable 'innodb_temp_tablespace_encrypt' is a GLOBAL variable and should be set with SET GLOBAL
51SET GLOBAL innodb_temp_tablespace_encrypt = 1.1;
52ERROR 42000: Incorrect argument type to variable 'innodb_temp_tablespace_encrypt'
53SET GLOBAL innodb_temp_tablespace_encrypt = 'foo';
54ERROR 42000: Variable 'innodb_temp_tablespace_encrypt' can't be set to the value of 'foo'
55SET GLOBAL innodb_temp_tablespace_encrypt = -2;
56ERROR 42000: Variable 'innodb_temp_tablespace_encrypt' can't be set to the value of '-2'
57SET GLOBAL innodb_temp_tablespace_encrypt = 1e1;
58ERROR 42000: Incorrect argument type to variable 'innodb_temp_tablespace_encrypt'
59SET GLOBAL innodb_temp_tablespace_encrypt = 2;
60ERROR 42000: Variable 'innodb_temp_tablespace_encrypt' can't be set to the value of '2'
61SET @@global.innodb_temp_tablespace_encrypt = @start_global_value;
62SELECT @@global.innodb_temp_tablespace_encrypt;
63@@global.innodb_temp_tablespace_encrypt
640
65