Debian Codegraph @

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

raw
1 --source include/have_optimizer_trace.inc
2
3 SET @start_global_value = @@global.optimizer_trace;
4 SELECT @start_global_value;
5
6 #
7 # exists as global and session
8 #
9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
11 show global variables like 'optimizer_trace';
12 show session variables like 'optimizer_trace';
13 --disable_warnings
14 select * from performance_schema.global_variables where variable_name='optimizer_trace';
15 select * from performance_schema.session_variables where variable_name='optimizer_trace';
16 --enable_warnings
17
18 #
19 # show that it's writable
20 #
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
28 select @@session.optimizer_trace;
29 set session optimizer_trace=default;
30 select @@session.optimizer_trace;
31
32 #
33 # incorrect assignments
34 #
35 --error ER_WRONG_TYPE_FOR_VAR
36 set global optimizer_trace=1.1;
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global optimizer_trace=1e1;
39 --error ER_WRONG_VALUE_FOR_VAR
40 set session optimizer_trace="foobar";
41
42 SET @@global.optimizer_trace = @start_global_value;
43 SELECT @@global.optimizer_trace;