Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_redo_log_encrypt_basic.result

raw
1 SET @start_global_value = @@global.innodb_redo_log_encrypt;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.innodb_redo_log_encrypt in (0, 1);
6 @@global.innodb_redo_log_encrypt in (0, 1)
7 1
8 select @@global.innodb_redo_log_encrypt;
9 @@global.innodb_redo_log_encrypt
10 0
11 select @@session.innodb_redo_log_encrypt;
12 ERROR HY000: Variable 'innodb_redo_log_encrypt' is a GLOBAL variable
13 show global variables like 'innodb_redo_log_encrypt';
14 Variable_name Value
15 innodb_redo_log_encrypt OFF
16 show session variables like 'innodb_redo_log_encrypt';
17 Variable_name Value
18 innodb_redo_log_encrypt OFF
19 select * from performance_schema.global_variables where variable_name='innodb_redo_log_encrypt';
20 VARIABLE_NAME VARIABLE_VALUE
21 innodb_redo_log_encrypt OFF
22 select * from performance_schema.session_variables where variable_name='innodb_redo_log_encrypt';
23 VARIABLE_NAME VARIABLE_VALUE
24 innodb_redo_log_encrypt OFF
25 set global innodb_redo_log_encrypt=1;
26 select * from performance_schema.global_variables where variable_name='innodb_redo_log_encrypt';
27 VARIABLE_NAME VARIABLE_VALUE
28 innodb_redo_log_encrypt OFF
29 select * from performance_schema.session_variables where variable_name='innodb_redo_log_encrypt';
30 VARIABLE_NAME VARIABLE_VALUE
31 innodb_redo_log_encrypt OFF
32 set @@global.innodb_redo_log_encrypt=0;
33 select @@global.innodb_redo_log_encrypt;
34 @@global.innodb_redo_log_encrypt
35 0
36 select * from performance_schema.global_variables where variable_name='innodb_redo_log_encrypt';
37 VARIABLE_NAME VARIABLE_VALUE
38 innodb_redo_log_encrypt OFF
39 select * from performance_schema.session_variables where variable_name='innodb_redo_log_encrypt';
40 VARIABLE_NAME VARIABLE_VALUE
41 innodb_redo_log_encrypt OFF
42 set session innodb_redo_log_encrypt='some';
43 ERROR HY000: Variable 'innodb_redo_log_encrypt' is a GLOBAL variable and should be set with SET GLOBAL
44 set @@session.innodb_redo_log_encrypt='some';
45 ERROR HY000: Variable 'innodb_redo_log_encrypt' is a GLOBAL variable and should be set with SET GLOBAL
46 set global innodb_redo_log_encrypt=1.1;
47 ERROR 42000: Incorrect argument type to variable 'innodb_redo_log_encrypt'
48 set global innodb_redo_log_encrypt='foo';
49 ERROR 42000: Variable 'innodb_redo_log_encrypt' can't be set to the value of 'foo'
50 set global innodb_redo_log_encrypt=-2;
51 ERROR 42000: Variable 'innodb_redo_log_encrypt' can't be set to the value of '-2'
52 set global innodb_redo_log_encrypt=1e1;
53 ERROR 42000: Incorrect argument type to variable 'innodb_redo_log_encrypt'
54 set global innodb_redo_log_encrypt=2;
55 ERROR 42000: Variable 'innodb_redo_log_encrypt' can't be set to the value of '2'
56 SET @@global.innodb_redo_log_encrypt = @start_global_value;
57 SELECT @@global.innodb_redo_log_encrypt;
58 @@global.innodb_redo_log_encrypt
59 0