Debian Codegraph @

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

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