Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-20 OBN Added check for I_S values after variable value changed
4 #
5
6 SET @start_global_value = @@global.optimizer_switch;
7 SELECT @start_global_value;
8
9 #
10 # exists as global and session
11 #
12 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
13 select @@global.optimizer_switch;
14 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
15 select @@session.optimizer_switch;
16 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
17 show global variables like 'optimizer_switch';
18 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
19 show session variables like 'optimizer_switch';
20 --disable_warnings
21 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
22 select * from performance_schema.global_variables where variable_name='optimizer_switch';
23 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
24 select * from performance_schema.session_variables where variable_name='optimizer_switch';
25 --enable_warnings
26
27 #
28 # show that it's writable
29 #
30 set global optimizer_switch=10;
31 set session optimizer_switch=5;
32 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
33 select @@global.optimizer_switch;
34 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
35 select @@session.optimizer_switch;
36 set global optimizer_switch="index_merge_sort_union=on";
37 set session optimizer_switch="index_merge=off";
38 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
39 select @@global.optimizer_switch;
40 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
41 select @@session.optimizer_switch;
42 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
43 show global variables like 'optimizer_switch';
44 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
45 show session variables like 'optimizer_switch';
46 --disable_warnings
47 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
48 select * from performance_schema.global_variables where variable_name='optimizer_switch';
49 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
50 select * from performance_schema.session_variables where variable_name='optimizer_switch';
51 --enable_warnings
52 set session optimizer_switch="default";
53 --replace_result hypergraph_optimizer=on hypergraph_optimizer=off
54 select @@session.optimizer_switch;
55
56 #
57 # incorrect assignments
58 #
59 --error ER_WRONG_TYPE_FOR_VAR
60 set global optimizer_switch=1.1;
61 --error ER_WRONG_TYPE_FOR_VAR
62 set global optimizer_switch=1e1;
63 --error ER_WRONG_VALUE_FOR_VAR
64 set session optimizer_switch="index_merge";
65 --error ER_WRONG_VALUE_FOR_VAR
66 set session optimizer_switch="foobar";
67
68 --echo #
69 --echo # Bug#59894 set optimizer_switch to e or d causes invalid
70 --echo # memory writes/valgrind warnings
71 --echo
72 set global optimizer_switch = 'def'; # means default
73 --error ER_WRONG_VALUE_FOR_VAR
74 set global optimizer_switch = 'e';
75
76 --echo #
77 --echo # Bug#31326120 UBSAN:
78 --echo # SHIFT EXPONENT 4294967294 IS TOO LARGE FOR 64-BIT TYPE
79
80 --error ER_WRONG_VALUE_FOR_VAR
81 set optimizer_switch ='b';
82
83 --error ER_WRONG_VALUE_FOR_VAR
84 set optimizer_switch = 0x6400ec62;
85
86 SET @@global.optimizer_switch = @start_global_value;
87 SELECT @@global.optimizer_switch;