Debian Codegraph @

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

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