Debian Codegraph @

mysql-test/suite/opt_trace/t/filesort_pack.test

raw
1
2 --source include/have_optimizer_trace.inc
3 --source include/have_64bit.inc
4 --source include/not_hypergraph.inc # Does not output the same optimizer trace.
5
6 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
7 --source include/no_protocol.inc
8
9 SET optimizer_trace_max_mem_size=1048576; # 1MB
10 SET end_markers_in_json=off;
11 SET optimizer_trace="enabled=on,one_line=off";
12
13
14 ## Each column here takes 1022 bytes, plus 2 bytes length field.
15 ## Except the last column, which is one byte shorter.
16 ## Total record size is 65535 which is the MySQL maximum.
17 CREATE TABLE t1 (
18 c1 VARCHAR(1022) NOT NULL DEFAULT '',
19 c2 VARCHAR(1022) NOT NULL DEFAULT '',
20 c3 VARCHAR(1022) NOT NULL DEFAULT '',
21 c4 VARCHAR(1022) NOT NULL DEFAULT '',
22 c5 VARCHAR(1022) NOT NULL DEFAULT '',
23 c6 VARCHAR(1022) NOT NULL DEFAULT '',
24 c7 VARCHAR(1022) NOT NULL DEFAULT '',
25 c8 VARCHAR(1022) NOT NULL DEFAULT '',
26 c9 VARCHAR(1022) NOT NULL DEFAULT '',
27 c10 VARCHAR(1022) NOT NULL DEFAULT '',
28 c11 VARCHAR(1022) NOT NULL DEFAULT '',
29 c12 VARCHAR(1022) NOT NULL DEFAULT '',
30 c13 VARCHAR(1022) NOT NULL DEFAULT '',
31 c14 VARCHAR(1022) NOT NULL DEFAULT '',
32 c15 VARCHAR(1022) NOT NULL DEFAULT '',
33 c16 VARCHAR(1022) NOT NULL DEFAULT '',
34 c17 VARCHAR(1022) NOT NULL DEFAULT '',
35 c18 VARCHAR(1022) NOT NULL DEFAULT '',
36 c19 VARCHAR(1022) NOT NULL DEFAULT '',
37 c20 VARCHAR(1022) NOT NULL DEFAULT '',
38 c21 VARCHAR(1022) NOT NULL DEFAULT '',
39 c22 VARCHAR(1022) NOT NULL DEFAULT '',
40 c23 VARCHAR(1022) NOT NULL DEFAULT '',
41 c24 VARCHAR(1022) NOT NULL DEFAULT '',
42 c25 VARCHAR(1022) NOT NULL DEFAULT '',
43 c26 VARCHAR(1022) NOT NULL DEFAULT '',
44 c27 VARCHAR(1022) NOT NULL DEFAULT '',
45 c28 VARCHAR(1022) NOT NULL DEFAULT '',
46 c29 VARCHAR(1022) NOT NULL DEFAULT '',
47 c30 VARCHAR(1022) NOT NULL DEFAULT '',
48 c31 VARCHAR(1022) NOT NULL DEFAULT '',
49 c32 VARCHAR(1022) NOT NULL DEFAULT '',
50 c33 VARCHAR(1022) NOT NULL DEFAULT '',
51 c34 VARCHAR(1022) NOT NULL DEFAULT '',
52 c35 VARCHAR(1022) NOT NULL DEFAULT '',
53 c36 VARCHAR(1022) NOT NULL DEFAULT '',
54 c37 VARCHAR(1022) NOT NULL DEFAULT '',
55 c38 VARCHAR(1022) NOT NULL DEFAULT '',
56 c39 VARCHAR(1022) NOT NULL DEFAULT '',
57 c40 VARCHAR(1022) NOT NULL DEFAULT '',
58 c41 VARCHAR(1022) NOT NULL DEFAULT '',
59 c42 VARCHAR(1022) NOT NULL DEFAULT '',
60 c43 VARCHAR(1022) NOT NULL DEFAULT '',
61 c44 VARCHAR(1022) NOT NULL DEFAULT '',
62 c45 VARCHAR(1022) NOT NULL DEFAULT '',
63 c46 VARCHAR(1022) NOT NULL DEFAULT '',
64 c47 VARCHAR(1022) NOT NULL DEFAULT '',
65 c48 VARCHAR(1022) NOT NULL DEFAULT '',
66 c49 VARCHAR(1022) NOT NULL DEFAULT '',
67 c50 VARCHAR(1022) NOT NULL DEFAULT '',
68 c51 VARCHAR(1022) NOT NULL DEFAULT '',
69 c52 VARCHAR(1022) NOT NULL DEFAULT '',
70 c53 VARCHAR(1022) NOT NULL DEFAULT '',
71 c54 VARCHAR(1022) NOT NULL DEFAULT '',
72 c55 VARCHAR(1022) NOT NULL DEFAULT '',
73 c56 VARCHAR(1022) NOT NULL DEFAULT '',
74 c57 VARCHAR(1022) NOT NULL DEFAULT '',
75 c58 VARCHAR(1022) NOT NULL DEFAULT '',
76 c59 VARCHAR(1022) NOT NULL DEFAULT '',
77 c60 VARCHAR(1022) NOT NULL DEFAULT '',
78 c61 VARCHAR(1022) NOT NULL DEFAULT '',
79 c62 VARCHAR(1022) NOT NULL DEFAULT '',
80 c63 VARCHAR(1022) NOT NULL DEFAULT '',
81 c64 VARCHAR(1021) NOT NULL DEFAULT ''
82 ) ENGINE = INNODB, charset latin1;
83
84 SET @save_sort_buffer_size= @@sort_buffer_size;
85
86 ## We can use addons, but not packed addons.
87 ## With addon fields, we need larger sort_buffer_size.
88 SET @@sort_buffer_size = 8 + 15 * (65535 + 1022 + 8);
89 select * from t1 order by c1;
90 SELECT * FROM information_schema.OPTIMIZER_TRACE;
91
92 ## We can use addons, but not packed addons.
93 ## With addon fields, we need larger sort_buffer_size.
94 SET @@sort_buffer_size = 8 + 15 * (65535 + 1023 + 8);
95 select * from t1 order by c1;
96 SELECT * FROM information_schema.OPTIMIZER_TRACE;
97
98 ## Here we can use packed addons.
99 ## With addon fields, we need larger sort_buffer_size.
100 SET @@sort_buffer_size = 8 + 15 * (65535 + 1024 + 8);
101 select * from t1 order by c1;
102 SELECT * FROM information_schema.OPTIMIZER_TRACE;
103
104 SET @@sort_buffer_size= @save_sort_buffer_size;
105
106 DROP TABLE t1;
107
108 SET innodb_strict_mode=off;
109 CREATE TABLE t1 (
110 c1 CHAR(255) NOT NULL DEFAULT '',
111 c2 CHAR(255) NOT NULL DEFAULT '',
112 c3 CHAR(255) NOT NULL DEFAULT '',
113 c4 CHAR(255) NOT NULL DEFAULT '',
114 c5 CHAR(255) NOT NULL DEFAULT '',
115 c6 CHAR(255) NOT NULL DEFAULT '',
116 c7 CHAR(255) NOT NULL DEFAULT '',
117 c8 CHAR(255) NOT NULL DEFAULT '',
118 c9 CHAR(255) NOT NULL DEFAULT '',
119 c10 CHAR(255) NOT NULL DEFAULT '',
120 c11 CHAR(255) NOT NULL DEFAULT '',
121 c12 CHAR(255) NOT NULL DEFAULT '',
122 c13 CHAR(255) NOT NULL DEFAULT '',
123 c14 CHAR(255) NOT NULL DEFAULT '',
124 c15 CHAR(255) NOT NULL DEFAULT '',
125 c16 CHAR(255) NOT NULL DEFAULT '',
126 c17 CHAR(255) NOT NULL DEFAULT '',
127 c18 CHAR(255) NOT NULL DEFAULT '',
128 c19 CHAR(255) NOT NULL DEFAULT '',
129 c20 CHAR(255) NOT NULL DEFAULT '',
130 c21 CHAR(255) NOT NULL DEFAULT '',
131 c22 CHAR(255) NOT NULL DEFAULT '',
132 c23 CHAR(255) NOT NULL DEFAULT '',
133 c24 CHAR(255) NOT NULL DEFAULT '',
134 c25 CHAR(255) NOT NULL DEFAULT '',
135 c26 CHAR(255) NOT NULL DEFAULT '',
136 c27 CHAR(255) NOT NULL DEFAULT '',
137 c28 CHAR(255) NOT NULL DEFAULT '',
138 c29 CHAR(255) NOT NULL DEFAULT '',
139 c30 CHAR(255) NOT NULL DEFAULT '',
140 c31 CHAR(255) NOT NULL DEFAULT '',
141 c32 CHAR(255) NOT NULL DEFAULT '',
142 c33 CHAR(255) NOT NULL DEFAULT '',
143 c34 CHAR(255) NOT NULL DEFAULT '',
144 c35 CHAR(255) NOT NULL DEFAULT '',
145 c36 CHAR(255) NOT NULL DEFAULT '',
146 c37 CHAR(255) NOT NULL DEFAULT '',
147 c38 CHAR(255) NOT NULL DEFAULT '',
148 c39 CHAR(255) NOT NULL DEFAULT '',
149 c40 CHAR(255) NOT NULL DEFAULT '',
150 c41 CHAR(255) NOT NULL DEFAULT '',
151 c42 CHAR(255) NOT NULL DEFAULT '',
152 c43 CHAR(255) NOT NULL DEFAULT '',
153 c44 CHAR(255) NOT NULL DEFAULT '',
154 c45 CHAR(255) NOT NULL DEFAULT '',
155 c46 CHAR(255) NOT NULL DEFAULT '',
156 c47 CHAR(255) NOT NULL DEFAULT '',
157 c48 CHAR(255) NOT NULL DEFAULT '',
158 c49 CHAR(255) NOT NULL DEFAULT '',
159 c50 CHAR(255) NOT NULL DEFAULT '',
160 c51 CHAR(255) NOT NULL DEFAULT '',
161 c52 CHAR(255) NOT NULL DEFAULT '',
162 c53 CHAR(255) NOT NULL DEFAULT '',
163 c54 CHAR(255) NOT NULL DEFAULT '',
164 c55 CHAR(255) NOT NULL DEFAULT '',
165 c56 CHAR(255) NOT NULL DEFAULT '',
166 c57 CHAR(255) NOT NULL DEFAULT '',
167 c58 CHAR(255) NOT NULL DEFAULT '',
168 c59 CHAR(255) NOT NULL DEFAULT '',
169 c60 CHAR(255) NOT NULL DEFAULT '',
170 c61 CHAR(255) NOT NULL DEFAULT '',
171 c62 CHAR(255) NOT NULL DEFAULT '',
172 c63 CHAR(255) NOT NULL DEFAULT '',
173 c64 CHAR(255) NOT NULL DEFAULT '',
174 c65 CHAR(255) NOT NULL DEFAULT '',
175 c66 CHAR(255) NOT NULL DEFAULT '',
176 c67 CHAR(255) NOT NULL DEFAULT '',
177 c68 CHAR(255) NOT NULL DEFAULT '',
178 c69 CHAR(255) NOT NULL DEFAULT '',
179 c70 CHAR(255) NOT NULL DEFAULT '',
180 c71 CHAR(255) NOT NULL DEFAULT '',
181 c72 CHAR(255) NOT NULL DEFAULT '',
182 c73 CHAR(255) NOT NULL DEFAULT '',
183 c74 CHAR(255) NOT NULL DEFAULT '',
184 c75 CHAR(255) NOT NULL DEFAULT '',
185 c76 CHAR(255) NOT NULL DEFAULT '',
186 c77 CHAR(255) NOT NULL DEFAULT '',
187 c78 CHAR(255) NOT NULL DEFAULT '',
188 c79 CHAR(255) NOT NULL DEFAULT '',
189 c80 CHAR(255) NOT NULL DEFAULT '',
190 c81 CHAR(255) NOT NULL DEFAULT '',
191 c82 CHAR(255) NOT NULL DEFAULT '',
192 c83 CHAR(255) NOT NULL DEFAULT '',
193 c84 CHAR(255) NOT NULL DEFAULT '',
194 c85 CHAR(255) NOT NULL DEFAULT '',
195 c86 CHAR(255) NOT NULL DEFAULT '',
196 c87 CHAR(255) NOT NULL DEFAULT '',
197 c88 CHAR(255) NOT NULL DEFAULT '',
198 c89 CHAR(255) NOT NULL DEFAULT '',
199 c90 CHAR(255) NOT NULL DEFAULT '',
200 c91 CHAR(255) NOT NULL DEFAULT '',
201 c92 CHAR(255) NOT NULL DEFAULT '',
202 c93 CHAR(255) NOT NULL DEFAULT '',
203 c94 CHAR(255) NOT NULL DEFAULT '',
204 c95 CHAR(255) NOT NULL DEFAULT '',
205 c96 CHAR(255) NOT NULL DEFAULT '',
206 c97 CHAR(255) NOT NULL DEFAULT '',
207 c98 CHAR(255) NOT NULL DEFAULT '',
208 c99 CHAR(255) NOT NULL DEFAULT '',
209 c100 CHAR(255) NOT NULL DEFAULT '',
210 c101 CHAR(255) NOT NULL DEFAULT '',
211 c102 CHAR(255) NOT NULL DEFAULT '',
212 c103 CHAR(255) NOT NULL DEFAULT '',
213 c104 CHAR(255) NOT NULL DEFAULT '',
214 c105 CHAR(255) NOT NULL DEFAULT '',
215 c106 CHAR(255) NOT NULL DEFAULT '',
216 c107 CHAR(255) NOT NULL DEFAULT '',
217 c108 CHAR(255) NOT NULL DEFAULT '',
218 c109 CHAR(255) NOT NULL DEFAULT '',
219 c110 CHAR(255) NOT NULL DEFAULT '',
220 c111 CHAR(255) NOT NULL DEFAULT '',
221 c112 CHAR(255) NOT NULL DEFAULT '',
222 c113 CHAR(255) NOT NULL DEFAULT '',
223 c114 CHAR(255) NOT NULL DEFAULT '',
224 c115 CHAR(255) NOT NULL DEFAULT '',
225 c116 CHAR(255) NOT NULL DEFAULT '',
226 c117 CHAR(255) NOT NULL DEFAULT '',
227 c118 CHAR(255) NOT NULL DEFAULT '',
228 c119 CHAR(255) NOT NULL DEFAULT '',
229 c120 CHAR(255) NOT NULL DEFAULT '',
230 c121 CHAR(255) NOT NULL DEFAULT '',
231 c122 CHAR(255) NOT NULL DEFAULT '',
232 c123 CHAR(255) NOT NULL DEFAULT '',
233 c124 CHAR(255) NOT NULL DEFAULT '',
234 c125 CHAR(255) NOT NULL DEFAULT '',
235 c126 CHAR(255) NOT NULL DEFAULT '',
236 c127 CHAR(255) NOT NULL DEFAULT '',
237 c128 CHAR(255) NOT NULL DEFAULT '',
238 c129 CHAR(255) NOT NULL DEFAULT '',
239 c130 CHAR(255) NOT NULL DEFAULT '',
240 c131 CHAR(255) NOT NULL DEFAULT '',
241 c132 CHAR(255) NOT NULL DEFAULT '',
242 c133 CHAR(255) NOT NULL DEFAULT '',
243 c134 CHAR(255) NOT NULL DEFAULT '',
244 c135 CHAR(255) NOT NULL DEFAULT '',
245 c136 CHAR(255) NOT NULL DEFAULT '',
246 c137 CHAR(255) NOT NULL DEFAULT '',
247 c138 CHAR(255) NOT NULL DEFAULT '',
248 c139 CHAR(255) NOT NULL DEFAULT '',
249 c140 CHAR(255) NOT NULL DEFAULT '',
250 c141 CHAR(255) NOT NULL DEFAULT '',
251 c142 CHAR(255) NOT NULL DEFAULT '',
252 c143 CHAR(255) NOT NULL DEFAULT '',
253 c144 CHAR(255) NOT NULL DEFAULT '',
254 c145 CHAR(255) NOT NULL DEFAULT '',
255 c146 CHAR(255) NOT NULL DEFAULT '',
256 c147 CHAR(255) NOT NULL DEFAULT '',
257 c148 CHAR(255) NOT NULL DEFAULT '',
258 c149 CHAR(255) NOT NULL DEFAULT '',
259 c150 CHAR(255) NOT NULL DEFAULT '',
260 c151 CHAR(255) NOT NULL DEFAULT '',
261 c152 CHAR(255) NOT NULL DEFAULT '',
262 c153 CHAR(255) NOT NULL DEFAULT '',
263 c154 CHAR(255) NOT NULL DEFAULT '',
264 c155 CHAR(255) NOT NULL DEFAULT '',
265 c156 CHAR(255) NOT NULL DEFAULT '',
266 c157 CHAR(255) NOT NULL DEFAULT '',
267 c158 CHAR(255) NOT NULL DEFAULT '',
268 c159 CHAR(255) NOT NULL DEFAULT '',
269 c160 CHAR(255) NOT NULL DEFAULT '',
270 c161 CHAR(255) NOT NULL DEFAULT '',
271 c162 CHAR(255) NOT NULL DEFAULT '',
272 c163 CHAR(255) NOT NULL DEFAULT '',
273 c164 CHAR(255) NOT NULL DEFAULT '',
274 c165 CHAR(255) NOT NULL DEFAULT '',
275 c166 CHAR(255) NOT NULL DEFAULT '',
276 c167 CHAR(255) NOT NULL DEFAULT '',
277 c168 CHAR(255) NOT NULL DEFAULT '',
278 c169 CHAR(255) NOT NULL DEFAULT '',
279 c170 CHAR(255) NOT NULL DEFAULT '',
280 c171 CHAR(255) NOT NULL DEFAULT '',
281 c172 CHAR(255) NOT NULL DEFAULT '',
282 c173 CHAR(255) NOT NULL DEFAULT '',
283 c174 CHAR(255) NOT NULL DEFAULT '',
284 c175 CHAR(255) NOT NULL DEFAULT '',
285 c176 CHAR(255) NOT NULL DEFAULT '',
286 c177 CHAR(255) NOT NULL DEFAULT '',
287 c178 CHAR(255) NOT NULL DEFAULT '',
288 c179 CHAR(255) NOT NULL DEFAULT '',
289 c180 CHAR(255) NOT NULL DEFAULT '',
290 c181 CHAR(255) NOT NULL DEFAULT '',
291 c182 CHAR(255) NOT NULL DEFAULT '',
292 c183 CHAR(255) NOT NULL DEFAULT '',
293 c184 CHAR(255) NOT NULL DEFAULT '',
294 c185 CHAR(255) NOT NULL DEFAULT '',
295 c186 CHAR(255) NOT NULL DEFAULT '',
296 c187 CHAR(255) NOT NULL DEFAULT '',
297 c188 CHAR(255) NOT NULL DEFAULT '',
298 c189 CHAR(255) NOT NULL DEFAULT '',
299 c190 CHAR(255) NOT NULL DEFAULT '',
300 c191 CHAR(255) NOT NULL DEFAULT '',
301 c192 CHAR(255) NOT NULL DEFAULT '',
302 c193 CHAR(255) NOT NULL DEFAULT '',
303 c194 CHAR(255) NOT NULL DEFAULT '',
304 c195 CHAR(255) NOT NULL DEFAULT '',
305 c196 CHAR(255) NOT NULL DEFAULT '',
306 c197 CHAR(255) NOT NULL DEFAULT '',
307 c198 CHAR(255) NOT NULL DEFAULT '',
308 c199 CHAR(255) NOT NULL DEFAULT '',
309 c200 CHAR(255) NOT NULL DEFAULT '',
310 c201 CHAR(255) NOT NULL DEFAULT '',
311 c202 CHAR(255) NOT NULL DEFAULT '',
312 c203 CHAR(255) NOT NULL DEFAULT '',
313 c204 CHAR(255) NOT NULL DEFAULT '',
314 c205 CHAR(255) NOT NULL DEFAULT '',
315 c206 CHAR(255) NOT NULL DEFAULT '',
316 c207 CHAR(255) NOT NULL DEFAULT '',
317 c208 CHAR(255) NOT NULL DEFAULT '',
318 c209 CHAR(255) NOT NULL DEFAULT '',
319 c210 CHAR(255) NOT NULL DEFAULT '',
320 c211 CHAR(255) NOT NULL DEFAULT '',
321 c212 CHAR(255) NOT NULL DEFAULT '',
322 c213 CHAR(255) NOT NULL DEFAULT '',
323 c214 CHAR(255) NOT NULL DEFAULT '',
324 c215 CHAR(255) NOT NULL DEFAULT '',
325 c216 CHAR(255) NOT NULL DEFAULT '',
326 c217 CHAR(255) NOT NULL DEFAULT '',
327 c218 CHAR(255) NOT NULL DEFAULT '',
328 c219 CHAR(255) NOT NULL DEFAULT '',
329 c220 CHAR(255) NOT NULL DEFAULT '',
330 c221 CHAR(255) NOT NULL DEFAULT '',
331 c222 CHAR(255) NOT NULL DEFAULT '',
332 c223 CHAR(255) NOT NULL DEFAULT '',
333 c224 CHAR(255) NOT NULL DEFAULT '',
334 c225 CHAR(255) NOT NULL DEFAULT '',
335 c226 CHAR(255) NOT NULL DEFAULT '',
336 c227 CHAR(255) NOT NULL DEFAULT '',
337 c228 CHAR(255) NOT NULL DEFAULT '',
338 c229 CHAR(255) NOT NULL DEFAULT '',
339 c230 CHAR(255) NOT NULL DEFAULT '',
340 c231 CHAR(255) NOT NULL DEFAULT '',
341 c232 CHAR(255) NOT NULL DEFAULT '',
342 c233 CHAR(255) NOT NULL DEFAULT '',
343 c234 CHAR(255) NOT NULL DEFAULT '',
344 c235 CHAR(255) NOT NULL DEFAULT '',
345 c236 CHAR(255) NOT NULL DEFAULT '',
346 c237 CHAR(255) NOT NULL DEFAULT '',
347 c238 CHAR(255) NOT NULL DEFAULT '',
348 c239 CHAR(255) NOT NULL DEFAULT '',
349 c240 CHAR(255) NOT NULL DEFAULT '',
350 c241 CHAR(255) NOT NULL DEFAULT '',
351 c242 CHAR(255) NOT NULL DEFAULT '',
352 c243 CHAR(255) NOT NULL DEFAULT '',
353 c244 CHAR(255) NOT NULL DEFAULT '',
354 c245 CHAR(255) NOT NULL DEFAULT '',
355 c246 CHAR(255) NOT NULL DEFAULT '',
356 c247 CHAR(255) NOT NULL DEFAULT '',
357 c248 CHAR(255) NOT NULL DEFAULT '',
358 c249 CHAR(255) NOT NULL DEFAULT '',
359 c250 CHAR(255) NOT NULL DEFAULT '',
360 c251 CHAR(255) NOT NULL DEFAULT '',
361 c252 CHAR(255) NOT NULL DEFAULT '',
362 c253 CHAR(255) NOT NULL DEFAULT '',
363 c254 CHAR(255) NOT NULL DEFAULT '',
364 c255 CHAR(255) NOT NULL DEFAULT '',
365 c256 CHAR(255) NOT NULL DEFAULT '',
366 c257 CHAR(254) NOT NULL DEFAULT ''
367 ) ENGINE = INNODB ROW_FORMAT=COMPACT charset latin1;
368
369 SELECT * FROM t1 ORDER BY c1;
370 SELECT * FROM information_schema.OPTIMIZER_TRACE;
371
372 DROP TABLE t1;