Debian Codegraph @

mysql-test/suite/sys_vars/t/aria_log_dir_path_basic.test

raw
1 --source include/have_maria.inc
2
3 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
4 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
5 SET @@GLOBAL.aria_log_dir_path=1;
6
7 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
8
9
10 SELECT @@GLOBAL.aria_log_dir_path = VARIABLE_VALUE
11 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
12 WHERE VARIABLE_NAME='aria_log_dir_path';
13
14 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
15
16 SELECT COUNT(VARIABLE_VALUE)
17 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
18 WHERE VARIABLE_NAME='aria_log_dir_path';
19
20
21 SELECT @@aria_log_dir_path = @@GLOBAL.aria_log_dir_path;
22
23
24 SELECT COUNT(@@aria_log_dir_path);
25
26 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 SELECT COUNT(@@local.aria_log_dir_path);
28
29 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 SELECT COUNT(@@SESSION.aria_log_dir_path);
31
32 SELECT COUNT(@@GLOBAL.aria_log_dir_path);
33
34 --Error ER_BAD_FIELD_ERROR
35 SELECT aria_log_dir_path = @@SESSION.aria_log_dir_path;