diff options
author | Monty <monty@mariadb.org> | 2021-10-08 01:40:59 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2022-01-21 14:30:14 +0200 |
commit | 45763ca93f04cb28d007b6fae45f7a601375a669 (patch) | |
tree | c1fab8957908f4682c8e21de283c853243789469 /mysql-test/main/range.result | |
parent | 699b8a45dee0d50ef6b076c2f3004bcf6d395b70 (diff) | |
download | mariadb-git-45763ca93f04cb28d007b6fae45f7a601375a669.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 d97cfb2b587..bb8599e1eb9 100644 --- a/mysql-test/main/range.result +++ b/mysql-test/main/range.result @@ -2739,7 +2739,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" }, |