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/rowid_filter_innodb.test | |
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/rowid_filter_innodb.test')
-rw-r--r-- | mysql-test/main/rowid_filter_innodb.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/main/rowid_filter_innodb.test b/mysql-test/main/rowid_filter_innodb.test index 8705a0c9a12..339d4e37f67 100644 --- a/mysql-test/main/rowid_filter_innodb.test +++ b/mysql-test/main/rowid_filter_innodb.test @@ -70,6 +70,7 @@ let $q= select * from t1 join t2 on t1.id = t2.x where t2.y = 2 and t1.id = 1; eval $q; +--replace_column 10 # eval explain extended $q; drop table t1, t2; |