Debian Codegraph @

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

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