Debian Codegraph @

mysql-test/suite/sys_vars/r/profiling_basic.result

raw
1 SET @start_global_value = @@global.profiling;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.profiling;
6 @@global.profiling
7 0
8 select @@session.profiling;
9 @@session.profiling
10 0
11 show global variables like 'profiling';
12 Variable_name Value
13 profiling OFF
14 show session variables like 'profiling';
15 Variable_name Value
16 profiling OFF
17 select * from information_schema.global_variables where variable_name='profiling';
18 VARIABLE_NAME VARIABLE_VALUE
19 PROFILING OFF
20 select * from information_schema.session_variables where variable_name='profiling';
21 VARIABLE_NAME VARIABLE_VALUE
22 PROFILING OFF
23 set global profiling=1;
24 set session profiling=ON;
25 select @@global.profiling;
26 @@global.profiling
27 1
28 select @@session.profiling;
29 @@session.profiling
30 1
31 show global variables like 'profiling';
32 Variable_name Value
33 profiling ON
34 show session variables like 'profiling';
35 Variable_name Value
36 profiling ON
37 select * from information_schema.global_variables where variable_name='profiling';
38 VARIABLE_NAME VARIABLE_VALUE
39 PROFILING ON
40 select * from information_schema.session_variables where variable_name='profiling';
41 VARIABLE_NAME VARIABLE_VALUE
42 PROFILING ON
43 set global profiling=0;
44 set session profiling=OFF;
45 select @@global.profiling;
46 @@global.profiling
47 0
48 select @@session.profiling;
49 @@session.profiling
50 0
51 show global variables like 'profiling';
52 Variable_name Value
53 profiling OFF
54 show session variables like 'profiling';
55 Variable_name Value
56 profiling OFF
57 select * from information_schema.global_variables where variable_name='profiling';
58 VARIABLE_NAME VARIABLE_VALUE
59 PROFILING OFF
60 select * from information_schema.session_variables where variable_name='profiling';
61 VARIABLE_NAME VARIABLE_VALUE
62 PROFILING OFF
63 set global profiling=1.1;
64 ERROR 42000: Incorrect argument type to variable 'profiling'
65 set global profiling=1e1;
66 ERROR 42000: Incorrect argument type to variable 'profiling'
67 set global profiling="foo";
68 ERROR 42000: Variable 'profiling' can't be set to the value of 'foo'
69 SET @@global.profiling = @start_global_value;
70 SELECT @@global.profiling;
71 @@global.profiling
72 0