Debian Codegraph @

mysql-test/suite/sys_vars/r/optimizer_trace_features_basic.result

raw
1 SET @start_global_value = @@global.optimizer_trace_features;
2 SELECT @start_global_value;
3 @start_global_value
4 greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
5 select @@global.optimizer_trace_features;
6 @@global.optimizer_trace_features
7 greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
8 select @@session.optimizer_trace_features;
9 @@session.optimizer_trace_features
10 greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
11 show global variables like 'optimizer_trace_features';
12 Variable_name Value
13 optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
14 show session variables like 'optimizer_trace_features';
15 Variable_name Value
16 optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
17 select * from performance_schema.global_variables where variable_name='optimizer_trace_features';
18 VARIABLE_NAME VARIABLE_VALUE
19 optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
20 select * from performance_schema.session_variables where variable_name='optimizer_trace_features';
21 VARIABLE_NAME VARIABLE_VALUE
22 optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
23 set global optimizer_trace_features=2;
24 select @@global.optimizer_trace_features;
25 @@global.optimizer_trace_features
26 greedy_search=off,range_optimizer=on,dynamic_range=off,repeated_subselect=off
27 set session optimizer_trace_features=2;
28 select @@session.optimizer_trace_features;
29 @@session.optimizer_trace_features
30 greedy_search=off,range_optimizer=on,dynamic_range=off,repeated_subselect=off
31 set global optimizer_trace_features=0;
32 select @@global.optimizer_trace_features;
33 @@global.optimizer_trace_features
34 greedy_search=off,range_optimizer=off,dynamic_range=off,repeated_subselect=off
35 set session optimizer_trace_features=0;
36 select @@session.optimizer_trace_features;
37 @@session.optimizer_trace_features
38 greedy_search=off,range_optimizer=off,dynamic_range=off,repeated_subselect=off
39 set session optimizer_trace_features=default;
40 select @@session.optimizer_trace_features;
41 @@session.optimizer_trace_features
42 greedy_search=off,range_optimizer=off,dynamic_range=off,repeated_subselect=off
43 set global optimizer_trace_features=1.1;
44 ERROR 42000: Incorrect argument type to variable 'optimizer_trace_features'
45 set global optimizer_trace_features=1e1;
46 ERROR 42000: Incorrect argument type to variable 'optimizer_trace_features'
47 set session optimizer_trace_features="foobar";
48 ERROR 42000: Variable 'optimizer_trace_features' can't be set to the value of 'foobar'
49 SET @@global.optimizer_trace_features = @start_global_value;
50 SELECT @@global.optimizer_trace_features;
51 @@global.optimizer_trace_features
52 greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on