Debian Codegraph @

mysql-test/suite/opt_trace/r/filesort_pack.result

raw
1 SET optimizer_trace_max_mem_size=1048576;
2 SET end_markers_in_json=off;
3 SET optimizer_trace="enabled=on,one_line=off";
4 CREATE TABLE t1 (
5 c1 VARCHAR(1022) NOT NULL DEFAULT '',
6 c2 VARCHAR(1022) NOT NULL DEFAULT '',
7 c3 VARCHAR(1022) NOT NULL DEFAULT '',
8 c4 VARCHAR(1022) NOT NULL DEFAULT '',
9 c5 VARCHAR(1022) NOT NULL DEFAULT '',
10 c6 VARCHAR(1022) NOT NULL DEFAULT '',
11 c7 VARCHAR(1022) NOT NULL DEFAULT '',
12 c8 VARCHAR(1022) NOT NULL DEFAULT '',
13 c9 VARCHAR(1022) NOT NULL DEFAULT '',
14 c10 VARCHAR(1022) NOT NULL DEFAULT '',
15 c11 VARCHAR(1022) NOT NULL DEFAULT '',
16 c12 VARCHAR(1022) NOT NULL DEFAULT '',
17 c13 VARCHAR(1022) NOT NULL DEFAULT '',
18 c14 VARCHAR(1022) NOT NULL DEFAULT '',
19 c15 VARCHAR(1022) NOT NULL DEFAULT '',
20 c16 VARCHAR(1022) NOT NULL DEFAULT '',
21 c17 VARCHAR(1022) NOT NULL DEFAULT '',
22 c18 VARCHAR(1022) NOT NULL DEFAULT '',
23 c19 VARCHAR(1022) NOT NULL DEFAULT '',
24 c20 VARCHAR(1022) NOT NULL DEFAULT '',
25 c21 VARCHAR(1022) NOT NULL DEFAULT '',
26 c22 VARCHAR(1022) NOT NULL DEFAULT '',
27 c23 VARCHAR(1022) NOT NULL DEFAULT '',
28 c24 VARCHAR(1022) NOT NULL DEFAULT '',
29 c25 VARCHAR(1022) NOT NULL DEFAULT '',
30 c26 VARCHAR(1022) NOT NULL DEFAULT '',
31 c27 VARCHAR(1022) NOT NULL DEFAULT '',
32 c28 VARCHAR(1022) NOT NULL DEFAULT '',
33 c29 VARCHAR(1022) NOT NULL DEFAULT '',
34 c30 VARCHAR(1022) NOT NULL DEFAULT '',
35 c31 VARCHAR(1022) NOT NULL DEFAULT '',
36 c32 VARCHAR(1022) NOT NULL DEFAULT '',
37 c33 VARCHAR(1022) NOT NULL DEFAULT '',
38 c34 VARCHAR(1022) NOT NULL DEFAULT '',
39 c35 VARCHAR(1022) NOT NULL DEFAULT '',
40 c36 VARCHAR(1022) NOT NULL DEFAULT '',
41 c37 VARCHAR(1022) NOT NULL DEFAULT '',
42 c38 VARCHAR(1022) NOT NULL DEFAULT '',
43 c39 VARCHAR(1022) NOT NULL DEFAULT '',
44 c40 VARCHAR(1022) NOT NULL DEFAULT '',
45 c41 VARCHAR(1022) NOT NULL DEFAULT '',
46 c42 VARCHAR(1022) NOT NULL DEFAULT '',
47 c43 VARCHAR(1022) NOT NULL DEFAULT '',
48 c44 VARCHAR(1022) NOT NULL DEFAULT '',
49 c45 VARCHAR(1022) NOT NULL DEFAULT '',
50 c46 VARCHAR(1022) NOT NULL DEFAULT '',
51 c47 VARCHAR(1022) NOT NULL DEFAULT '',
52 c48 VARCHAR(1022) NOT NULL DEFAULT '',
53 c49 VARCHAR(1022) NOT NULL DEFAULT '',
54 c50 VARCHAR(1022) NOT NULL DEFAULT '',
55 c51 VARCHAR(1022) NOT NULL DEFAULT '',
56 c52 VARCHAR(1022) NOT NULL DEFAULT '',
57 c53 VARCHAR(1022) NOT NULL DEFAULT '',
58 c54 VARCHAR(1022) NOT NULL DEFAULT '',
59 c55 VARCHAR(1022) NOT NULL DEFAULT '',
60 c56 VARCHAR(1022) NOT NULL DEFAULT '',
61 c57 VARCHAR(1022) NOT NULL DEFAULT '',
62 c58 VARCHAR(1022) NOT NULL DEFAULT '',
63 c59 VARCHAR(1022) NOT NULL DEFAULT '',
64 c60 VARCHAR(1022) NOT NULL DEFAULT '',
65 c61 VARCHAR(1022) NOT NULL DEFAULT '',
66 c62 VARCHAR(1022) NOT NULL DEFAULT '',
67 c63 VARCHAR(1022) NOT NULL DEFAULT '',
68 c64 VARCHAR(1021) NOT NULL DEFAULT ''
69 ) ENGINE = INNODB, charset latin1;
70 SET @save_sort_buffer_size= @@sort_buffer_size;
71 SET @@sort_buffer_size = 8 + 15 * (65535 + 1022 + 8);
72 select * from t1 order by c1;
73 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64
74 SELECT * FROM information_schema.OPTIMIZER_TRACE;
75 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
76 select * from t1 order by c1 {
77 "steps": [
78 {
79 "join_preparation": {
80 "select#": 1,
81 "steps": [
82 {
83 "expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64` from `t1` order by `t1`.`c1`"
84 }
85 ]
86 }
87 },
88 {
89 "join_optimization": {
90 "select#": 1,
91 "steps": [
92 {
93 "substitute_generated_columns": {
94 }
95 },
96 {
97 "table_dependencies": [
98 {
99 "table": "`t1`",
100 "row_may_be_null": false,
101 "map_bit": 0,
102 "depends_on_map_bits": [
103 ]
104 }
105 ]
106 },
107 {
108 "rows_estimation": [
109 {
110 "table": "`t1`",
111 "table_scan": {
112 "rows": 1,
113 "cost": 0.25
114 }
115 }
116 ]
117 },
118 {
119 "considered_execution_plans": [
120 {
121 "plan_prefix": [
122 ],
123 "table": "`t1`",
124 "best_access_path": {
125 "considered_access_paths": [
126 {
127 "rows_to_scan": 1,
128 "access_type": "scan",
129 "resulting_rows": 1,
130 "cost": 0.35,
131 "chosen": true,
132 "use_tmp_table": true
133 }
134 ]
135 },
136 "condition_filtering_pct": 100,
137 "rows_for_plan": 1,
138 "cost_for_plan": 0.35,
139 "sort_cost": 1,
140 "new_cost_for_plan": 1.35,
141 "chosen": true
142 }
143 ]
144 },
145 {
146 "attaching_conditions_to_tables": {
147 "original_condition": null,
148 "attached_conditions_computation": [
149 ],
150 "attached_conditions_summary": [
151 {
152 "table": "`t1`",
153 "attached": null
154 }
155 ]
156 }
157 },
158 {
159 "optimizing_distinct_group_by_order_by": {
160 "simplifying_order_by": {
161 "original_clause": "`t1`.`c1`",
162 "items": [
163 {
164 "item": "`t1`.`c1`"
165 }
166 ],
167 "resulting_clause_is_simple": true,
168 "resulting_clause": "`t1`.`c1`"
169 }
170 }
171 },
172 {
173 "finalizing_table_conditions": [
174 ]
175 },
176 {
177 "refine_plan": [
178 {
179 "table": "`t1`"
180 }
181 ]
182 },
183 {
184 "considering_tmp_tables": [
185 {
186 "adding_sort_to_table": "t1"
187 }
188 ]
189 }
190 ]
191 }
192 },
193 {
194 "join_execution": {
195 "select#": 1,
196 "steps": [
197 {
198 "sorting_table": "t1",
199 "filesort_information": [
200 {
201 "direction": "asc",
202 "expression": "`t1`.`c1`"
203 }
204 ],
205 "filesort_priority_queue_optimization": {
206 "usable": false,
207 "cause": "not applicable (no LIMIT)"
208 },
209 "filesort_execution": [
210 ],
211 "filesort_summary": {
212 "memory_available": 998483,
213 "key_size": 1022,
214 "row_size": 66561,
215 "max_rows_per_buffer": 14,
216 "num_rows_estimate": 15,
217 "num_rows_found": 0,
218 "num_initial_chunks_spilled_to_disk": 0,
219 "peak_memory_used": 0,
220 "sort_algorithm": "none",
221 "sort_mode": "<fixed_sort_key, packed_additional_fields>"
222 }
223 }
224 ]
225 }
226 }
227 ]
228 } 0 0
229 SET @@sort_buffer_size = 8 + 15 * (65535 + 1023 + 8);
230 select * from t1 order by c1;
231 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64
232 SELECT * FROM information_schema.OPTIMIZER_TRACE;
233 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
234 select * from t1 order by c1 {
235 "steps": [
236 {
237 "join_preparation": {
238 "select#": 1,
239 "steps": [
240 {
241 "expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64` from `t1` order by `t1`.`c1`"
242 }
243 ]
244 }
245 },
246 {
247 "join_optimization": {
248 "select#": 1,
249 "steps": [
250 {
251 "substitute_generated_columns": {
252 }
253 },
254 {
255 "table_dependencies": [
256 {
257 "table": "`t1`",
258 "row_may_be_null": false,
259 "map_bit": 0,
260 "depends_on_map_bits": [
261 ]
262 }
263 ]
264 },
265 {
266 "rows_estimation": [
267 {
268 "table": "`t1`",
269 "table_scan": {
270 "rows": 1,
271 "cost": 0.25
272 }
273 }
274 ]
275 },
276 {
277 "considered_execution_plans": [
278 {
279 "plan_prefix": [
280 ],
281 "table": "`t1`",
282 "best_access_path": {
283 "considered_access_paths": [
284 {
285 "rows_to_scan": 1,
286 "access_type": "scan",
287 "resulting_rows": 1,
288 "cost": 0.35,
289 "chosen": true,
290 "use_tmp_table": true
291 }
292 ]
293 },
294 "condition_filtering_pct": 100,
295 "rows_for_plan": 1,
296 "cost_for_plan": 0.35,
297 "sort_cost": 1,
298 "new_cost_for_plan": 1.35,
299 "chosen": true
300 }
301 ]
302 },
303 {
304 "attaching_conditions_to_tables": {
305 "original_condition": null,
306 "attached_conditions_computation": [
307 ],
308 "attached_conditions_summary": [
309 {
310 "table": "`t1`",
311 "attached": null
312 }
313 ]
314 }
315 },
316 {
317 "optimizing_distinct_group_by_order_by": {
318 "simplifying_order_by": {
319 "original_clause": "`t1`.`c1`",
320 "items": [
321 {
322 "item": "`t1`.`c1`"
323 }
324 ],
325 "resulting_clause_is_simple": true,
326 "resulting_clause": "`t1`.`c1`"
327 }
328 }
329 },
330 {
331 "finalizing_table_conditions": [
332 ]
333 },
334 {
335 "refine_plan": [
336 {
337 "table": "`t1`"
338 }
339 ]
340 },
341 {
342 "considering_tmp_tables": [
343 {
344 "adding_sort_to_table": "t1"
345 }
346 ]
347 }
348 ]
349 }
350 },
351 {
352 "join_execution": {
353 "select#": 1,
354 "steps": [
355 {
356 "sorting_table": "t1",
357 "filesort_information": [
358 {
359 "direction": "asc",
360 "expression": "`t1`.`c1`"
361 }
362 ],
363 "filesort_priority_queue_optimization": {
364 "usable": false,
365 "cause": "not applicable (no LIMIT)"
366 },
367 "filesort_execution": [
368 ],
369 "filesort_summary": {
370 "memory_available": 998498,
371 "key_size": 1022,
372 "row_size": 66561,
373 "max_rows_per_buffer": 14,
374 "num_rows_estimate": 15,
375 "num_rows_found": 0,
376 "num_initial_chunks_spilled_to_disk": 0,
377 "peak_memory_used": 0,
378 "sort_algorithm": "none",
379 "sort_mode": "<fixed_sort_key, packed_additional_fields>"
380 }
381 }
382 ]
383 }
384 }
385 ]
386 } 0 0
387 SET @@sort_buffer_size = 8 + 15 * (65535 + 1024 + 8);
388 select * from t1 order by c1;
389 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64
390 SELECT * FROM information_schema.OPTIMIZER_TRACE;
391 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
392 select * from t1 order by c1 {
393 "steps": [
394 {
395 "join_preparation": {
396 "select#": 1,
397 "steps": [
398 {
399 "expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64` from `t1` order by `t1`.`c1`"
400 }
401 ]
402 }
403 },
404 {
405 "join_optimization": {
406 "select#": 1,
407 "steps": [
408 {
409 "substitute_generated_columns": {
410 }
411 },
412 {
413 "table_dependencies": [
414 {
415 "table": "`t1`",
416 "row_may_be_null": false,
417 "map_bit": 0,
418 "depends_on_map_bits": [
419 ]
420 }
421 ]
422 },
423 {
424 "rows_estimation": [
425 {
426 "table": "`t1`",
427 "table_scan": {
428 "rows": 1,
429 "cost": 0.25
430 }
431 }
432 ]
433 },
434 {
435 "considered_execution_plans": [
436 {
437 "plan_prefix": [
438 ],
439 "table": "`t1`",
440 "best_access_path": {
441 "considered_access_paths": [
442 {
443 "rows_to_scan": 1,
444 "access_type": "scan",
445 "resulting_rows": 1,
446 "cost": 0.35,
447 "chosen": true,
448 "use_tmp_table": true
449 }
450 ]
451 },
452 "condition_filtering_pct": 100,
453 "rows_for_plan": 1,
454 "cost_for_plan": 0.35,
455 "sort_cost": 1,
456 "new_cost_for_plan": 1.35,
457 "chosen": true
458 }
459 ]
460 },
461 {
462 "attaching_conditions_to_tables": {
463 "original_condition": null,
464 "attached_conditions_computation": [
465 ],
466 "attached_conditions_summary": [
467 {
468 "table": "`t1`",
469 "attached": null
470 }
471 ]
472 }
473 },
474 {
475 "optimizing_distinct_group_by_order_by": {
476 "simplifying_order_by": {
477 "original_clause": "`t1`.`c1`",
478 "items": [
479 {
480 "item": "`t1`.`c1`"
481 }
482 ],
483 "resulting_clause_is_simple": true,
484 "resulting_clause": "`t1`.`c1`"
485 }
486 }
487 },
488 {
489 "finalizing_table_conditions": [
490 ]
491 },
492 {
493 "refine_plan": [
494 {
495 "table": "`t1`"
496 }
497 ]
498 },
499 {
500 "considering_tmp_tables": [
501 {
502 "adding_sort_to_table": "t1"
503 }
504 ]
505 }
506 ]
507 }
508 },
509 {
510 "join_execution": {
511 "select#": 1,
512 "steps": [
513 {
514 "sorting_table": "t1",
515 "filesort_information": [
516 {
517 "direction": "asc",
518 "expression": "`t1`.`c1`"
519 }
520 ],
521 "filesort_priority_queue_optimization": {
522 "usable": false,
523 "cause": "not applicable (no LIMIT)"
524 },
525 "filesort_execution": [
526 ],
527 "filesort_summary": {
528 "memory_available": 998513,
529 "key_size": 1022,
530 "row_size": 66561,
531 "max_rows_per_buffer": 14,
532 "num_rows_estimate": 15,
533 "num_rows_found": 0,
534 "num_initial_chunks_spilled_to_disk": 0,
535 "peak_memory_used": 0,
536 "sort_algorithm": "none",
537 "sort_mode": "<fixed_sort_key, packed_additional_fields>"
538 }
539 }
540 ]
541 }
542 }
543 ]
544 } 0 0
545 SET @@sort_buffer_size= @save_sort_buffer_size;
546 DROP TABLE t1;
547 SET innodb_strict_mode=off;
548 CREATE TABLE t1 (
549 c1 CHAR(255) NOT NULL DEFAULT '',
550 c2 CHAR(255) NOT NULL DEFAULT '',
551 c3 CHAR(255) NOT NULL DEFAULT '',
552 c4 CHAR(255) NOT NULL DEFAULT '',
553 c5 CHAR(255) NOT NULL DEFAULT '',
554 c6 CHAR(255) NOT NULL DEFAULT '',
555 c7 CHAR(255) NOT NULL DEFAULT '',
556 c8 CHAR(255) NOT NULL DEFAULT '',
557 c9 CHAR(255) NOT NULL DEFAULT '',
558 c10 CHAR(255) NOT NULL DEFAULT '',
559 c11 CHAR(255) NOT NULL DEFAULT '',
560 c12 CHAR(255) NOT NULL DEFAULT '',
561 c13 CHAR(255) NOT NULL DEFAULT '',
562 c14 CHAR(255) NOT NULL DEFAULT '',
563 c15 CHAR(255) NOT NULL DEFAULT '',
564 c16 CHAR(255) NOT NULL DEFAULT '',
565 c17 CHAR(255) NOT NULL DEFAULT '',
566 c18 CHAR(255) NOT NULL DEFAULT '',
567 c19 CHAR(255) NOT NULL DEFAULT '',
568 c20 CHAR(255) NOT NULL DEFAULT '',
569 c21 CHAR(255) NOT NULL DEFAULT '',
570 c22 CHAR(255) NOT NULL DEFAULT '',
571 c23 CHAR(255) NOT NULL DEFAULT '',
572 c24 CHAR(255) NOT NULL DEFAULT '',
573 c25 CHAR(255) NOT NULL DEFAULT '',
574 c26 CHAR(255) NOT NULL DEFAULT '',
575 c27 CHAR(255) NOT NULL DEFAULT '',
576 c28 CHAR(255) NOT NULL DEFAULT '',
577 c29 CHAR(255) NOT NULL DEFAULT '',
578 c30 CHAR(255) NOT NULL DEFAULT '',
579 c31 CHAR(255) NOT NULL DEFAULT '',
580 c32 CHAR(255) NOT NULL DEFAULT '',
581 c33 CHAR(255) NOT NULL DEFAULT '',
582 c34 CHAR(255) NOT NULL DEFAULT '',
583 c35 CHAR(255) NOT NULL DEFAULT '',
584 c36 CHAR(255) NOT NULL DEFAULT '',
585 c37 CHAR(255) NOT NULL DEFAULT '',
586 c38 CHAR(255) NOT NULL DEFAULT '',
587 c39 CHAR(255) NOT NULL DEFAULT '',
588 c40 CHAR(255) NOT NULL DEFAULT '',
589 c41 CHAR(255) NOT NULL DEFAULT '',
590 c42 CHAR(255) NOT NULL DEFAULT '',
591 c43 CHAR(255) NOT NULL DEFAULT '',
592 c44 CHAR(255) NOT NULL DEFAULT '',
593 c45 CHAR(255) NOT NULL DEFAULT '',
594 c46 CHAR(255) NOT NULL DEFAULT '',
595 c47 CHAR(255) NOT NULL DEFAULT '',
596 c48 CHAR(255) NOT NULL DEFAULT '',
597 c49 CHAR(255) NOT NULL DEFAULT '',
598 c50 CHAR(255) NOT NULL DEFAULT '',
599 c51 CHAR(255) NOT NULL DEFAULT '',
600 c52 CHAR(255) NOT NULL DEFAULT '',
601 c53 CHAR(255) NOT NULL DEFAULT '',
602 c54 CHAR(255) NOT NULL DEFAULT '',
603 c55 CHAR(255) NOT NULL DEFAULT '',
604 c56 CHAR(255) NOT NULL DEFAULT '',
605 c57 CHAR(255) NOT NULL DEFAULT '',
606 c58 CHAR(255) NOT NULL DEFAULT '',
607 c59 CHAR(255) NOT NULL DEFAULT '',
608 c60 CHAR(255) NOT NULL DEFAULT '',
609 c61 CHAR(255) NOT NULL DEFAULT '',
610 c62 CHAR(255) NOT NULL DEFAULT '',
611 c63 CHAR(255) NOT NULL DEFAULT '',
612 c64 CHAR(255) NOT NULL DEFAULT '',
613 c65 CHAR(255) NOT NULL DEFAULT '',
614 c66 CHAR(255) NOT NULL DEFAULT '',
615 c67 CHAR(255) NOT NULL DEFAULT '',
616 c68 CHAR(255) NOT NULL DEFAULT '',
617 c69 CHAR(255) NOT NULL DEFAULT '',
618 c70 CHAR(255) NOT NULL DEFAULT '',
619 c71 CHAR(255) NOT NULL DEFAULT '',
620 c72 CHAR(255) NOT NULL DEFAULT '',
621 c73 CHAR(255) NOT NULL DEFAULT '',
622 c74 CHAR(255) NOT NULL DEFAULT '',
623 c75 CHAR(255) NOT NULL DEFAULT '',
624 c76 CHAR(255) NOT NULL DEFAULT '',
625 c77 CHAR(255) NOT NULL DEFAULT '',
626 c78 CHAR(255) NOT NULL DEFAULT '',
627 c79 CHAR(255) NOT NULL DEFAULT '',
628 c80 CHAR(255) NOT NULL DEFAULT '',
629 c81 CHAR(255) NOT NULL DEFAULT '',
630 c82 CHAR(255) NOT NULL DEFAULT '',
631 c83 CHAR(255) NOT NULL DEFAULT '',
632 c84 CHAR(255) NOT NULL DEFAULT '',
633 c85 CHAR(255) NOT NULL DEFAULT '',
634 c86 CHAR(255) NOT NULL DEFAULT '',
635 c87 CHAR(255) NOT NULL DEFAULT '',
636 c88 CHAR(255) NOT NULL DEFAULT '',
637 c89 CHAR(255) NOT NULL DEFAULT '',
638 c90 CHAR(255) NOT NULL DEFAULT '',
639 c91 CHAR(255) NOT NULL DEFAULT '',
640 c92 CHAR(255) NOT NULL DEFAULT '',
641 c93 CHAR(255) NOT NULL DEFAULT '',
642 c94 CHAR(255) NOT NULL DEFAULT '',
643 c95 CHAR(255) NOT NULL DEFAULT '',
644 c96 CHAR(255) NOT NULL DEFAULT '',
645 c97 CHAR(255) NOT NULL DEFAULT '',
646 c98 CHAR(255) NOT NULL DEFAULT '',
647 c99 CHAR(255) NOT NULL DEFAULT '',
648 c100 CHAR(255) NOT NULL DEFAULT '',
649 c101 CHAR(255) NOT NULL DEFAULT '',
650 c102 CHAR(255) NOT NULL DEFAULT '',
651 c103 CHAR(255) NOT NULL DEFAULT '',
652 c104 CHAR(255) NOT NULL DEFAULT '',
653 c105 CHAR(255) NOT NULL DEFAULT '',
654 c106 CHAR(255) NOT NULL DEFAULT '',
655 c107 CHAR(255) NOT NULL DEFAULT '',
656 c108 CHAR(255) NOT NULL DEFAULT '',
657 c109 CHAR(255) NOT NULL DEFAULT '',
658 c110 CHAR(255) NOT NULL DEFAULT '',
659 c111 CHAR(255) NOT NULL DEFAULT '',
660 c112 CHAR(255) NOT NULL DEFAULT '',
661 c113 CHAR(255) NOT NULL DEFAULT '',
662 c114 CHAR(255) NOT NULL DEFAULT '',
663 c115 CHAR(255) NOT NULL DEFAULT '',
664 c116 CHAR(255) NOT NULL DEFAULT '',
665 c117 CHAR(255) NOT NULL DEFAULT '',
666 c118 CHAR(255) NOT NULL DEFAULT '',
667 c119 CHAR(255) NOT NULL DEFAULT '',
668 c120 CHAR(255) NOT NULL DEFAULT '',
669 c121 CHAR(255) NOT NULL DEFAULT '',
670 c122 CHAR(255) NOT NULL DEFAULT '',
671 c123 CHAR(255) NOT NULL DEFAULT '',
672 c124 CHAR(255) NOT NULL DEFAULT '',
673 c125 CHAR(255) NOT NULL DEFAULT '',
674 c126 CHAR(255) NOT NULL DEFAULT '',
675 c127 CHAR(255) NOT NULL DEFAULT '',
676 c128 CHAR(255) NOT NULL DEFAULT '',
677 c129 CHAR(255) NOT NULL DEFAULT '',
678 c130 CHAR(255) NOT NULL DEFAULT '',
679 c131 CHAR(255) NOT NULL DEFAULT '',
680 c132 CHAR(255) NOT NULL DEFAULT '',
681 c133 CHAR(255) NOT NULL DEFAULT '',
682 c134 CHAR(255) NOT NULL DEFAULT '',
683 c135 CHAR(255) NOT NULL DEFAULT '',
684 c136 CHAR(255) NOT NULL DEFAULT '',
685 c137 CHAR(255) NOT NULL DEFAULT '',
686 c138 CHAR(255) NOT NULL DEFAULT '',
687 c139 CHAR(255) NOT NULL DEFAULT '',
688 c140 CHAR(255) NOT NULL DEFAULT '',
689 c141 CHAR(255) NOT NULL DEFAULT '',
690 c142 CHAR(255) NOT NULL DEFAULT '',
691 c143 CHAR(255) NOT NULL DEFAULT '',
692 c144 CHAR(255) NOT NULL DEFAULT '',
693 c145 CHAR(255) NOT NULL DEFAULT '',
694 c146 CHAR(255) NOT NULL DEFAULT '',
695 c147 CHAR(255) NOT NULL DEFAULT '',
696 c148 CHAR(255) NOT NULL DEFAULT '',
697 c149 CHAR(255) NOT NULL DEFAULT '',
698 c150 CHAR(255) NOT NULL DEFAULT '',
699 c151 CHAR(255) NOT NULL DEFAULT '',
700 c152 CHAR(255) NOT NULL DEFAULT '',
701 c153 CHAR(255) NOT NULL DEFAULT '',
702 c154 CHAR(255) NOT NULL DEFAULT '',
703 c155 CHAR(255) NOT NULL DEFAULT '',
704 c156 CHAR(255) NOT NULL DEFAULT '',
705 c157 CHAR(255) NOT NULL DEFAULT '',
706 c158 CHAR(255) NOT NULL DEFAULT '',
707 c159 CHAR(255) NOT NULL DEFAULT '',
708 c160 CHAR(255) NOT NULL DEFAULT '',
709 c161 CHAR(255) NOT NULL DEFAULT '',
710 c162 CHAR(255) NOT NULL DEFAULT '',
711 c163 CHAR(255) NOT NULL DEFAULT '',
712 c164 CHAR(255) NOT NULL DEFAULT '',
713 c165 CHAR(255) NOT NULL DEFAULT '',
714 c166 CHAR(255) NOT NULL DEFAULT '',
715 c167 CHAR(255) NOT NULL DEFAULT '',
716 c168 CHAR(255) NOT NULL DEFAULT '',
717 c169 CHAR(255) NOT NULL DEFAULT '',
718 c170 CHAR(255) NOT NULL DEFAULT '',
719 c171 CHAR(255) NOT NULL DEFAULT '',
720 c172 CHAR(255) NOT NULL DEFAULT '',
721 c173 CHAR(255) NOT NULL DEFAULT '',
722 c174 CHAR(255) NOT NULL DEFAULT '',
723 c175 CHAR(255) NOT NULL DEFAULT '',
724 c176 CHAR(255) NOT NULL DEFAULT '',
725 c177 CHAR(255) NOT NULL DEFAULT '',
726 c178 CHAR(255) NOT NULL DEFAULT '',
727 c179 CHAR(255) NOT NULL DEFAULT '',
728 c180 CHAR(255) NOT NULL DEFAULT '',
729 c181 CHAR(255) NOT NULL DEFAULT '',
730 c182 CHAR(255) NOT NULL DEFAULT '',
731 c183 CHAR(255) NOT NULL DEFAULT '',
732 c184 CHAR(255) NOT NULL DEFAULT '',
733 c185 CHAR(255) NOT NULL DEFAULT '',
734 c186 CHAR(255) NOT NULL DEFAULT '',
735 c187 CHAR(255) NOT NULL DEFAULT '',
736 c188 CHAR(255) NOT NULL DEFAULT '',
737 c189 CHAR(255) NOT NULL DEFAULT '',
738 c190 CHAR(255) NOT NULL DEFAULT '',
739 c191 CHAR(255) NOT NULL DEFAULT '',
740 c192 CHAR(255) NOT NULL DEFAULT '',
741 c193 CHAR(255) NOT NULL DEFAULT '',
742 c194 CHAR(255) NOT NULL DEFAULT '',
743 c195 CHAR(255) NOT NULL DEFAULT '',
744 c196 CHAR(255) NOT NULL DEFAULT '',
745 c197 CHAR(255) NOT NULL DEFAULT '',
746 c198 CHAR(255) NOT NULL DEFAULT '',
747 c199 CHAR(255) NOT NULL DEFAULT '',
748 c200 CHAR(255) NOT NULL DEFAULT '',
749 c201 CHAR(255) NOT NULL DEFAULT '',
750 c202 CHAR(255) NOT NULL DEFAULT '',
751 c203 CHAR(255) NOT NULL DEFAULT '',
752 c204 CHAR(255) NOT NULL DEFAULT '',
753 c205 CHAR(255) NOT NULL DEFAULT '',
754 c206 CHAR(255) NOT NULL DEFAULT '',
755 c207 CHAR(255) NOT NULL DEFAULT '',
756 c208 CHAR(255) NOT NULL DEFAULT '',
757 c209 CHAR(255) NOT NULL DEFAULT '',
758 c210 CHAR(255) NOT NULL DEFAULT '',
759 c211 CHAR(255) NOT NULL DEFAULT '',
760 c212 CHAR(255) NOT NULL DEFAULT '',
761 c213 CHAR(255) NOT NULL DEFAULT '',
762 c214 CHAR(255) NOT NULL DEFAULT '',
763 c215 CHAR(255) NOT NULL DEFAULT '',
764 c216 CHAR(255) NOT NULL DEFAULT '',
765 c217 CHAR(255) NOT NULL DEFAULT '',
766 c218 CHAR(255) NOT NULL DEFAULT '',
767 c219 CHAR(255) NOT NULL DEFAULT '',
768 c220 CHAR(255) NOT NULL DEFAULT '',
769 c221 CHAR(255) NOT NULL DEFAULT '',
770 c222 CHAR(255) NOT NULL DEFAULT '',
771 c223 CHAR(255) NOT NULL DEFAULT '',
772 c224 CHAR(255) NOT NULL DEFAULT '',
773 c225 CHAR(255) NOT NULL DEFAULT '',
774 c226 CHAR(255) NOT NULL DEFAULT '',
775 c227 CHAR(255) NOT NULL DEFAULT '',
776 c228 CHAR(255) NOT NULL DEFAULT '',
777 c229 CHAR(255) NOT NULL DEFAULT '',
778 c230 CHAR(255) NOT NULL DEFAULT '',
779 c231 CHAR(255) NOT NULL DEFAULT '',
780 c232 CHAR(255) NOT NULL DEFAULT '',
781 c233 CHAR(255) NOT NULL DEFAULT '',
782 c234 CHAR(255) NOT NULL DEFAULT '',
783 c235 CHAR(255) NOT NULL DEFAULT '',
784 c236 CHAR(255) NOT NULL DEFAULT '',
785 c237 CHAR(255) NOT NULL DEFAULT '',
786 c238 CHAR(255) NOT NULL DEFAULT '',
787 c239 CHAR(255) NOT NULL DEFAULT '',
788 c240 CHAR(255) NOT NULL DEFAULT '',
789 c241 CHAR(255) NOT NULL DEFAULT '',
790 c242 CHAR(255) NOT NULL DEFAULT '',
791 c243 CHAR(255) NOT NULL DEFAULT '',
792 c244 CHAR(255) NOT NULL DEFAULT '',
793 c245 CHAR(255) NOT NULL DEFAULT '',
794 c246 CHAR(255) NOT NULL DEFAULT '',
795 c247 CHAR(255) NOT NULL DEFAULT '',
796 c248 CHAR(255) NOT NULL DEFAULT '',
797 c249 CHAR(255) NOT NULL DEFAULT '',
798 c250 CHAR(255) NOT NULL DEFAULT '',
799 c251 CHAR(255) NOT NULL DEFAULT '',
800 c252 CHAR(255) NOT NULL DEFAULT '',
801 c253 CHAR(255) NOT NULL DEFAULT '',
802 c254 CHAR(255) NOT NULL DEFAULT '',
803 c255 CHAR(255) NOT NULL DEFAULT '',
804 c256 CHAR(255) NOT NULL DEFAULT '',
805 c257 CHAR(254) NOT NULL DEFAULT ''
806 ) ENGINE = INNODB ROW_FORMAT=COMPACT charset latin1;
807 Warnings:
808 Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
809 SELECT * FROM t1 ORDER BY c1;
810 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64 c65 c66 c67 c68 c69 c70 c71 c72 c73 c74 c75 c76 c77 c78 c79 c80 c81 c82 c83 c84 c85 c86 c87 c88 c89 c90 c91 c92 c93 c94 c95 c96 c97 c98 c99 c100 c101 c102 c103 c104 c105 c106 c107 c108 c109 c110 c111 c112 c113 c114 c115 c116 c117 c118 c119 c120 c121 c122 c123 c124 c125 c126 c127 c128 c129 c130 c131 c132 c133 c134 c135 c136 c137 c138 c139 c140 c141 c142 c143 c144 c145 c146 c147 c148 c149 c150 c151 c152 c153 c154 c155 c156 c157 c158 c159 c160 c161 c162 c163 c164 c165 c166 c167 c168 c169 c170 c171 c172 c173 c174 c175 c176 c177 c178 c179 c180 c181 c182 c183 c184 c185 c186 c187 c188 c189 c190 c191 c192 c193 c194 c195 c196 c197 c198 c199 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249 c250 c251 c252 c253 c254 c255 c256 c257
811 SELECT * FROM information_schema.OPTIMIZER_TRACE;
812 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
813 SELECT * FROM t1 ORDER BY c1 {
814 "steps": [
815 {
816 "join_preparation": {
817 "select#": 1,
818 "steps": [
819 {
820 "expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64`,`t1`.`c65` AS `c65`,`t1`.`c66` AS `c66`,`t1`.`c67` AS `c67`,`t1`.`c68` AS `c68`,`t1`.`c69` AS `c69`,`t1`.`c70` AS `c70`,`t1`.`c71` AS `c71`,`t1`.`c72` AS `c72`,`t1`.`c73` AS `c73`,`t1`.`c74` AS `c74`,`t1`.`c75` AS `c75`,`t1`.`c76` AS `c76`,`t1`.`c77` AS `c77`,`t1`.`c78` AS `c78`,`t1`.`c79` AS `c79`,`t1`.`c80` AS `c80`,`t1`.`c81` AS `c81`,`t1`.`c82` AS `c82`,`t1`.`c83` AS `c83`,`t1`.`c84` AS `c84`,`t1`.`c85` AS `c85`,`t1`.`c86` AS `c86`,`t1`.`c87` AS `c87`,`t1`.`c88` AS `c88`,`t1`.`c89` AS `c89`,`t1`.`c90` AS `c90`,`t1`.`c91` AS `c91`,`t1`.`c92` AS `c92`,`t1`.`c93` AS `c93`,`t1`.`c94` AS `c94`,`t1`.`c95` AS `c95`,`t1`.`c96` AS `c96`,`t1`.`c97` AS `c97`,`t1`.`c98` AS `c98`,`t1`.`c99` AS `c99`,`t1`.`c100` AS `c100`,`t1`.`c101` AS `c101`,`t1`.`c102` AS `c102`,`t1`.`c103` AS `c103`,`t1`.`c104` AS `c104`,`t1`.`c105` AS `c105`,`t1`.`c106` AS `c106`,`t1`.`c107` AS `c107`,`t1`.`c108` AS `c108`,`t1`.`c109` AS `c109`,`t1`.`c110` AS `c110`,`t1`.`c111` AS `c111`,`t1`.`c112` AS `c112`,`t1`.`c113` AS `c113`,`t1`.`c114` AS `c114`,`t1`.`c115` AS `c115`,`t1`.`c116` AS `c116`,`t1`.`c117` AS `c117`,`t1`.`c118` AS `c118`,`t1`.`c119` AS `c119`,`t1`.`c120` AS `c120`,`t1`.`c121` AS `c121`,`t1`.`c122` AS `c122`,`t1`.`c123` AS `c123`,`t1`.`c124` AS `c124`,`t1`.`c125` AS `c125`,`t1`.`c126` AS `c126`,`t1`.`c127` AS `c127`,`t1`.`c128` AS `c128`,`t1`.`c129` AS `c129`,`t1`.`c130` AS `c130`,`t1`.`c131` AS `c131`,`t1`.`c132` AS `c132`,`t1`.`c133` AS `c133`,`t1`.`c134` AS `c134`,`t1`.`c135` AS `c135`,`t1`.`c136` AS `c136`,`t1`.`c137` AS `c137`,`t1`.`c138` AS `c138`,`t1`.`c139` AS `c139`,`t1`.`c140` AS `c140`,`t1`.`c141` AS `c141`,`t1`.`c142` AS `c142`,`t1`.`c143` AS `c143`,`t1`.`c144` AS `c144`,`t1`.`c145` AS `c145`,`t1`.`c146` AS `c146`,`t1`.`c147` AS `c147`,`t1`.`c148` AS `c148`,`t1`.`c149` AS `c149`,`t1`.`c150` AS `c150`,`t1`.`c151` AS `c151`,`t1`.`c152` AS `c152`,`t1`.`c153` AS `c153`,`t1`.`c154` AS `c154`,`t1`.`c155` AS `c155`,`t1`.`c156` AS `c156`,`t1`.`c157` AS `c157`,`t1`.`c158` AS `c158`,`t1`.`c159` AS `c159`,`t1`.`c160` AS `c160`,`t1`.`c161` AS `c161`,`t1`.`c162` AS `c162`,`t1`.`c163` AS `c163`,`t1`.`c164` AS `c164`,`t1`.`c165` AS `c165`,`t1`.`c166` AS `c166`,`t1`.`c167` AS `c167`,`t1`.`c168` AS `c168`,`t1`.`c169` AS `c169`,`t1`.`c170` AS `c170`,`t1`.`c171` AS `c171`,`t1`.`c172` AS `c172`,`t1`.`c173` AS `c173`,`t1`.`c174` AS `c174`,`t1`.`c175` AS `c175`,`t1`.`c176` AS `c176`,`t1`.`c177` AS `c177`,`t1`.`c178` AS `c178`,`t1`.`c179` AS `c179`,`t1`.`c180` AS `c180`,`t1`.`c181` AS `c181`,`t1`.`c182` AS `c182`,`t1`.`c183` AS `c183`,`t1`.`c184` AS `c184`,`t1`.`c185` AS `c185`,`t1`.`c186` AS `c186`,`t1`.`c187` AS `c187`,`t1`.`c188` AS `c188`,`t1`.`c189` AS `c189`,`t1`.`c190` AS `c190`,`t1`.`c191` AS `c191`,`t1`.`c192` AS `c192`,`t1`.`c193` AS `c193`,`t1`.`c194` AS `c194`,`t1`.`c195` AS `c195`,`t1`.`c196` AS `c196`,`t1`.`c197` AS `c197`,`t1`.`c198` AS `c198`,`t1`.`c199` AS `c199`,`t1`.`c200` AS `c200`,`t1`.`c201` AS `c201`,`t1`.`c202` AS `c202`,`t1`.`c203` AS `c203`,`t1`.`c204` AS `c204`,`t1`.`c205` AS `c205`,`t1`.`c206` AS `c206`,`t1`.`c207` AS `c207`,`t1`.`c208` AS `c208`,`t1`.`c209` AS `c209`,`t1`.`c210` AS `c210`,`t1`.`c211` AS `c211`,`t1`.`c212` AS `c212`,`t1`.`c213` AS `c213`,`t1`.`c214` AS `c214`,`t1`.`c215` AS `c215`,`t1`.`c216` AS `c216`,`t1`.`c217` AS `c217`,`t1`.`c218` AS `c218`,`t1`.`c219` AS `c219`,`t1`.`c220` AS `c220`,`t1`.`c221` AS `c221`,`t1`.`c222` AS `c222`,`t1`.`c223` AS `c223`,`t1`.`c224` AS `c224`,`t1`.`c225` AS `c225`,`t1`.`c226` AS `c226`,`t1`.`c227` AS `c227`,`t1`.`c228` AS `c228`,`t1`.`c229` AS `c229`,`t1`.`c230` AS `c230`,`t1`.`c231` AS `c231`,`t1`.`c232` AS `c232`,`t1`.`c233` AS `c233`,`t1`.`c234` AS `c234`,`t1`.`c235` AS `c235`,`t1`.`c236` AS `c236`,`t1`.`c237` AS `c237`,`t1`.`c238` AS `c238`,`t1`.`c239` AS `c239`,`t1`.`c240` AS `c240`,`t1`.`c241` AS `c241`,`t1`.`c242` AS `c242`,`t1`.`c243` AS `c243`,`t1`.`c244` AS `c244`,`t1`.`c245` AS `c245`,`t1`.`c246` AS `c246`,`t1`.`c247` AS `c247`,`t1`.`c248` AS `c248`,`t1`.`c249` AS `c249`,`t1`.`c250` AS `c250`,`t1`.`c251` AS `c251`,`t1`.`c252` AS `c252`,`t1`.`c253` AS `c253`,`t1`.`c254` AS `c254`,`t1`.`c255` AS `c255`,`t1`.`c256` AS `c256`,`t1`.`c257` AS `c257` from `t1` order by `t1`.`c1`"
821 }
822 ]
823 }
824 },
825 {
826 "join_optimization": {
827 "select#": 1,
828 "steps": [
829 {
830 "substitute_generated_columns": {
831 }
832 },
833 {
834 "table_dependencies": [
835 {
836 "table": "`t1`",
837 "row_may_be_null": false,
838 "map_bit": 0,
839 "depends_on_map_bits": [
840 ]
841 }
842 ]
843 },
844 {
845 "rows_estimation": [
846 {
847 "table": "`t1`",
848 "table_scan": {
849 "rows": 1,
850 "cost": 0.25
851 }
852 }
853 ]
854 },
855 {
856 "considered_execution_plans": [
857 {
858 "plan_prefix": [
859 ],
860 "table": "`t1`",
861 "best_access_path": {
862 "considered_access_paths": [
863 {
864 "rows_to_scan": 1,
865 "access_type": "scan",
866 "resulting_rows": 1,
867 "cost": 0.35,
868 "chosen": true,
869 "use_tmp_table": true
870 }
871 ]
872 },
873 "condition_filtering_pct": 100,
874 "rows_for_plan": 1,
875 "cost_for_plan": 0.35,
876 "sort_cost": 1,
877 "new_cost_for_plan": 1.35,
878 "chosen": true
879 }
880 ]
881 },
882 {
883 "attaching_conditions_to_tables": {
884 "original_condition": null,
885 "attached_conditions_computation": [
886 ],
887 "attached_conditions_summary": [
888 {
889 "table": "`t1`",
890 "attached": null
891 }
892 ]
893 }
894 },
895 {
896 "optimizing_distinct_group_by_order_by": {
897 "simplifying_order_by": {
898 "original_clause": "`t1`.`c1`",
899 "items": [
900 {
901 "item": "`t1`.`c1`"
902 }
903 ],
904 "resulting_clause_is_simple": true,
905 "resulting_clause": "`t1`.`c1`"
906 }
907 }
908 },
909 {
910 "finalizing_table_conditions": [
911 ]
912 },
913 {
914 "refine_plan": [
915 {
916 "table": "`t1`"
917 }
918 ]
919 },
920 {
921 "considering_tmp_tables": [
922 {
923 "adding_sort_to_table": "t1"
924 }
925 ]
926 }
927 ]
928 }
929 },
930 {
931 "join_execution": {
932 "select#": 1,
933 "steps": [
934 {
935 "sorting_table": "t1",
936 "filesort_information": [
937 {
938 "direction": "asc",
939 "expression": "`t1`.`c1`"
940 }
941 ],
942 "filesort_priority_queue_optimization": {
943 "usable": false,
944 "cause": "not applicable (no LIMIT)"
945 },
946 "filesort_execution": [
947 ],
948 "filesort_summary": {
949 "memory_available": 262144,
950 "key_size": 255,
951 "row_size": 66050,
952 "max_rows_per_buffer": 3,
953 "num_rows_estimate": 15,
954 "num_rows_found": 0,
955 "num_initial_chunks_spilled_to_disk": 0,
956 "peak_memory_used": 0,
957 "sort_algorithm": "none",
958 "sort_mode": "<fixed_sort_key, packed_additional_fields>"
959 }
960 }
961 ]
962 }
963 }
964 ]
965 } 0 0
966 DROP TABLE t1;