Debian Codegraph @

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

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