Debian Codegraph @

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

raw
1 #
2 # only global
3 #
4 select @@global.have_profiling="1";
5 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
6 select @@session.have_profiling;
7 --replace_column 2 #
8 show global variables like 'have_profiling';
9 --replace_column 2 #
10 show session variables like 'have_profiling';
11 --replace_column 2 #
12 select * from information_schema.global_variables where variable_name='have_profiling';
13 --replace_column 2 #
14 select * from information_schema.session_variables where variable_name='have_profiling';
15
16 #
17 # show that it's read-only
18 #
19 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 set global have_profiling=1;
21 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
22 set session have_profiling=1;
23