Debian Codegraph @

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

raw
1
2 #
3 # Only global
4 #
5 select @@global.performance_schema_show_processlist into @save;
6 select @@global.performance_schema_show_processlist;
7
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.performance_schema_show_processlist;
10
11 show global variables like 'performance_schema_show_processlist';
12
13 show session variables like 'performance_schema_show_processlist';
14
15 --disable_warnings
16 select * from performance_schema.global_variables
17 where variable_name='performance_schema_show_processlist';
18
19 select * from performance_schema.session_variables
20 where variable_name='performance_schema_show_processlist';
21 --enable_warnings
22
23 #
24 # Wrong value
25 #
26 --Error ER_WRONG_VALUE_FOR_VAR
27 set global performance_schema_show_processlist = 99;
28
29 --Error ER_WRONG_VALUE_FOR_VAR
30 set global performance_schema_show_processlist = 'FOO';
31
32 #
33 # Right value
34 #
35 set global performance_schema_show_processlist = 1;
36 select @@global.performance_schema_show_processlist;
37
38 set global performance_schema_show_processlist = 0;
39 select @@global.performance_schema_show_processlist;
40
41 set global performance_schema_show_processlist = ON;
42 select @@global.performance_schema_show_processlist;
43
44 set global performance_schema_show_processlist = OFF;
45 select @@global.performance_schema_show_processlist;
46
47 set global performance_schema_show_processlist = TRUE;
48 select @@global.performance_schema_show_processlist;
49
50 set global performance_schema_show_processlist = FALSE;
51 select @@global.performance_schema_show_processlist;
52
53 set @@global.performance_schema_show_processlist = @save;