Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
2 COUNT(@@GLOBAL.aria_log_dir_path)
3 1
4 SET @@GLOBAL.aria_log_dir_path=1;
5 ERROR HY000: Variable 'aria_log_dir_path' is a read only variable
6 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
7 COUNT(@@GLOBAL.aria_log_dir_path)
8 1
9 SELECT @@GLOBAL.aria_log_dir_path = VARIABLE_VALUE
10 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
11 WHERE VARIABLE_NAME='aria_log_dir_path';
12 @@GLOBAL.aria_log_dir_path = VARIABLE_VALUE
13 1
14 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
15 COUNT(@@GLOBAL.aria_log_dir_path)
16 1
17 SELECT COUNT(VARIABLE_VALUE)
18 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
19 WHERE VARIABLE_NAME='aria_log_dir_path';
20 COUNT(VARIABLE_VALUE)
21 1
22 SELECT @@aria_log_dir_path = @@GLOBAL.aria_log_dir_path;
23 @@aria_log_dir_path = @@GLOBAL.aria_log_dir_path
24 1
25 SELECT COUNT(@@aria_log_dir_path);
26 COUNT(@@aria_log_dir_path)
27 1
28 SELECT COUNT(@@local.aria_log_dir_path);
29 ERROR HY000: Variable 'aria_log_dir_path' is a GLOBAL variable
30 SELECT COUNT(@@SESSION.aria_log_dir_path);
31 ERROR HY000: Variable 'aria_log_dir_path' is a GLOBAL variable
32 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
33 COUNT(@@GLOBAL.aria_log_dir_path)
34 1
35 SELECT aria_log_dir_path = @@SESSION.aria_log_dir_path;
36 ERROR 42S22: Unknown column 'aria_log_dir_path' in 'SELECT'