Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_encryption_rotate_key_age;
2 select @@global.innodb_encryption_rotate_key_age;
3 @@global.innodb_encryption_rotate_key_age
4 1
5 select @@session.innodb_encryption_rotate_key_age;
6 ERROR HY000: Variable 'innodb_encryption_rotate_key_age' is a GLOBAL variable
7 show global variables like 'innodb_encryption_rotate_key_age';
8 Variable_name Value
9 innodb_encryption_rotate_key_age 1
10 show session variables like 'innodb_encryption_rotate_key_age';
11 Variable_name Value
12 innodb_encryption_rotate_key_age 1
13 select * from information_schema.global_variables
14 where variable_name='innodb_encryption_rotate_key_age';
15 VARIABLE_NAME VARIABLE_VALUE
16 INNODB_ENCRYPTION_ROTATE_KEY_AGE 1
17 select * from information_schema.session_variables
18 where variable_name='innodb_encryption_rotate_key_age';
19 VARIABLE_NAME VARIABLE_VALUE
20 INNODB_ENCRYPTION_ROTATE_KEY_AGE 1
21 set global innodb_encryption_rotate_key_age=1;
22 select @@global.innodb_encryption_rotate_key_age;
23 @@global.innodb_encryption_rotate_key_age
24 1
25 set global innodb_encryption_rotate_key_age=2;
26 select @@global.innodb_encryption_rotate_key_age;
27 @@global.innodb_encryption_rotate_key_age
28 2
29 set global innodb_encryption_rotate_key_age=1;
30 select @@global.innodb_encryption_rotate_key_age;
31 @@global.innodb_encryption_rotate_key_age
32 1
33 set session innodb_encryption_rotate_key_age=1;
34 ERROR HY000: Variable 'innodb_encryption_rotate_key_age' is a GLOBAL variable and should be set with SET GLOBAL
35 set global innodb_encryption_rotate_key_age=1.1;
36 ERROR 42000: Incorrect argument type to variable 'innodb_encryption_rotate_key_age'
37 set global innodb_encryption_rotate_key_age=1e1;
38 ERROR 42000: Incorrect argument type to variable 'innodb_encryption_rotate_key_age'
39 set global innodb_encryption_rotate_key_age="foo";
40 ERROR 42000: Incorrect argument type to variable 'innodb_encryption_rotate_key_age'
41 SET @@global.innodb_encryption_rotate_key_age = @start_global_value;