From a21900663626647a7b6f4904fa564f05df38ff5f Mon Sep 17 00:00:00 2001 From: Sergei Petrunia Date: Thu, 2 Apr 2020 11:50:47 +0300 Subject: 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. --- mysql-test/main/opt_trace_security.result | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'mysql-test/main/opt_trace_security.result') 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, -- cgit v1.2.1