Debian Codegraph @

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

raw
1 # Only supported on Linux
2 --source include/linux.inc
3
4 SELECT COUNT(@@GLOBAL.build_id);
5
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 SET @@GLOBAL.build_id=1;
8
9 SELECT COUNT(@@GLOBAL.build_id);
10
11 --disable_warnings
12 SELECT @@GLOBAL.build_id = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='build_id';
15 --enable_warnings
16
17 SELECT COUNT(@@GLOBAL.build_id);
18
19 --disable_warnings
20 SELECT COUNT(VARIABLE_VALUE)
21 FROM performance_schema.global_variables
22 WHERE VARIABLE_NAME='build_id';
23 --enable_warnings
24
25 SELECT @@build_id = @@GLOBAL.datadir;
26
27 SELECT COUNT(@@build_id);
28
29 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 SELECT COUNT(@@local.build_id);
31
32 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
33 SELECT COUNT(@@SESSION.build_id);
34
35 SELECT COUNT(@@GLOBAL.build_id);