Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_encrypt_tables;
2 select @@global.innodb_encrypt_tables;
3 @@global.innodb_encrypt_tables
4 OFF
5 select @@session.innodb_encrypt_tables;
6 ERROR HY000: Variable 'innodb_encrypt_tables' is a GLOBAL variable
7 show global variables like 'innodb_encrypt_tables';
8 Variable_name Value
9 innodb_encrypt_tables OFF
10 show session variables like 'innodb_encrypt_tables';
11 Variable_name Value
12 innodb_encrypt_tables OFF
13 select * from information_schema.global_variables
14 where variable_name='innodb_encrypt_tables';
15 VARIABLE_NAME VARIABLE_VALUE
16 INNODB_ENCRYPT_TABLES OFF
17 select * from information_schema.session_variables
18 where variable_name='innodb_encrypt_tables';
19 VARIABLE_NAME VARIABLE_VALUE
20 INNODB_ENCRYPT_TABLES OFF
21 set global innodb_encrypt_tables=ON;
22 ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of 'ON'
23 show warnings;
24 Level Code Message
25 Warning 138 InnoDB: cannot enable encryption, encryption plugin is not available
26 Error 1231 Variable 'innodb_encrypt_tables' can't be set to the value of 'ON'
27 select @@global.innodb_encrypt_tables;
28 @@global.innodb_encrypt_tables
29 OFF
30 set global innodb_encrypt_tables=OFF;
31 select @@global.innodb_encrypt_tables;
32 @@global.innodb_encrypt_tables
33 OFF
34 set global innodb_encrypt_tables=1;
35 ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of '1'
36 select @@global.innodb_encrypt_tables;
37 @@global.innodb_encrypt_tables
38 OFF
39 set session innodb_encrypt_tables=1;
40 ERROR HY000: Variable 'innodb_encrypt_tables' is a GLOBAL variable and should be set with SET GLOBAL
41 set global innodb_encrypt_tables=1.1;
42 ERROR 42000: Incorrect argument type to variable 'innodb_encrypt_tables'
43 set global innodb_encrypt_tables=1e1;
44 ERROR 42000: Incorrect argument type to variable 'innodb_encrypt_tables'
45 set global innodb_encrypt_tables="foo";
46 ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of 'foo'
47 SET @@global.innodb_encrypt_tables = @start_global_value;