diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2020-04-02 11:50:47 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2020-04-02 11:50:47 +0300 |
commit | a21900663626647a7b6f4904fa564f05df38ff5f (patch) | |
tree | f7eb060b1e191b1ba450681290e362c701d569f0 /mysql-test/main/opt_trace_security.result | |
parent | bdcecfa22cc2eb255610f5574ff0a91c8d247066 (diff) | |
download | mariadb-git-a21900663626647a7b6f4904fa564f05df38ff5f.tar.gz |
MDEV-22014: Rowid Filtering is not displayed well in the optimizer trace
- Print the rowid filters that are available for use with each table.
- Make print_best_access_for_table() print which filter it has picked.
- Make best_access_path() print the filter for considered ref accesses.
Diffstat (limited to 'mysql-test/main/opt_trace_security.result')
-rw-r--r-- | mysql-test/main/opt_trace_security.result | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/main/opt_trace_security.result b/mysql-test/main/opt_trace_security.result index 22c5f3ff6f6..6f377cd02b5 100644 --- a/mysql-test/main/opt_trace_security.result +++ b/mysql-test/main/opt_trace_security.result @@ -103,8 +103,7 @@ select * from db1.t1 { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, @@ -227,8 +226,7 @@ select * from db1.v1 { "type": "scan", "records": 3, "cost": 2.0051, - "uses_join_buffering": false, - "filter_used": false + "uses_join_buffering": false } }, "rows_for_plan": 3, |