Debian Codegraph @

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

raw
1 --source include/have_optimizer_trace.inc
2
3 # test that --maximum-optimizer-trace-offset caps values as intended
4
5 set session optimizer_trace_offset=10;
6 select @@session.optimizer_trace_offset;
7 show session variables like 'optimizer_trace_offset';
8
9 set session optimizer_trace_offset=-10;
10 select @@session.optimizer_trace_offset;
11 show session variables like 'optimizer_trace_offset';
12
13 set session optimizer_trace_offset=100;
14 select @@session.optimizer_trace_offset;
15 show session variables like 'optimizer_trace_offset';
16
17 set session optimizer_trace_offset=-100;
18 select @@session.optimizer_trace_offset;
19 show session variables like 'optimizer_trace_offset';