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 --disable_warnings
12 --replace_column 2 #
13 select * from performance_schema.global_variables where variable_name='have_profiling';
14 --replace_column 2 #
15 select * from performance_schema.session_variables where variable_name='have_profiling';
16 --enable_warnings
17
18 #
19 # show that it's read-only
20 #
21 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
22 set global have_profiling=1;
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 set session have_profiling=1;
25