Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-20 OBN - Added check for I_S values after variable value change
4 #
5
6 --source include/have_profiling.inc
7
8 SET @start_global_value = @@global.profiling;
9 SELECT @start_global_value;
10
11 #
12 # exists as global and session
13 #
14 select @@global.profiling;
15 select @@session.profiling;
16 show global variables like 'profiling';
17 show session variables like 'profiling';
18 --disable_warnings
19 select * from performance_schema.global_variables where variable_name='profiling';
20 select * from performance_schema.session_variables where variable_name='profiling';
21 --enable_warnings
22
23 #
24 # show that it's writable
25 #
26 set global profiling=1;
27 set session profiling=ON;
28 select @@global.profiling;
29 select @@session.profiling;
30 show global variables like 'profiling';
31 show session variables like 'profiling';
32 --disable_warnings
33 select * from performance_schema.global_variables where variable_name='profiling';
34 select * from performance_schema.session_variables where variable_name='profiling';
35 --enable_warnings
36 set global profiling=0;
37 set session profiling=OFF;
38 select @@global.profiling;
39 select @@session.profiling;
40 show global variables like 'profiling';
41 show session variables like 'profiling';
42 --disable_warnings
43 select * from performance_schema.global_variables where variable_name='profiling';
44 select * from performance_schema.session_variables where variable_name='profiling';
45 --enable_warnings
46
47 #
48 # incorrect types
49 #
50 --error ER_WRONG_TYPE_FOR_VAR
51 set global profiling=1.1;
52 --error ER_WRONG_TYPE_FOR_VAR
53 set global profiling=1e1;
54 --error ER_WRONG_VALUE_FOR_VAR
55 set global profiling="foo";
56
57 SET @@global.profiling = @start_global_value;
58 SELECT @@global.profiling;