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