diff options
Diffstat (limited to 'mysql-test/r/subselect_cache.result')
| -rw-r--r-- | mysql-test/r/subselect_cache.result | 235 |
1 files changed, 113 insertions, 122 deletions
diff --git a/mysql-test/r/subselect_cache.result b/mysql-test/r/subselect_cache.result index 2cf1961ec5b..8ca6bf52e0e 100644 --- a/mysql-test/r/subselect_cache.result +++ b/mysql-test/r/subselect_cache.result @@ -59,27 +59,24 @@ ANALYZE }, "subqueries": [ { - "query_block": { - "select_id": 2, - "r_loops": 4, - "r_total_time_ms": "REPLACED", - "expression_cache": { - "state": "ENABLED", - "r_hit": 6, - "r_miss": 4, - "r_loops": 10, - "r_hit_ratio": 60 - }, - "table": { - "table_name": "t2", - "access_type": "ALL", + "expression_cache": { + "r_loops": 10, + "r_hit_ratio": 60, + "query_block": { + "select_id": 2, "r_loops": 4, - "rows": 4, - "r_rows": 4, "r_total_time_ms": "REPLACED", - "filtered": 100, - "r_filtered": 18.75, - "attached_condition": "(t1.b = t2.c)" + "table": { + "table_name": "t2", + "access_type": "ALL", + "r_loops": 4, + "rows": 4, + "r_rows": 4, + "r_total_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 18.75, + "attached_condition": "(t1.b = t2.c)" + } } } } @@ -106,72 +103,66 @@ ANALYZE }, "subqueries": [ { - "query_block": { - "union_result": { - "table_name": "<union3,4>", - "access_type": "ALL", - "r_loops": 4, - "r_rows": 1, - "expression_cache": { - "state": "ENABLED", - "r_hit": 6, - "r_miss": 4, - "r_loops": 10, - "r_hit_ratio": 60 - }, - "query_specifications": [ - { - "query_block": { - "select_id": 3, - "r_loops": 4, - "r_total_time_ms": "REPLACED", - "table": { - "table_name": "t2", - "access_type": "ALL", + "expression_cache": { + "r_loops": 10, + "r_hit_ratio": 60, + "query_block": { + "union_result": { + "table_name": "<union3,4>", + "access_type": "ALL", + "r_loops": 4, + "r_rows": 1, + "query_specifications": [ + { + "query_block": { + "select_id": 3, "r_loops": 4, - "rows": 4, - "r_rows": 4, "r_total_time_ms": "REPLACED", - "filtered": 100, - "r_filtered": 18.75, - "attached_condition": "(t1.b = t2.c)" + "table": { + "table_name": "t2", + "access_type": "ALL", + "r_loops": 4, + "rows": 4, + "r_rows": 4, + "r_total_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 18.75, + "attached_condition": "(t1.b = t2.c)" + } } - } - }, - { - "query_block": { - "select_id": 4, - "table": { - "message": "No tables used" + }, + { + "query_block": { + "select_id": 4, + "table": { + "message": "No tables used" + } } } - } - ] + ] + } } } }, { - "query_block": { - "select_id": 2, - "r_loops": 4, - "r_total_time_ms": "REPLACED", - "expression_cache": { - "state": "ENABLED", - "r_hit": 6, - "r_miss": 4, - "r_loops": 10, - "r_hit_ratio": 60 - }, - "table": { - "table_name": "t2", - "access_type": "ALL", + "expression_cache": { + "r_loops": 10, + "r_hit_ratio": 60, + "query_block": { + "select_id": 2, "r_loops": 4, - "rows": 4, - "r_rows": 4, "r_total_time_ms": "REPLACED", - "filtered": 100, - "r_filtered": 18.75, - "attached_condition": "(t1.b = t2.c)" + "table": { + "table_name": "t2", + "access_type": "ALL", + "r_loops": 4, + "rows": 4, + "r_rows": 4, + "r_total_time_ms": "REPLACED", + "filtered": 100, + "r_filtered": 18.75, + "attached_condition": "(t1.b = t2.c)" + } } } } @@ -192,17 +183,17 @@ EXPLAIN }, "subqueries": [ { - "query_block": { - "select_id": 2, - "expression_cache": { - "state": "UNINITIALYZED" - }, - "table": { - "table_name": "t2", - "access_type": "ALL", - "rows": 4, - "filtered": 100, - "attached_condition": "(t1.b = t2.c)" + "expression_cache": { + "state": "uninitialized", + "query_block": { + "select_id": 2, + "table": { + "table_name": "t2", + "access_type": "ALL", + "rows": 4, + "filtered": 100, + "attached_condition": "(t1.b = t2.c)" + } } } } @@ -223,50 +214,50 @@ EXPLAIN }, "subqueries": [ { - "query_block": { - "union_result": { - "table_name": "<union3,4>", - "access_type": "ALL", - "expression_cache": { - "state": "UNINITIALYZED" - }, - "query_specifications": [ - { - "query_block": { - "select_id": 3, - "table": { - "table_name": "t2", - "access_type": "ALL", - "rows": 4, - "filtered": 100, - "attached_condition": "(t1.b = t2.c)" + "expression_cache": { + "state": "uninitialized", + "query_block": { + "union_result": { + "table_name": "<union3,4>", + "access_type": "ALL", + "query_specifications": [ + { + "query_block": { + "select_id": 3, + "table": { + "table_name": "t2", + "access_type": "ALL", + "rows": 4, + "filtered": 100, + "attached_condition": "(t1.b = t2.c)" + } } - } - }, - { - "query_block": { - "select_id": 4, - "table": { - "message": "No tables used" + }, + { + "query_block": { + "select_id": 4, + "table": { + "message": "No tables used" + } } } - } - ] + ] + } } } }, { - "query_block": { - "select_id": 2, - "expression_cache": { - "state": "UNINITIALYZED" - }, - "table": { - "table_name": "t2", - "access_type": "ALL", - "rows": 4, - "filtered": 100, - "attached_condition": "(t1.b = t2.c)" + "expression_cache": { + "state": "uninitialized", + "query_block": { + "select_id": 2, + "table": { + "table_name": "t2", + "access_type": "ALL", + "rows": 4, + "filtered": 100, + "attached_condition": "(t1.b = t2.c)" + } } } } |