Debian Codegraph @

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

raw
1 --source include/have_optimizer_trace.inc
2
3 # Basic read/write test.
4 # Functionality of this variable is covered in
5 # main.optimizer_trace*.test
6
7 SELECT @@global.optimizer_trace_offset;
8 SET @@global.optimizer_trace_offset=5;
9 show global variables like 'optimizer_trace_offset';
10 --disable_warnings
11 select * from performance_schema.global_variables where variable_name='optimizer_trace_offset';
12 --enable_warnings
13
14 select @@session.optimizer_trace_offset;
15 show session variables like 'optimizer_trace_offset';
16 --disable_warnings
17 select * from performance_schema.session_variables where variable_name='optimizer_trace_offset';
18 --enable_warnings
19
20 #
21 # show that it's writable
22 #
23 set session optimizer_trace_offset=10;
24 select @@session.optimizer_trace_offset;
25 show session variables like 'optimizer_trace_offset';
26
27 set session optimizer_trace_offset=0;
28 select @@session.optimizer_trace_offset;
29 show session variables like 'optimizer_trace_offset';
30
31 set session optimizer_trace_offset=-100;
32 select @@session.optimizer_trace_offset;
33 show session variables like 'optimizer_trace_offset';
34
35 # 32-bit big values should be accepted on all platforms
36 set session optimizer_trace_offset=2000000000;
37 select @@session.optimizer_trace_offset;
38 show session variables like 'optimizer_trace_offset';
39
40 set session optimizer_trace_offset=-2000000000;
41 select @@session.optimizer_trace_offset;
42 show session variables like 'optimizer_trace_offset';
43
44 set session optimizer_trace_offset=default;
45 select @@session.optimizer_trace_offset;
46 show session variables like 'optimizer_trace_offset';
47
48 set global optimizer_trace_offset=default;
49 select @@global.optimizer_trace_offset;
50 show global variables like 'optimizer_trace_offset';
51
52 #
53 # incorrect assignments
54 #
55 --error ER_WRONG_TYPE_FOR_VAR
56 set optimizer_trace_offset=1.1;
57 --error ER_WRONG_TYPE_FOR_VAR
58 set optimizer_trace_offset="foobar";