diff options
Diffstat (limited to 'mysql-test/main/opt_trace_ucs2.result')
-rw-r--r-- | mysql-test/main/opt_trace_ucs2.result | 26 |
1 files changed, 15 insertions, 11 deletions
diff --git a/mysql-test/main/opt_trace_ucs2.result b/mysql-test/main/opt_trace_ucs2.result index 5de1fc5c3e9..d8ecefddd5e 100644 --- a/mysql-test/main/opt_trace_ucs2.result +++ b/mysql-test/main/opt_trace_ucs2.result @@ -7,17 +7,21 @@ EXPLAIN { "query_block": { "select_id": 1, - "table": { - "table_name": "t1", - "access_type": "range", - "possible_keys": ["col1"], - "key": "col1", - "key_length": "21", - "used_key_parts": ["col1"], - "rows": 2, - "filtered": 100, - "index_condition": "t1.col1 >= 'a'" - } + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "range", + "possible_keys": ["col1"], + "key": "col1", + "key_length": "21", + "used_key_parts": ["col1"], + "rows": 2, + "filtered": 100, + "index_condition": "t1.col1 >= 'a'" + } + } + ] } } select JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; |