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