diff options
author | Monty <monty@mariadb.org> | 2021-10-08 01:40:59 +0300 |
---|---|---|
committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-02 20:24:54 +0300 |
commit | bc9805e95432325b8d3d812e7cc4f6e1380d2345 (patch) | |
tree | 2a5d20ab69abb25fd03ab0f5607bddbe6c990e3d /mysql-test/main/range.result | |
parent | b67144893a3ddf96ace15d21ed1bd572e19a33e0 (diff) | |
download | mariadb-git-bc9805e95432325b8d3d812e7cc4f6e1380d2345.tar.gz |
Return >= 1 from matching_candidates_in_table if records > 0.0
Having rows >= 1.0 helps ensure that when we calculate total rows of joins
the number of resulting rows will not be less after the join.
Changes in test cases:
- Join order change for some tables with few records
- 'Filtered' is much higher for tables with few rows, as 1 row is a high
procent of a table with few rows.
Diffstat (limited to 'mysql-test/main/range.result')
-rw-r--r-- | mysql-test/main/range.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/range.result b/mysql-test/main/range.result index 6ff4f409666..36e6e2b2aec 100644 --- a/mysql-test/main/range.result +++ b/mysql-test/main/range.result @@ -2765,7 +2765,7 @@ EXPLAIN "selectivity_pct": 6.730769231 }, "rows": 7, - "filtered": 6.730769157, + "filtered": 14.28571415, "index_condition": "t2.d is not null", "attached_condition": "(t2.d,t2.e) in (<cache>((4,4)),<cache>((7,7)),<cache>((8,8))) and octet_length(t2.f) = 1" } |