summaryrefslogtreecommitdiff
path: root/mysql-test/main/opt_trace_ucs2.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/opt_trace_ucs2.result')
-rw-r--r--mysql-test/main/opt_trace_ucs2.result26
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;