diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2018-06-09 19:04:34 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2018-06-09 19:04:51 +0530 |
| commit | c17468d4abe59339af11ef4a17a59156741c6a21 (patch) | |
| tree | 26a12ae17b05644110e4df64f87d0ce556f733cf /sql/sql_explain.cc | |
| parent | 3627dd7f6a1cf5bd7151ff23290d64cb6dffea90 (diff) | |
| download | mariadb-git-c17468d4abe59339af11ef4a17a59156741c6a21.tar.gz | |
MDEV-16191: Analyze format=json gives incorrect value for r_limit inside a dependent
subquery when ORDER BY is present
Currently for setting r_limit we divide with the number of iterations we invoke the dependent subquery.
This is not needed for the case of limit. For varying limits we produce the output that the limit varies with
execution.
Also there is a type for filtered , we forgot to multiply by 100 as it is represented as a percent.
Diffstat (limited to 'sql/sql_explain.cc')
| -rw-r--r-- | sql/sql_explain.cc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sql_explain.cc b/sql/sql_explain.cc index ac6bee05001..82107f9b922 100644 --- a/sql/sql_explain.cc +++ b/sql/sql_explain.cc @@ -1642,7 +1642,7 @@ void Explain_table_access::print_explain_json(Explain_query *query, { /* Get r_filtered value from filesort */ if (fs_tracker->get_r_loops()) - writer->add_double(fs_tracker->get_r_filtered()); + writer->add_double(fs_tracker->get_r_filtered()*100); else writer->add_null(); } |