mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------------+
| section           |
+-------------------+
| initial variables |
+-------------------+
+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| version | optimizer_switch                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 9.7.1   | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=on,hash_set_operations=on |
+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------------------------------+---------+----------+----------+
| Table                                            | Op      | Msg_type | Msg_text |
+--------------------------------------------------+---------+----------+----------+
| mysql_order_limit_equivalent_order_key_missed.t0 | analyze | status   | OK       |
| mysql_order_limit_equivalent_order_key_missed.t1 | analyze | status   | OK       |
+--------------------------------------------------+---------+----------+----------+
+------------+
| section    |
+------------+
| data shape |
+------------+
+---------+---------+--------+-----------------+--------+-----------------+
| t0_rows | t1_rows | t0_ndv | t0_rows_per_key | t1_ndv | t1_rows_per_key |
+---------+---------+--------+-----------------+--------+-----------------+
|   48000 |   72000 |   4000 |         12.0000 |   4000 |         18.0000 |
+---------+---------+--------+-----------------+--------+-----------------+
+------------------+
| section          |
+------------------+
| join cardinality |
+------------------+
+-------------------------+
| join_rows_before_filter |
+-------------------------+
|                  864000 |
+-------------------------+
+------------------------+
| join_rows_after_filter |
+------------------------+
|                 859680 |
+------------------------+
+-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| Table | Non_unique | Key_name     | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
+-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| t0    |          1 | idx_t0_c0    |            1 | c0          | A         |        3965 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
| t0    |          1 | idx_t0_c0_c1 |            1 | c0          | A         |        3995 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
| t0    |          1 | idx_t0_c0_c1 |            2 | c1          | A         |        3995 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
+-------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
+-------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| Table | Non_unique | Key_name        | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
+-------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| t1    |          1 | idx_t1_c0       |            1 | c0          | A         |        3894 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
| t1    |          1 | idx_t1_c1       |            1 | c1          | A         |       71685 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
| t1    |          1 | idx_t1_c3_c0_c2 |            1 | c3          | A         |       71685 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
| t1    |          1 | idx_t1_c3_c0_c2 |            2 | c0          | A         |       71685 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
| t1    |          1 | idx_t1_c3_c0_c2 |            3 | c2          | A         |       71685 |     NULL |   NULL | YES  | BTREE      |         |               | YES     | NULL       |
+-------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
+-------------------------------------------+
| section                                   |
+-------------------------------------------+
| 1A Original ORDER BY t0.c0, t1.c3 LIMIT 3 |
+-------------------------------------------+
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query": "/* select#1 */ select `mysql_order_limit_equivalent_order_key_missed`.`t1`.`c2` AS `ref0` from `mysql_order_limit_equivalent_order_key_missed`.`t1` join `mysql_order_limit_equivalent_order_key_missed`.`t0` where ((`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c0` = `mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0`) and (`mysql_order_limit_equivalent_order_key_missed`.`t0`.`c4` is not null)) order by `mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0`,`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c3` desc limit 3",
  "query_plan": {
    "limit": 3,
    "inputs": [
      {
        "inputs": [
          {
            "inputs": [
              {
                "inputs": [
                  {
                    "inputs": [
                      {
                        "operation": "Table scan on t0",
                        "table_name": "t0",
                        "access_type": "table",
                        "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                        "used_columns": [
                          "c0",
                          "c4"
                        ],
                        "estimated_rows": 48167.0,
                        "estimated_total_cost": 4872.950000000001
                      }
                    ],
                    "condition": "((t0.c4 is not null) and (t0.c0 is not null))",
                    "operation": "Filter: ((t0.c4 is not null) and (t0.c0 is not null))",
                    "access_type": "filter",
                    "estimated_rows": 43350.29885160923,
                    "filter_columns": [
                      "mysql_order_limit_equivalent_order_key_missed.t0.c0",
                      "mysql_order_limit_equivalent_order_key_missed.t0.c4"
                    ],
                    "estimated_total_cost": 4872.950000000001
                  },
                  {
                    "covering": false,
                    "operation": "Index lookup on t1 using idx_t1_c0 (c0 = t0.c0)",
                    "index_name": "idx_t1_c0",
                    "table_name": "t1",
                    "access_type": "index",
                    "key_columns": [
                      "c0"
                    ],
                    "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                    "used_columns": [
                      "c0",
                      "c2",
                      "c3"
                    ],
                    "estimated_rows": 18.409090042114258,
                    "lookup_condition": "c0 = t0.c0",
                    "index_access_type": "index_lookup",
                    "lookup_references": [
                      "mysql_order_limit_equivalent_order_key_missed.t0.c0"
                    ],
                    "estimated_total_cost": 4.602314976418143
                  }
                ],
                "join_type": "inner join",
                "operation": "Nested loop inner join",
                "access_type": "join",
                "estimated_rows": 798039.5549118366,
                "join_algorithm": "nested_loop",
                "estimated_total_cost": 284186.7942191429
              }
            ],
            "operation": "Stream results",
            "access_type": "stream",
            "estimated_rows": 798039.5549118366,
            "estimated_total_cost": 284186.7942191429
          }
        ],
        "operation": "Sort: t0.c0, t1.c3 DESC, limit input to 3 row(s) per chunk",
        "access_type": "sort",
        "sort_fields": [
          "t0.c0",
          "t1.c3 DESC"
        ],
        "per_chunk_limit": 3
      }
    ],
    "operation": "Limit: 3 row(s)",
    "access_type": "limit",
    "limit_offset": 0
  },
  "query_type": "select",
  "json_schema_version": "2.0"
} |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| -> Limit: 3 row(s)  (actual time=1777..1777 rows=3 loops=1)
    -> Sort: t0.c0, t1.c3 DESC, limit input to 3 row(s) per chunk  (actual time=1777..1777 rows=3 loops=1)
        -> Stream results  (cost=284187 rows=798040) (actual time=0.0225..1595 rows=859680 loops=1)
            -> Nested loop inner join  (cost=284187 rows=798040) (actual time=0.0204..1415 rows=859680 loops=1)
                -> Filter: ((t0.c4 is not null) and (t0.c0 is not null))  (cost=4873 rows=43350) (actual time=0.00843..29.3 rows=47760 loops=1)
                    -> Table scan on t0  (cost=4873 rows=48167) (actual time=0.00609..24.1 rows=48000 loops=1)
                -> Index lookup on t1 using idx_t1_c0 (c0 = t0.c0)  (cost=4.6 rows=18.4) (actual time=0.00239..0.0278 rows=18 loops=47760)
 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+-----------------------------------------------------+
| section                                             |
+-----------------------------------------------------+
| 2A Equivalent rewrite ORDER BY t1.c0, t1.c3 LIMIT 3 |
+-----------------------------------------------------+
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query": "/* select#1 */ select `mysql_order_limit_equivalent_order_key_missed`.`t1`.`c2` AS `ref0` from `mysql_order_limit_equivalent_order_key_missed`.`t1` join `mysql_order_limit_equivalent_order_key_missed`.`t0` where ((`mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0` = `mysql_order_limit_equivalent_order_key_missed`.`t1`.`c0`) and (`mysql_order_limit_equivalent_order_key_missed`.`t0`.`c4` is not null)) order by `mysql_order_limit_equivalent_order_key_missed`.`t1`.`c0`,`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c3` desc limit 3",
  "query_plan": {
    "limit": 3,
    "inputs": [
      {
        "inputs": [
          {
            "inputs": [
              {
                "inputs": [
                  {
                    "covering": true,
                    "operation": "Covering index scan on t1 using idx_t1_c3_c0_c2",
                    "index_name": "idx_t1_c3_c0_c2",
                    "table_name": "t1",
                    "access_type": "index",
                    "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                    "used_columns": [
                      "c0",
                      "c2",
                      "c3"
                    ],
                    "estimated_rows": 71685.0,
                    "index_access_type": "index_scan",
                    "estimated_total_cost": 7272.75
                  }
                ],
                "condition": "(t1.c0 is not null)",
                "operation": "Filter: (t1.c0 is not null)",
                "access_type": "filter",
                "estimated_rows": 71685.0,
                "filter_columns": [
                  "mysql_order_limit_equivalent_order_key_missed.t1.c0"
                ],
                "estimated_total_cost": 7272.75
              }
            ],
            "operation": "Sort: t1.c0, t1.c3 DESC",
            "access_type": "sort",
            "sort_fields": [
              "t1.c0",
              "t1.c3 DESC"
            ],
            "estimated_rows": 71685.0,
            "estimated_total_cost": 7272.75
          },
          {
            "inputs": [
              {
                "covering": false,
                "operation": "Index lookup on t0 using idx_t0_c0_c1 (c0 = t1.c0)",
                "index_name": "idx_t0_c0_c1",
                "table_name": "t0",
                "access_type": "index",
                "key_columns": [
                  "c0"
                ],
                "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                "used_columns": [
                  "c0",
                  "c4"
                ],
                "estimated_rows": 12.0568208694458,
                "lookup_condition": "c0 = t1.c0",
                "index_access_type": "index_lookup",
                "lookup_references": [
                  "mysql_order_limit_equivalent_order_key_missed.t1.c0"
                ],
                "estimated_total_cost": 3.014220354612611
              }
            ],
            "condition": "(t0.c4 is not null)",
            "operation": "Filter: (t0.c4 is not null)",
            "access_type": "filter",
            "estimated_rows": 10.85113849504421,
            "filter_columns": [
              "mysql_order_limit_equivalent_order_key_missed.t0.c4"
            ],
            "estimated_total_cost": 3.014220354612611
          }
        ],
        "join_type": "inner join",
        "operation": "Nested loop inner join",
        "access_type": "join",
        "estimated_rows": 777863.8630172443,
        "join_algorithm": "nested_loop",
        "estimated_total_cost": 309775.3714091778
      }
    ],
    "operation": "Limit: 3 row(s)",
    "access_type": "limit",
    "limit_offset": 0,
    "estimated_rows": 3.0,
    "estimated_total_cost": 309775.3714091778
  },
  "query_type": "select",
  "json_schema_version": "2.0"
} |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| -> Limit: 3 row(s)  (cost=309775 rows=3) (actual time=191..191 rows=3 loops=1)
    -> Nested loop inner join  (cost=309775 rows=777864) (actual time=191..191 rows=3 loops=1)
        -> Sort: t1.c0, t1.c3 DESC  (cost=7273 rows=71685) (actual time=191..191 rows=19 loops=1)
            -> Filter: (t1.c0 is not null)  (cost=7273 rows=71685) (actual time=13.5..141 rows=72000 loops=1)
                -> Covering index scan on t1 using idx_t1_c3_c0_c2  (cost=7273 rows=71685) (actual time=13.5..137 rows=72000 loops=1)
        -> Filter: (t0.c4 is not null)  (cost=3.01 rows=10.9) (actual time=0.0191..0.0193 rows=0.158 loops=19)
            -> Index lookup on t0 using idx_t0_c0_c1 (c0 = t1.c0)  (cost=3.01 rows=12.1) (actual time=0.00312..0.0186 rows=11.5 loops=19)
 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------------------+
| section                              |
+--------------------------------------+
| 2B First rows with original ORDER BY |
+--------------------------------------+
+-------+-------+---------------------+--------+
| t0_c0 | t1_c0 | c3                  | ref0   |
+-------+-------+---------------------+--------+
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
+-------+-------+---------------------+--------+
+------------------------------------------------+
| section                                        |
+------------------------------------------------+
| 2C First rows with equivalent ORDER BY rewrite |
+------------------------------------------------+
+-------+-------+---------------------+--------+
| t0_c0 | t1_c0 | c3                  | ref0   |
+-------+-------+---------------------+--------+
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
|     1 |     1 | gaussian_1_3_940097 | 1153.7 |
+-------+-------+---------------------+--------+
+-------------------------------------------+
| section                                   |
+-------------------------------------------+
| 3A Original with prefer_ordering_index=on |
+-------------------------------------------+
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query": "/* select#1 */ select `mysql_order_limit_equivalent_order_key_missed`.`t1`.`c2` AS `ref0` from `mysql_order_limit_equivalent_order_key_missed`.`t1` join `mysql_order_limit_equivalent_order_key_missed`.`t0` where ((`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c0` = `mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0`) and (`mysql_order_limit_equivalent_order_key_missed`.`t0`.`c4` is not null)) order by `mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0`,`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c3` desc limit 3",
  "query_plan": {
    "limit": 3,
    "inputs": [
      {
        "inputs": [
          {
            "inputs": [
              {
                "inputs": [
                  {
                    "inputs": [
                      {
                        "operation": "Table scan on t0",
                        "table_name": "t0",
                        "access_type": "table",
                        "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                        "used_columns": [
                          "c0",
                          "c4"
                        ],
                        "estimated_rows": 48167.0,
                        "estimated_total_cost": 4872.950000000001
                      }
                    ],
                    "condition": "((t0.c4 is not null) and (t0.c0 is not null))",
                    "operation": "Filter: ((t0.c4 is not null) and (t0.c0 is not null))",
                    "access_type": "filter",
                    "estimated_rows": 43350.29885160923,
                    "filter_columns": [
                      "mysql_order_limit_equivalent_order_key_missed.t0.c0",
                      "mysql_order_limit_equivalent_order_key_missed.t0.c4"
                    ],
                    "estimated_total_cost": 4872.950000000001
                  },
                  {
                    "covering": false,
                    "operation": "Index lookup on t1 using idx_t1_c0 (c0 = t0.c0)",
                    "index_name": "idx_t1_c0",
                    "table_name": "t1",
                    "access_type": "index",
                    "key_columns": [
                      "c0"
                    ],
                    "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                    "used_columns": [
                      "c0",
                      "c2",
                      "c3"
                    ],
                    "estimated_rows": 18.409090042114258,
                    "lookup_condition": "c0 = t0.c0",
                    "index_access_type": "index_lookup",
                    "lookup_references": [
                      "mysql_order_limit_equivalent_order_key_missed.t0.c0"
                    ],
                    "estimated_total_cost": 4.602314976418143
                  }
                ],
                "join_type": "inner join",
                "operation": "Nested loop inner join",
                "access_type": "join",
                "estimated_rows": 798039.5549118366,
                "join_algorithm": "nested_loop",
                "estimated_total_cost": 284186.7942191429
              }
            ],
            "operation": "Stream results",
            "access_type": "stream",
            "estimated_rows": 798039.5549118366,
            "estimated_total_cost": 284186.7942191429
          }
        ],
        "operation": "Sort: t0.c0, t1.c3 DESC, limit input to 3 row(s) per chunk",
        "access_type": "sort",
        "sort_fields": [
          "t0.c0",
          "t1.c3 DESC"
        ],
        "per_chunk_limit": 3
      }
    ],
    "operation": "Limit: 3 row(s)",
    "access_type": "limit",
    "limit_offset": 0
  },
  "query_type": "select",
  "json_schema_version": "2.0"
} |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------------------------+
| section                                    |
+--------------------------------------------+
| 3B Original with prefer_ordering_index=off |
+--------------------------------------------+
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query": "/* select#1 */ select `mysql_order_limit_equivalent_order_key_missed`.`t1`.`c2` AS `ref0` from `mysql_order_limit_equivalent_order_key_missed`.`t1` join `mysql_order_limit_equivalent_order_key_missed`.`t0` where ((`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c0` = `mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0`) and (`mysql_order_limit_equivalent_order_key_missed`.`t0`.`c4` is not null)) order by `mysql_order_limit_equivalent_order_key_missed`.`t0`.`c0`,`mysql_order_limit_equivalent_order_key_missed`.`t1`.`c3` desc limit 3",
  "query_plan": {
    "limit": 3,
    "inputs": [
      {
        "inputs": [
          {
            "inputs": [
              {
                "inputs": [
                  {
                    "inputs": [
                      {
                        "operation": "Table scan on t0",
                        "table_name": "t0",
                        "access_type": "table",
                        "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                        "used_columns": [
                          "c0",
                          "c4"
                        ],
                        "estimated_rows": 48167.0,
                        "estimated_total_cost": 4872.950000000001
                      }
                    ],
                    "condition": "((t0.c4 is not null) and (t0.c0 is not null))",
                    "operation": "Filter: ((t0.c4 is not null) and (t0.c0 is not null))",
                    "access_type": "filter",
                    "estimated_rows": 43350.29885160923,
                    "filter_columns": [
                      "mysql_order_limit_equivalent_order_key_missed.t0.c0",
                      "mysql_order_limit_equivalent_order_key_missed.t0.c4"
                    ],
                    "estimated_total_cost": 4872.950000000001
                  },
                  {
                    "covering": false,
                    "operation": "Index lookup on t1 using idx_t1_c0 (c0 = t0.c0)",
                    "index_name": "idx_t1_c0",
                    "table_name": "t1",
                    "access_type": "index",
                    "key_columns": [
                      "c0"
                    ],
                    "schema_name": "mysql_order_limit_equivalent_order_key_missed",
                    "used_columns": [
                      "c0",
                      "c2",
                      "c3"
                    ],
                    "estimated_rows": 18.409090042114258,
                    "lookup_condition": "c0 = t0.c0",
                    "index_access_type": "index_lookup",
                    "lookup_references": [
                      "mysql_order_limit_equivalent_order_key_missed.t0.c0"
                    ],
                    "estimated_total_cost": 4.602314976418143
                  }
                ],
                "join_type": "inner join",
                "operation": "Nested loop inner join",
                "access_type": "join",
                "estimated_rows": 798039.5549118366,
                "join_algorithm": "nested_loop",
                "estimated_total_cost": 284186.7942191429
              }
            ],
            "operation": "Stream results",
            "access_type": "stream",
            "estimated_rows": 798039.5549118366,
            "estimated_total_cost": 284186.7942191429
          }
        ],
        "operation": "Sort: t0.c0, t1.c3 DESC, limit input to 3 row(s) per chunk",
        "access_type": "sort",
        "sort_fields": [
          "t0.c0",
          "t1.c3 DESC"
        ],
        "per_chunk_limit": 3
      }
    ],
    "operation": "Limit: 3 row(s)",
    "access_type": "limit",
    "limit_offset": 0
  },
  "query_type": "select",
  "json_schema_version": "2.0"
} |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------------+
| section                        |
+--------------------------------+
| 4A Original ORDER BY LIMIT 300 |
+--------------------------------+
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| -> Limit: 300 row(s)  (actual time=1800..1801 rows=300 loops=1)
    -> Sort: t0.c0, t1.c3 DESC, limit input to 300 row(s) per chunk  (actual time=1800..1800 rows=300 loops=1)
        -> Stream results  (cost=284187 rows=798040) (actual time=0.0293..1594 rows=859680 loops=1)
            -> Nested loop inner join  (cost=284187 rows=798040) (actual time=0.0264..1412 rows=859680 loops=1)
                -> Filter: ((t0.c4 is not null) and (t0.c0 is not null))  (cost=4873 rows=43350) (actual time=0.013..29.7 rows=47760 loops=1)
                    -> Table scan on t0  (cost=4873 rows=48167) (actual time=0.00954..24.3 rows=48000 loops=1)
                -> Index lookup on t1 using idx_t1_c0 (c0 = t0.c0)  (cost=4.6 rows=18.4) (actual time=0.00244..0.0277 rows=18 loops=47760)
 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+------------------------------------------+
| section                                  |
+------------------------------------------+
| 4B Equivalent rewrite ORDER BY LIMIT 300 |
+------------------------------------------+
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| -> Limit: 300 row(s)  (cost=309775 rows=300) (actual time=86.1..86.6 rows=300 loops=1)
    -> Nested loop inner join  (cost=309775 rows=777864) (actual time=86.1..86.6 rows=300 loops=1)
        -> Sort: t1.c0, t1.c3 DESC  (cost=7273 rows=71685) (actual time=85.7..85.7 rows=43 loops=1)
            -> Filter: (t1.c0 is not null)  (cost=7273 rows=71685) (actual time=0.00988..36.5 rows=72000 loops=1)
                -> Covering index scan on t1 using idx_t1_c3_c0_c2  (cost=7273 rows=71685) (actual time=0.00934..32.3 rows=72000 loops=1)
        -> Filter: (t0.c4 is not null)  (cost=3.01 rows=10.9) (actual time=0.00961..0.0193 rows=6.98 loops=43)
            -> Index lookup on t0 using idx_t0_c0_c1 (c0 = t1.c0)  (cost=3.01 rows=12.1) (actual time=0.0026..0.0185 rows=12 loops=43)
 |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+---------+
| section |
+---------+
| done    |
+---------+
