diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2015-04-12 06:07:58 +0200 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2015-04-12 06:07:58 +0200 |
| commit | 2bbf3b89f66e391b126108fc3c4d4a5d2e440a38 (patch) | |
| tree | b0a825e0d2d14db7be50bb418c7e24208b27e983 /mysql-test/r/explain_json.result | |
| parent | cc8da9b75aa8ed99be8ef5a7a765c9a4fb059014 (diff) | |
| download | mariadb-git-2bbf3b89f66e391b126108fc3c4d4a5d2e440a38.tar.gz | |
MDEV-7836: ANALYZE FORMAT=JSON should provide info about GROUP/ORDER BY
Fix EXPLAIN FORMAT=JSON to produce output that's not worse than
the tabular form.
Diffstat (limited to 'mysql-test/r/explain_json.result')
| -rw-r--r-- | mysql-test/r/explain_json.result | 32 |
1 files changed, 18 insertions, 14 deletions
diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result index 1d3f8e82718..e08cd9780fd 100644 --- a/mysql-test/r/explain_json.result +++ b/mysql-test/r/explain_json.result @@ -479,13 +479,15 @@ EXPLAIN "materialized": { "query_block": { "select_id": 2, - "temporary_table": { - "function": "buffer", - "table": { - "table_name": "t1", - "access_type": "ALL", - "rows": 10, - "filtered": 100 + "filesort": { + "temporary_table": { + "function": "buffer", + "table": { + "table_name": "t1", + "access_type": "ALL", + "rows": 10, + "filtered": 100 + } } } } @@ -521,13 +523,15 @@ EXPLAIN "materialized": { "query_block": { "select_id": 2, - "temporary_table": { - "function": "buffer", - "table": { - "table_name": "t1", - "access_type": "ALL", - "rows": 10, - "filtered": 100 + "filesort": { + "temporary_table": { + "function": "buffer", + "table": { + "table_name": "t1", + "access_type": "ALL", + "rows": 10, + "filtered": 100 + } } } } |