Debian Codegraph @

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

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