diff options
Diffstat (limited to 'mysql-test/main/win_empty_over.result')
| -rw-r--r-- | mysql-test/main/win_empty_over.result | 68 |
1 files changed, 40 insertions, 28 deletions
diff --git a/mysql-test/main/win_empty_over.result b/mysql-test/main/win_empty_over.result index a5ee74b943a..4fa53bb4eae 100644 --- a/mysql-test/main/win_empty_over.result +++ b/mysql-test/main/win_empty_over.result @@ -37,22 +37,28 @@ EXPLAIN "query_block": { "select_id": 1, "window_functions_computation": { - "sorts": { - "filesort": { - "sort_key": "pk" + "sorts": [ + { + "filesort": { + "sort_key": "pk" + } } - }, + ], "temporary_table": { - "table": { - "table_name": "t1", - "access_type": "index", - "key": "PRIMARY", - "key_length": "4", - "used_key_parts": ["pk"], - "rows": 11, - "filtered": 100, - "using_index": true - } + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "index", + "key": "PRIMARY", + "key_length": "4", + "used_key_parts": ["pk"], + "rows": 11, + "filtered": 100, + "using_index": true + } + } + ] } } } @@ -63,22 +69,28 @@ EXPLAIN "query_block": { "select_id": 1, "window_functions_computation": { - "sorts": { - "filesort": { - "sort_key": "`row_number() over ()`" + "sorts": [ + { + "filesort": { + "sort_key": "`row_number() over ()`" + } } - }, + ], "temporary_table": { - "table": { - "table_name": "t1", - "access_type": "index", - "key": "PRIMARY", - "key_length": "4", - "used_key_parts": ["pk"], - "rows": 11, - "filtered": 100, - "using_index": true - } + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "index", + "key": "PRIMARY", + "key_length": "4", + "used_key_parts": ["pk"], + "rows": 11, + "filtered": 100, + "using_index": true + } + } + ] } } } |