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 /mysql-test/r/analyze_stmt_orderby.result | |
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 'mysql-test/r/analyze_stmt_orderby.result')
-rw-r--r-- | mysql-test/r/analyze_stmt_orderby.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/analyze_stmt_orderby.result b/mysql-test/r/analyze_stmt_orderby.result index be1f01a2a52..238baff50e1 100644 --- a/mysql-test/r/analyze_stmt_orderby.result +++ b/mysql-test/r/analyze_stmt_orderby.result @@ -303,7 +303,7 @@ ANALYZE "r_rows": 10, "r_total_time_ms": "REPLACED", "filtered": 100, - "r_filtered": 1, + "r_filtered": 100, "attached_condition": "(t0.a is not null)" } } |