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