Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.optimizer_prune_level;
2 SELECT @start_global_value;
3 @start_global_value
4 2
5 SET @start_session_value = @@session.optimizer_prune_level;
6 SELECT @start_session_value;
7 @start_session_value
8 2
9 '#--------------------FN_DYNVARS_115_01-------------------------#'
10 SET @@global.optimizer_prune_level = 0;
11 SET @@global.optimizer_prune_level = DEFAULT;
12 SELECT @@global.optimizer_prune_level;
13 @@global.optimizer_prune_level
14 2
15 SET @@session.optimizer_prune_level = 0;
16 SET @@session.optimizer_prune_level = DEFAULT;
17 SELECT @@session.optimizer_prune_level;
18 @@session.optimizer_prune_level
19 2
20 '#--------------------FN_DYNVARS_115_02-------------------------#'
21 SET @@global.optimizer_prune_level = DEFAULT;
22 SELECT @@global.optimizer_prune_level = 2;
23 @@global.optimizer_prune_level = 2
24 1
25 SET @@session.optimizer_prune_level = DEFAULT;
26 SELECT @@session.optimizer_prune_level = 2;
27 @@session.optimizer_prune_level = 2
28 1
29 '#--------------------FN_DYNVARS_115_03-------------------------#'
30 SELECT @@global.optimizer_prune_level;
31 @@global.optimizer_prune_level
32 2
33 SET @@global.optimizer_prune_level = 0;
34 SELECT @@global.optimizer_prune_level;
35 @@global.optimizer_prune_level
36 0
37 SET @@global.optimizer_prune_level = 1;
38 SELECT @@global.optimizer_prune_level;
39 @@global.optimizer_prune_level
40 1
41 SET @@global.optimizer_prune_level = 2;
42 SELECT @@global.optimizer_prune_level;
43 @@global.optimizer_prune_level
44 2
45 SET @@global.optimizer_prune_level = TRUE;
46 SELECT @@global.optimizer_prune_level;
47 @@global.optimizer_prune_level
48 1
49 SET @@global.optimizer_prune_level = FALSE;
50 SELECT @@global.optimizer_prune_level;
51 @@global.optimizer_prune_level
52 0
53 '#--------------------FN_DYNVARS_115_04-------------------------#'
54 SELECT @@session.optimizer_prune_level;
55 @@session.optimizer_prune_level
56 2
57 SET @@session.optimizer_prune_level = 0;
58 SELECT @@session.optimizer_prune_level;
59 @@session.optimizer_prune_level
60 0
61 SET @@session.optimizer_prune_level = 1;
62 SELECT @@session.optimizer_prune_level;
63 @@session.optimizer_prune_level
64 1
65 SET @@session.optimizer_prune_level = 2;
66 SELECT @@session.optimizer_prune_level;
67 @@session.optimizer_prune_level
68 2
69 SET @@session.optimizer_prune_level = TRUE;
70 SELECT @@session.optimizer_prune_level;
71 @@session.optimizer_prune_level
72 1
73 SET @@session.optimizer_prune_level = FALSE;
74 SELECT @@session.optimizer_prune_level;
75 @@session.optimizer_prune_level
76 0
77 '#------------------FN_DYNVARS_115_05-----------------------#'
78 SET @@global.optimizer_prune_level = ON;
79 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
80 'Bug# 34840: Since it is not a boolean variable, it should give errors on 'ON' & 'OFF' values';
81 SET @@global.optimizer_prune_level = OFF;
82 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
83 SET @@global.optimizer_prune_level = 'ONN';
84 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
85 SET @@global.optimizer_prune_level = "OFFF";
86 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
87 SET @@global.optimizer_prune_level = TTRUE;
88 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
89 SET @@global.optimizer_prune_level = FELSE;
90 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
91 SET @@global.optimizer_prune_level = -1024;
92 Warnings:
93 Warning 1292 Truncated incorrect optimizer_prune_level value: '-1024'
94 SELECT @@global.optimizer_prune_level;
95 @@global.optimizer_prune_level
96 0
97 'Bug# 34840: Since it is not a boolean variable, it should no give errors on numeric values';
98 SET @@global.optimizer_prune_level = 65536;
99 Warnings:
100 Warning 1292 Truncated incorrect optimizer_prune_level value: '65536'
101 SET @@global.optimizer_prune_level = 3;
102 Warnings:
103 Warning 1292 Truncated incorrect optimizer_prune_level value: '3'
104 select @@global.optimizer_prune_level;
105 @@global.optimizer_prune_level
106 2
107 SET @@global.optimizer_prune_level = 65530.34;
108 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
109 SET @@global.optimizer_prune_level = test;
110 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
111 SET @@session.optimizer_prune_level = ON;
112 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
113 SET @@session.optimizer_prune_level = OFF;
114 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
115 SET @@session.optimizer_prune_level = ONN;
116 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
117 SET @@session.optimizer_prune_level = ONF;
118 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
119 SET @@session.optimizer_prune_level = ON;
120 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
121 SET @@session.optimizer_prune_level = OF;
122 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
123 SET @@session.optimizer_prune_level = 'OFN';
124 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
125 SET @@session.optimizer_prune_level = -2;
126 Warnings:
127 Warning 1292 Truncated incorrect optimizer_prune_level value: '-2'
128 SELECT @@session.optimizer_prune_level;
129 @@session.optimizer_prune_level
130 0
131 SET @@session.optimizer_prune_level = 65530.34;
132 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
133 SET @@session.optimizer_prune_level = 65550;
134 Warnings:
135 Warning 1292 Truncated incorrect optimizer_prune_level value: '65550'
136 SELECT @@session.optimizer_prune_level;
137 @@session.optimizer_prune_level
138 2
139 SET @@session.optimizer_prune_level = test;
140 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
141 '#------------------FN_DYNVARS_115_06-----------------------#'
142 SELECT @@global.optimizer_prune_level = VARIABLE_VALUE
143 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
144 WHERE VARIABLE_NAME='optimizer_prune_level';
145 @@global.optimizer_prune_level = VARIABLE_VALUE
146 1
147 '#------------------FN_DYNVARS_115_07-----------------------#'
148 SELECT @@session.optimizer_prune_level = VARIABLE_VALUE
149 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
150 WHERE VARIABLE_NAME='optimizer_prune_level';
151 @@session.optimizer_prune_level = VARIABLE_VALUE
152 1
153 '#---------------------FN_DYNVARS_115_08----------------------#'
154 SET @@optimizer_prune_level = 0;
155 SET @@global.optimizer_prune_level = 1;
156 SELECT @@optimizer_prune_level = @@global.optimizer_prune_level;
157 @@optimizer_prune_level = @@global.optimizer_prune_level
158 0
159 '#---------------------FN_DYNVARS_115_09----------------------#'
160 SET @@optimizer_prune_level = 1;
161 SELECT @@optimizer_prune_level = @@local.optimizer_prune_level;
162 @@optimizer_prune_level = @@local.optimizer_prune_level
163 1
164 SELECT @@local.optimizer_prune_level = @@session.optimizer_prune_level;
165 @@local.optimizer_prune_level = @@session.optimizer_prune_level
166 1
167 '#---------------------FN_DYNVARS_115_10----------------------#'
168 SET optimizer_prune_level = 1;
169 SELECT @@optimizer_prune_level;
170 @@optimizer_prune_level
171 1
172 SELECT local.optimizer_prune_level;
173 ERROR 42S02: Unknown table 'local' in SELECT
174 SELECT session.optimizer_prune_level;
175 ERROR 42S02: Unknown table 'session' in SELECT
176 SELECT optimizer_prune_level = @@session.optimizer_prune_level;
177 ERROR 42S22: Unknown column 'optimizer_prune_level' in 'SELECT'
178 SET @@global.optimizer_prune_level = @start_global_value;
179 SELECT @@global.optimizer_prune_level;
180 @@global.optimizer_prune_level
181 2
182 SET @@session.optimizer_prune_level = @start_session_value;
183 SELECT @@session.optimizer_prune_level;
184 @@session.optimizer_prune_level
185 2