Debian Codegraph @

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

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