Debian Codegraph @

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

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