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