Debian Codegraph @

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

raw
1 set session optimizer_trace_offset=10;
2 select @@session.optimizer_trace_offset;
3 @@session.optimizer_trace_offset
4 10
5 show session variables like 'optimizer_trace_offset';
6 Variable_name Value
7 optimizer_trace_offset 10
8 set session optimizer_trace_offset=-10;
9 select @@session.optimizer_trace_offset;
10 @@session.optimizer_trace_offset
11 -10
12 show session variables like 'optimizer_trace_offset';
13 Variable_name Value
14 optimizer_trace_offset -10
15 set session optimizer_trace_offset=100;
16 Warnings:
17 Warning 1292 Truncated incorrect optimizer_trace_offset value: '100'
18 select @@session.optimizer_trace_offset;
19 @@session.optimizer_trace_offset
20 50
21 show session variables like 'optimizer_trace_offset';
22 Variable_name Value
23 optimizer_trace_offset 50
24 set session optimizer_trace_offset=-100;
25 Warnings:
26 Warning 1292 Truncated incorrect optimizer_trace_offset value: '-100'
27 select @@session.optimizer_trace_offset;
28 @@session.optimizer_trace_offset
29 -50
30 show session variables like 'optimizer_trace_offset';
31 Variable_name Value
32 optimizer_trace_offset -50