Debian Codegraph @

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

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