call mtr.add_suppression("InnoDB: Cannot add field");
SET optimizer_trace_max_mem_size=1048576;
SET end_markers_in_json=off;
SET optimizer_trace="enabled=on,one_line=off";
CREATE TABLE t1 (
c1 VARCHAR(1022) NOT NULL DEFAULT '',
c2 VARCHAR(1022) NOT NULL DEFAULT '',
c3 VARCHAR(1022) NOT NULL DEFAULT '',
c4 VARCHAR(1022) NOT NULL DEFAULT '',
c5 VARCHAR(1022) NOT NULL DEFAULT '',
c6 VARCHAR(1022) NOT NULL DEFAULT '',
c7 VARCHAR(1022) NOT NULL DEFAULT '',
c8 VARCHAR(1022) NOT NULL DEFAULT '',
c9 VARCHAR(1022) NOT NULL DEFAULT '',
c10 VARCHAR(1022) NOT NULL DEFAULT '',
c11 VARCHAR(1022) NOT NULL DEFAULT '',
c12 VARCHAR(1022) NOT NULL DEFAULT '',
c13 VARCHAR(1022) NOT NULL DEFAULT '',
c14 VARCHAR(1022) NOT NULL DEFAULT '',
c15 VARCHAR(1022) NOT NULL DEFAULT '',
c16 VARCHAR(1022) NOT NULL DEFAULT '',
c17 VARCHAR(1022) NOT NULL DEFAULT '',
c18 VARCHAR(1022) NOT NULL DEFAULT '',
c19 VARCHAR(1022) NOT NULL DEFAULT '',
c20 VARCHAR(1022) NOT NULL DEFAULT '',
c21 VARCHAR(1022) NOT NULL DEFAULT '',
c22 VARCHAR(1022) NOT NULL DEFAULT '',
c23 VARCHAR(1022) NOT NULL DEFAULT '',
c24 VARCHAR(1022) NOT NULL DEFAULT '',
c25 VARCHAR(1022) NOT NULL DEFAULT '',
c26 VARCHAR(1022) NOT NULL DEFAULT '',
c27 VARCHAR(1022) NOT NULL DEFAULT '',
c28 VARCHAR(1022) NOT NULL DEFAULT '',
c29 VARCHAR(1022) NOT NULL DEFAULT '',
c30 VARCHAR(1022) NOT NULL DEFAULT '',
c31 VARCHAR(1022) NOT NULL DEFAULT '',
c32 VARCHAR(1022) NOT NULL DEFAULT '',
c33 VARCHAR(1022) NOT NULL DEFAULT '',
c34 VARCHAR(1022) NOT NULL DEFAULT '',
c35 VARCHAR(1022) NOT NULL DEFAULT '',
c36 VARCHAR(1022) NOT NULL DEFAULT '',
c37 VARCHAR(1022) NOT NULL DEFAULT '',
c38 VARCHAR(1022) NOT NULL DEFAULT '',
c39 VARCHAR(1022) NOT NULL DEFAULT '',
c40 VARCHAR(1022) NOT NULL DEFAULT '',
c41 VARCHAR(1022) NOT NULL DEFAULT '',
c42 VARCHAR(1022) NOT NULL DEFAULT '',
c43 VARCHAR(1022) NOT NULL DEFAULT '',
c44 VARCHAR(1022) NOT NULL DEFAULT '',
c45 VARCHAR(1022) NOT NULL DEFAULT '',
c46 VARCHAR(1022) NOT NULL DEFAULT '',
c47 VARCHAR(1022) NOT NULL DEFAULT '',
c48 VARCHAR(1022) NOT NULL DEFAULT '',
c49 VARCHAR(1022) NOT NULL DEFAULT '',
c50 VARCHAR(1022) NOT NULL DEFAULT '',
c51 VARCHAR(1022) NOT NULL DEFAULT '',
c52 VARCHAR(1022) NOT NULL DEFAULT '',
c53 VARCHAR(1022) NOT NULL DEFAULT '',
c54 VARCHAR(1022) NOT NULL DEFAULT '',
c55 VARCHAR(1022) NOT NULL DEFAULT '',
c56 VARCHAR(1022) NOT NULL DEFAULT '',
c57 VARCHAR(1022) NOT NULL DEFAULT '',
c58 VARCHAR(1022) NOT NULL DEFAULT '',
c59 VARCHAR(1022) NOT NULL DEFAULT '',
c60 VARCHAR(1022) NOT NULL DEFAULT '',
c61 VARCHAR(1022) NOT NULL DEFAULT '',
c62 VARCHAR(1022) NOT NULL DEFAULT '',
c63 VARCHAR(1022) NOT NULL DEFAULT '',
c64 VARCHAR(1021) NOT NULL DEFAULT ''
) ENGINE = INNODB;
SET @save_max_length_for_sort_data = @@max_length_for_sort_data;
SET @save_sort_buffer_size= @@sort_buffer_size;
SET @@max_length_for_sort_data = 65535 + 1021;
select * from t1 order by c1;
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
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY	TRACE	MISSING_BYTES_BEYOND_MAX_MEM_SIZE	INSUFFICIENT_PRIVILEGES
select * from t1 order by c1	{
  "steps": [
    {
      "join_preparation": {
        "select#": 1,
        "steps": [
          {
            "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`"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select#": 1,
        "steps": [
          {
            "substitute_generated_columns": {
            }
          },
          {
            "table_dependencies": [
              {
                "table": "`t1`",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": [
                ]
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "`t1`",
                "table_scan": {
                  "rows": 1,
                  "cost": 1
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [
                ],
                "table": "`t1`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "rows_to_scan": 1,
                      "access_type": "scan",
                      "resulting_rows": 1,
                      "cost": 1.2,
                      "chosen": true,
                      "use_tmp_table": true
                    }
                  ]
                },
                "condition_filtering_pct": 100,
                "rows_for_plan": 1,
                "cost_for_plan": 1.2,
                "sort_cost": 1,
                "new_cost_for_plan": 2.2,
                "chosen": true
              }
            ]
          },
          {
            "attaching_conditions_to_tables": {
              "original_condition": null,
              "attached_conditions_computation": [
              ],
              "attached_conditions_summary": [
                {
                  "table": "`t1`",
                  "attached": null
                }
              ]
            }
          },
          {
            "clause_processing": {
              "clause": "ORDER BY",
              "original_clause": "`t1`.`c1`",
              "items": [
                {
                  "item": "`t1`.`c1`"
                }
              ],
              "resulting_clause_is_simple": true,
              "resulting_clause": "`t1`.`c1`"
            }
          },
          {
            "refine_plan": [
              {
                "table": "`t1`"
              }
            ]
          }
        ]
      }
    },
    {
      "join_execution": {
        "select#": 1,
        "steps": [
          {
            "filesort_information": [
              {
                "direction": "asc",
                "table": "`t1`",
                "field": "c1"
              }
            ],
            "filesort_priority_queue_optimization": {
              "usable": false,
              "cause": "not applicable (no LIMIT)"
            },
            "filesort_execution": [
            ],
            "filesort_summary": {
              "rows": 0,
              "examined_rows": 0,
              "number_of_tmp_files": 0,
              "sort_buffer_size": 222744,
              "sort_mode": "<sort_key, rowid>"
            }
          }
        ]
      }
    }
  ]
}	0	0
SET @@max_length_for_sort_data = 65535 + 1022;
SET @@sort_buffer_size = 8 + 15 * (@@max_length_for_sort_data + 8);
select * from t1 order by c1;
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
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY	TRACE	MISSING_BYTES_BEYOND_MAX_MEM_SIZE	INSUFFICIENT_PRIVILEGES
select * from t1 order by c1	{
  "steps": [
    {
      "join_preparation": {
        "select#": 1,
        "steps": [
          {
            "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`"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select#": 1,
        "steps": [
          {
            "substitute_generated_columns": {
            }
          },
          {
            "table_dependencies": [
              {
                "table": "`t1`",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": [
                ]
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "`t1`",
                "table_scan": {
                  "rows": 1,
                  "cost": 1
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [
                ],
                "table": "`t1`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "rows_to_scan": 1,
                      "access_type": "scan",
                      "resulting_rows": 1,
                      "cost": 1.2,
                      "chosen": true,
                      "use_tmp_table": true
                    }
                  ]
                },
                "condition_filtering_pct": 100,
                "rows_for_plan": 1,
                "cost_for_plan": 1.2,
                "sort_cost": 1,
                "new_cost_for_plan": 2.2,
                "chosen": true
              }
            ]
          },
          {
            "attaching_conditions_to_tables": {
              "original_condition": null,
              "attached_conditions_computation": [
              ],
              "attached_conditions_summary": [
                {
                  "table": "`t1`",
                  "attached": null
                }
              ]
            }
          },
          {
            "clause_processing": {
              "clause": "ORDER BY",
              "original_clause": "`t1`.`c1`",
              "items": [
                {
                  "item": "`t1`.`c1`"
                }
              ],
              "resulting_clause_is_simple": true,
              "resulting_clause": "`t1`.`c1`"
            }
          },
          {
            "refine_plan": [
              {
                "table": "`t1`"
              }
            ]
          }
        ]
      }
    },
    {
      "join_execution": {
        "select#": 1,
        "steps": [
          {
            "filesort_information": [
              {
                "direction": "asc",
                "table": "`t1`",
                "field": "c1"
              }
            ],
            "filesort_priority_queue_optimization": {
              "usable": false,
              "cause": "not applicable (no LIMIT)"
            },
            "filesort_execution": [
            ],
            "filesort_summary": {
              "rows": 0,
              "examined_rows": 0,
              "number_of_tmp_files": 0,
              "sort_buffer_size": 998480,
              "sort_mode": "<sort_key, additional_fields>"
            }
          }
        ]
      }
    }
  ]
}	0	0
SET @@max_length_for_sort_data = 65535 + 1023;
SET @@sort_buffer_size = 8 + 15 * (@@max_length_for_sort_data + 8);
select * from t1 order by c1;
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
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY	TRACE	MISSING_BYTES_BEYOND_MAX_MEM_SIZE	INSUFFICIENT_PRIVILEGES
select * from t1 order by c1	{
  "steps": [
    {
      "join_preparation": {
        "select#": 1,
        "steps": [
          {
            "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`"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select#": 1,
        "steps": [
          {
            "substitute_generated_columns": {
            }
          },
          {
            "table_dependencies": [
              {
                "table": "`t1`",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": [
                ]
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "`t1`",
                "table_scan": {
                  "rows": 1,
                  "cost": 1
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [
                ],
                "table": "`t1`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "rows_to_scan": 1,
                      "access_type": "scan",
                      "resulting_rows": 1,
                      "cost": 1.2,
                      "chosen": true,
                      "use_tmp_table": true
                    }
                  ]
                },
                "condition_filtering_pct": 100,
                "rows_for_plan": 1,
                "cost_for_plan": 1.2,
                "sort_cost": 1,
                "new_cost_for_plan": 2.2,
                "chosen": true
              }
            ]
          },
          {
            "attaching_conditions_to_tables": {
              "original_condition": null,
              "attached_conditions_computation": [
              ],
              "attached_conditions_summary": [
                {
                  "table": "`t1`",
                  "attached": null
                }
              ]
            }
          },
          {
            "clause_processing": {
              "clause": "ORDER BY",
              "original_clause": "`t1`.`c1`",
              "items": [
                {
                  "item": "`t1`.`c1`"
                }
              ],
              "resulting_clause_is_simple": true,
              "resulting_clause": "`t1`.`c1`"
            }
          },
          {
            "refine_plan": [
              {
                "table": "`t1`"
              }
            ]
          }
        ]
      }
    },
    {
      "join_execution": {
        "select#": 1,
        "steps": [
          {
            "filesort_information": [
              {
                "direction": "asc",
                "table": "`t1`",
                "field": "c1"
              }
            ],
            "filesort_priority_queue_optimization": {
              "usable": false,
              "cause": "not applicable (no LIMIT)"
            },
            "filesort_execution": [
            ],
            "filesort_summary": {
              "rows": 0,
              "examined_rows": 0,
              "number_of_tmp_files": 0,
              "sort_buffer_size": 998480,
              "sort_mode": "<sort_key, additional_fields>"
            }
          }
        ]
      }
    }
  ]
}	0	0
SET @@max_length_for_sort_data = 65535 + 1024;
SET @@sort_buffer_size = 8 + 15 * (@@max_length_for_sort_data + 8);
select * from t1 order by c1;
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
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY	TRACE	MISSING_BYTES_BEYOND_MAX_MEM_SIZE	INSUFFICIENT_PRIVILEGES
select * from t1 order by c1	{
  "steps": [
    {
      "join_preparation": {
        "select#": 1,
        "steps": [
          {
            "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`"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select#": 1,
        "steps": [
          {
            "substitute_generated_columns": {
            }
          },
          {
            "table_dependencies": [
              {
                "table": "`t1`",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": [
                ]
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "`t1`",
                "table_scan": {
                  "rows": 1,
                  "cost": 1
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [
                ],
                "table": "`t1`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "rows_to_scan": 1,
                      "access_type": "scan",
                      "resulting_rows": 1,
                      "cost": 1.2,
                      "chosen": true,
                      "use_tmp_table": true
                    }
                  ]
                },
                "condition_filtering_pct": 100,
                "rows_for_plan": 1,
                "cost_for_plan": 1.2,
                "sort_cost": 1,
                "new_cost_for_plan": 2.2,
                "chosen": true
              }
            ]
          },
          {
            "attaching_conditions_to_tables": {
              "original_condition": null,
              "attached_conditions_computation": [
              ],
              "attached_conditions_summary": [
                {
                  "table": "`t1`",
                  "attached": null
                }
              ]
            }
          },
          {
            "clause_processing": {
              "clause": "ORDER BY",
              "original_clause": "`t1`.`c1`",
              "items": [
                {
                  "item": "`t1`.`c1`"
                }
              ],
              "resulting_clause_is_simple": true,
              "resulting_clause": "`t1`.`c1`"
            }
          },
          {
            "refine_plan": [
              {
                "table": "`t1`"
              }
            ]
          }
        ]
      }
    },
    {
      "join_execution": {
        "select#": 1,
        "steps": [
          {
            "filesort_information": [
              {
                "direction": "asc",
                "table": "`t1`",
                "field": "c1"
              }
            ],
            "filesort_priority_queue_optimization": {
              "usable": false,
              "cause": "not applicable (no LIMIT)"
            },
            "filesort_execution": [
            ],
            "filesort_summary": {
              "rows": 0,
              "examined_rows": 0,
              "number_of_tmp_files": 0,
              "sort_buffer_size": 998512,
              "sort_mode": "<sort_key, packed_additional_fields>"
            }
          }
        ]
      }
    }
  ]
}	0	0
SET @@max_length_for_sort_data = @save_max_length_for_sort_data;
SET @@sort_buffer_size= @save_sort_buffer_size;
DROP TABLE t1;
SET innodb_strict_mode=off;
CREATE TABLE t1 (
c1 CHAR(255) NOT NULL DEFAULT '',
c2 CHAR(255) NOT NULL DEFAULT '',
c3 CHAR(255) NOT NULL DEFAULT '',
c4 CHAR(255) NOT NULL DEFAULT '',
c5 CHAR(255) NOT NULL DEFAULT '',
c6 CHAR(255) NOT NULL DEFAULT '',
c7 CHAR(255) NOT NULL DEFAULT '',
c8 CHAR(255) NOT NULL DEFAULT '',
c9 CHAR(255) NOT NULL DEFAULT '',
c10 CHAR(255) NOT NULL DEFAULT '',
c11 CHAR(255) NOT NULL DEFAULT '',
c12 CHAR(255) NOT NULL DEFAULT '',
c13 CHAR(255) NOT NULL DEFAULT '',
c14 CHAR(255) NOT NULL DEFAULT '',
c15 CHAR(255) NOT NULL DEFAULT '',
c16 CHAR(255) NOT NULL DEFAULT '',
c17 CHAR(255) NOT NULL DEFAULT '',
c18 CHAR(255) NOT NULL DEFAULT '',
c19 CHAR(255) NOT NULL DEFAULT '',
c20 CHAR(255) NOT NULL DEFAULT '',
c21 CHAR(255) NOT NULL DEFAULT '',
c22 CHAR(255) NOT NULL DEFAULT '',
c23 CHAR(255) NOT NULL DEFAULT '',
c24 CHAR(255) NOT NULL DEFAULT '',
c25 CHAR(255) NOT NULL DEFAULT '',
c26 CHAR(255) NOT NULL DEFAULT '',
c27 CHAR(255) NOT NULL DEFAULT '',
c28 CHAR(255) NOT NULL DEFAULT '',
c29 CHAR(255) NOT NULL DEFAULT '',
c30 CHAR(255) NOT NULL DEFAULT '',
c31 CHAR(255) NOT NULL DEFAULT '',
c32 CHAR(255) NOT NULL DEFAULT '',
c33 CHAR(255) NOT NULL DEFAULT '',
c34 CHAR(255) NOT NULL DEFAULT '',
c35 CHAR(255) NOT NULL DEFAULT '',
c36 CHAR(255) NOT NULL DEFAULT '',
c37 CHAR(255) NOT NULL DEFAULT '',
c38 CHAR(255) NOT NULL DEFAULT '',
c39 CHAR(255) NOT NULL DEFAULT '',
c40 CHAR(255) NOT NULL DEFAULT '',
c41 CHAR(255) NOT NULL DEFAULT '',
c42 CHAR(255) NOT NULL DEFAULT '',
c43 CHAR(255) NOT NULL DEFAULT '',
c44 CHAR(255) NOT NULL DEFAULT '',
c45 CHAR(255) NOT NULL DEFAULT '',
c46 CHAR(255) NOT NULL DEFAULT '',
c47 CHAR(255) NOT NULL DEFAULT '',
c48 CHAR(255) NOT NULL DEFAULT '',
c49 CHAR(255) NOT NULL DEFAULT '',
c50 CHAR(255) NOT NULL DEFAULT '',
c51 CHAR(255) NOT NULL DEFAULT '',
c52 CHAR(255) NOT NULL DEFAULT '',
c53 CHAR(255) NOT NULL DEFAULT '',
c54 CHAR(255) NOT NULL DEFAULT '',
c55 CHAR(255) NOT NULL DEFAULT '',
c56 CHAR(255) NOT NULL DEFAULT '',
c57 CHAR(255) NOT NULL DEFAULT '',
c58 CHAR(255) NOT NULL DEFAULT '',
c59 CHAR(255) NOT NULL DEFAULT '',
c60 CHAR(255) NOT NULL DEFAULT '',
c61 CHAR(255) NOT NULL DEFAULT '',
c62 CHAR(255) NOT NULL DEFAULT '',
c63 CHAR(255) NOT NULL DEFAULT '',
c64 CHAR(255) NOT NULL DEFAULT '',
c65 CHAR(255) NOT NULL DEFAULT '',
c66 CHAR(255) NOT NULL DEFAULT '',
c67 CHAR(255) NOT NULL DEFAULT '',
c68 CHAR(255) NOT NULL DEFAULT '',
c69 CHAR(255) NOT NULL DEFAULT '',
c70 CHAR(255) NOT NULL DEFAULT '',
c71 CHAR(255) NOT NULL DEFAULT '',
c72 CHAR(255) NOT NULL DEFAULT '',
c73 CHAR(255) NOT NULL DEFAULT '',
c74 CHAR(255) NOT NULL DEFAULT '',
c75 CHAR(255) NOT NULL DEFAULT '',
c76 CHAR(255) NOT NULL DEFAULT '',
c77 CHAR(255) NOT NULL DEFAULT '',
c78 CHAR(255) NOT NULL DEFAULT '',
c79 CHAR(255) NOT NULL DEFAULT '',
c80 CHAR(255) NOT NULL DEFAULT '',
c81 CHAR(255) NOT NULL DEFAULT '',
c82 CHAR(255) NOT NULL DEFAULT '',
c83 CHAR(255) NOT NULL DEFAULT '',
c84 CHAR(255) NOT NULL DEFAULT '',
c85 CHAR(255) NOT NULL DEFAULT '',
c86 CHAR(255) NOT NULL DEFAULT '',
c87 CHAR(255) NOT NULL DEFAULT '',
c88 CHAR(255) NOT NULL DEFAULT '',
c89 CHAR(255) NOT NULL DEFAULT '',
c90 CHAR(255) NOT NULL DEFAULT '',
c91 CHAR(255) NOT NULL DEFAULT '',
c92 CHAR(255) NOT NULL DEFAULT '',
c93 CHAR(255) NOT NULL DEFAULT '',
c94 CHAR(255) NOT NULL DEFAULT '',
c95 CHAR(255) NOT NULL DEFAULT '',
c96 CHAR(255) NOT NULL DEFAULT '',
c97 CHAR(255) NOT NULL DEFAULT '',
c98 CHAR(255) NOT NULL DEFAULT '',
c99 CHAR(255) NOT NULL DEFAULT '',
c100 CHAR(255) NOT NULL DEFAULT '',
c101 CHAR(255) NOT NULL DEFAULT '',
c102 CHAR(255) NOT NULL DEFAULT '',
c103 CHAR(255) NOT NULL DEFAULT '',
c104 CHAR(255) NOT NULL DEFAULT '',
c105 CHAR(255) NOT NULL DEFAULT '',
c106 CHAR(255) NOT NULL DEFAULT '',
c107 CHAR(255) NOT NULL DEFAULT '',
c108 CHAR(255) NOT NULL DEFAULT '',
c109 CHAR(255) NOT NULL DEFAULT '',
c110 CHAR(255) NOT NULL DEFAULT '',
c111 CHAR(255) NOT NULL DEFAULT '',
c112 CHAR(255) NOT NULL DEFAULT '',
c113 CHAR(255) NOT NULL DEFAULT '',
c114 CHAR(255) NOT NULL DEFAULT '',
c115 CHAR(255) NOT NULL DEFAULT '',
c116 CHAR(255) NOT NULL DEFAULT '',
c117 CHAR(255) NOT NULL DEFAULT '',
c118 CHAR(255) NOT NULL DEFAULT '',
c119 CHAR(255) NOT NULL DEFAULT '',
c120 CHAR(255) NOT NULL DEFAULT '',
c121 CHAR(255) NOT NULL DEFAULT '',
c122 CHAR(255) NOT NULL DEFAULT '',
c123 CHAR(255) NOT NULL DEFAULT '',
c124 CHAR(255) NOT NULL DEFAULT '',
c125 CHAR(255) NOT NULL DEFAULT '',
c126 CHAR(255) NOT NULL DEFAULT '',
c127 CHAR(255) NOT NULL DEFAULT '',
c128 CHAR(255) NOT NULL DEFAULT '',
c129 CHAR(255) NOT NULL DEFAULT '',
c130 CHAR(255) NOT NULL DEFAULT '',
c131 CHAR(255) NOT NULL DEFAULT '',
c132 CHAR(255) NOT NULL DEFAULT '',
c133 CHAR(255) NOT NULL DEFAULT '',
c134 CHAR(255) NOT NULL DEFAULT '',
c135 CHAR(255) NOT NULL DEFAULT '',
c136 CHAR(255) NOT NULL DEFAULT '',
c137 CHAR(255) NOT NULL DEFAULT '',
c138 CHAR(255) NOT NULL DEFAULT '',
c139 CHAR(255) NOT NULL DEFAULT '',
c140 CHAR(255) NOT NULL DEFAULT '',
c141 CHAR(255) NOT NULL DEFAULT '',
c142 CHAR(255) NOT NULL DEFAULT '',
c143 CHAR(255) NOT NULL DEFAULT '',
c144 CHAR(255) NOT NULL DEFAULT '',
c145 CHAR(255) NOT NULL DEFAULT '',
c146 CHAR(255) NOT NULL DEFAULT '',
c147 CHAR(255) NOT NULL DEFAULT '',
c148 CHAR(255) NOT NULL DEFAULT '',
c149 CHAR(255) NOT NULL DEFAULT '',
c150 CHAR(255) NOT NULL DEFAULT '',
c151 CHAR(255) NOT NULL DEFAULT '',
c152 CHAR(255) NOT NULL DEFAULT '',
c153 CHAR(255) NOT NULL DEFAULT '',
c154 CHAR(255) NOT NULL DEFAULT '',
c155 CHAR(255) NOT NULL DEFAULT '',
c156 CHAR(255) NOT NULL DEFAULT '',
c157 CHAR(255) NOT NULL DEFAULT '',
c158 CHAR(255) NOT NULL DEFAULT '',
c159 CHAR(255) NOT NULL DEFAULT '',
c160 CHAR(255) NOT NULL DEFAULT '',
c161 CHAR(255) NOT NULL DEFAULT '',
c162 CHAR(255) NOT NULL DEFAULT '',
c163 CHAR(255) NOT NULL DEFAULT '',
c164 CHAR(255) NOT NULL DEFAULT '',
c165 CHAR(255) NOT NULL DEFAULT '',
c166 CHAR(255) NOT NULL DEFAULT '',
c167 CHAR(255) NOT NULL DEFAULT '',
c168 CHAR(255) NOT NULL DEFAULT '',
c169 CHAR(255) NOT NULL DEFAULT '',
c170 CHAR(255) NOT NULL DEFAULT '',
c171 CHAR(255) NOT NULL DEFAULT '',
c172 CHAR(255) NOT NULL DEFAULT '',
c173 CHAR(255) NOT NULL DEFAULT '',
c174 CHAR(255) NOT NULL DEFAULT '',
c175 CHAR(255) NOT NULL DEFAULT '',
c176 CHAR(255) NOT NULL DEFAULT '',
c177 CHAR(255) NOT NULL DEFAULT '',
c178 CHAR(255) NOT NULL DEFAULT '',
c179 CHAR(255) NOT NULL DEFAULT '',
c180 CHAR(255) NOT NULL DEFAULT '',
c181 CHAR(255) NOT NULL DEFAULT '',
c182 CHAR(255) NOT NULL DEFAULT '',
c183 CHAR(255) NOT NULL DEFAULT '',
c184 CHAR(255) NOT NULL DEFAULT '',
c185 CHAR(255) NOT NULL DEFAULT '',
c186 CHAR(255) NOT NULL DEFAULT '',
c187 CHAR(255) NOT NULL DEFAULT '',
c188 CHAR(255) NOT NULL DEFAULT '',
c189 CHAR(255) NOT NULL DEFAULT '',
c190 CHAR(255) NOT NULL DEFAULT '',
c191 CHAR(255) NOT NULL DEFAULT '',
c192 CHAR(255) NOT NULL DEFAULT '',
c193 CHAR(255) NOT NULL DEFAULT '',
c194 CHAR(255) NOT NULL DEFAULT '',
c195 CHAR(255) NOT NULL DEFAULT '',
c196 CHAR(255) NOT NULL DEFAULT '',
c197 CHAR(255) NOT NULL DEFAULT '',
c198 CHAR(255) NOT NULL DEFAULT '',
c199 CHAR(255) NOT NULL DEFAULT '',
c200 CHAR(255) NOT NULL DEFAULT '',
c201 CHAR(255) NOT NULL DEFAULT '',
c202 CHAR(255) NOT NULL DEFAULT '',
c203 CHAR(255) NOT NULL DEFAULT '',
c204 CHAR(255) NOT NULL DEFAULT '',
c205 CHAR(255) NOT NULL DEFAULT '',
c206 CHAR(255) NOT NULL DEFAULT '',
c207 CHAR(255) NOT NULL DEFAULT '',
c208 CHAR(255) NOT NULL DEFAULT '',
c209 CHAR(255) NOT NULL DEFAULT '',
c210 CHAR(255) NOT NULL DEFAULT '',
c211 CHAR(255) NOT NULL DEFAULT '',
c212 CHAR(255) NOT NULL DEFAULT '',
c213 CHAR(255) NOT NULL DEFAULT '',
c214 CHAR(255) NOT NULL DEFAULT '',
c215 CHAR(255) NOT NULL DEFAULT '',
c216 CHAR(255) NOT NULL DEFAULT '',
c217 CHAR(255) NOT NULL DEFAULT '',
c218 CHAR(255) NOT NULL DEFAULT '',
c219 CHAR(255) NOT NULL DEFAULT '',
c220 CHAR(255) NOT NULL DEFAULT '',
c221 CHAR(255) NOT NULL DEFAULT '',
c222 CHAR(255) NOT NULL DEFAULT '',
c223 CHAR(255) NOT NULL DEFAULT '',
c224 CHAR(255) NOT NULL DEFAULT '',
c225 CHAR(255) NOT NULL DEFAULT '',
c226 CHAR(255) NOT NULL DEFAULT '',
c227 CHAR(255) NOT NULL DEFAULT '',
c228 CHAR(255) NOT NULL DEFAULT '',
c229 CHAR(255) NOT NULL DEFAULT '',
c230 CHAR(255) NOT NULL DEFAULT '',
c231 CHAR(255) NOT NULL DEFAULT '',
c232 CHAR(255) NOT NULL DEFAULT '',
c233 CHAR(255) NOT NULL DEFAULT '',
c234 CHAR(255) NOT NULL DEFAULT '',
c235 CHAR(255) NOT NULL DEFAULT '',
c236 CHAR(255) NOT NULL DEFAULT '',
c237 CHAR(255) NOT NULL DEFAULT '',
c238 CHAR(255) NOT NULL DEFAULT '',
c239 CHAR(255) NOT NULL DEFAULT '',
c240 CHAR(255) NOT NULL DEFAULT '',
c241 CHAR(255) NOT NULL DEFAULT '',
c242 CHAR(255) NOT NULL DEFAULT '',
c243 CHAR(255) NOT NULL DEFAULT '',
c244 CHAR(255) NOT NULL DEFAULT '',
c245 CHAR(255) NOT NULL DEFAULT '',
c246 CHAR(255) NOT NULL DEFAULT '',
c247 CHAR(255) NOT NULL DEFAULT '',
c248 CHAR(255) NOT NULL DEFAULT '',
c249 CHAR(255) NOT NULL DEFAULT '',
c250 CHAR(255) NOT NULL DEFAULT '',
c251 CHAR(255) NOT NULL DEFAULT '',
c252 CHAR(255) NOT NULL DEFAULT '',
c253 CHAR(255) NOT NULL DEFAULT '',
c254 CHAR(255) NOT NULL DEFAULT '',
c255 CHAR(255) NOT NULL DEFAULT '',
c256 CHAR(255) NOT NULL DEFAULT '',
c257 CHAR(254) NOT NULL DEFAULT ''
) ENGINE = INNODB ROW_FORMAT=COMPACT;
Warnings:
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.
SELECT * FROM t1 ORDER BY c1;
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
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY	TRACE	MISSING_BYTES_BEYOND_MAX_MEM_SIZE	INSUFFICIENT_PRIVILEGES
SELECT * FROM t1 ORDER BY c1	{
  "steps": [
    {
      "join_preparation": {
        "select#": 1,
        "steps": [
          {
            "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`"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select#": 1,
        "steps": [
          {
            "substitute_generated_columns": {
            }
          },
          {
            "table_dependencies": [
              {
                "table": "`t1`",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": [
                ]
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "`t1`",
                "table_scan": {
                  "rows": 1,
                  "cost": 1
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [
                ],
                "table": "`t1`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "rows_to_scan": 1,
                      "access_type": "scan",
                      "resulting_rows": 1,
                      "cost": 1.2,
                      "chosen": true,
                      "use_tmp_table": true
                    }
                  ]
                },
                "condition_filtering_pct": 100,
                "rows_for_plan": 1,
                "cost_for_plan": 1.2,
                "sort_cost": 1,
                "new_cost_for_plan": 2.2,
                "chosen": true
              }
            ]
          },
          {
            "attaching_conditions_to_tables": {
              "original_condition": null,
              "attached_conditions_computation": [
              ],
              "attached_conditions_summary": [
                {
                  "table": "`t1`",
                  "attached": null
                }
              ]
            }
          },
          {
            "clause_processing": {
              "clause": "ORDER BY",
              "original_clause": "`t1`.`c1`",
              "items": [
                {
                  "item": "`t1`.`c1`"
                }
              ],
              "resulting_clause_is_simple": true,
              "resulting_clause": "`t1`.`c1`"
            }
          },
          {
            "refine_plan": [
              {
                "table": "`t1`"
              }
            ]
          }
        ]
      }
    },
    {
      "join_execution": {
        "select#": 1,
        "steps": [
          {
            "filesort_information": [
              {
                "direction": "asc",
                "table": "`t1`",
                "field": "c1"
              }
            ],
            "filesort_priority_queue_optimization": {
              "usable": false,
              "cause": "not applicable (no LIMIT)"
            },
            "filesort_execution": [
            ],
            "filesort_summary": {
              "rows": 0,
              "examined_rows": 0,
              "number_of_tmp_files": 0,
              "sort_buffer_size": 4040,
              "sort_mode": "<sort_key, rowid>"
            }
          }
        ]
      }
    }
  ]
}	0	0
DROP TABLE t1;