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 select * from information_schema.global_variables where variable_name='profiling';
19 select * from information_schema.session_variables where variable_name='profiling';
20
21 #
22 # show that it's writable
23 #
24 set global profiling=1;
25 set session profiling=ON;
26 select @@global.profiling;
27 select @@session.profiling;
28 show global variables like 'profiling';
29 show session variables like 'profiling';
30 select * from information_schema.global_variables where variable_name='profiling';
31 select * from information_schema.session_variables where variable_name='profiling';
32 set global profiling=0;
33 set session profiling=OFF;
34 select @@global.profiling;
35 select @@session.profiling;
36 show global variables like 'profiling';
37 show session variables like 'profiling';
38 select * from information_schema.global_variables where variable_name='profiling';
39 select * from information_schema.session_variables where variable_name='profiling';
40
41 #
42 # incorrect types
43 #
44 --error ER_WRONG_TYPE_FOR_VAR
45 set global profiling=1.1;
46 --error ER_WRONG_TYPE_FOR_VAR
47 set global profiling=1e1;
48 --error ER_WRONG_VALUE_FOR_VAR
49 set global profiling="foo";
50
51 SET @@global.profiling = @start_global_value;
52 SELECT @@global.profiling;