diff options
author | Igor Babaev <igor@askmonty.org> | 2019-02-14 00:15:48 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2019-02-14 00:17:20 -0800 |
commit | e1de23b8d51c53b87a9d54352af0e99d4386e0ee (patch) | |
tree | dc8e1780b373a37f7a362c539cde520f34453662 /mysql-test/main/select.result | |
parent | 76c34a74a8a93a0acca8521d20d8299f7a36ee0f (diff) | |
download | mariadb-git-e1de23b8d51c53b87a9d54352af0e99d4386e0ee.tar.gz |
MDEV-16188 Introduced the notion of adjusted filter gain.
Due to inconsistent usage of different cost models to calculate
the cost of ref accesses we have to make the calculation of the
gain promising by usage a range filter more complex.
Diffstat (limited to 'mysql-test/main/select.result')
-rw-r--r-- | mysql-test/main/select.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/select.result b/mysql-test/main/select.result index 7a71c3458b0..f1a976b4b8e 100644 --- a/mysql-test/main/select.result +++ b/mysql-test/main/select.result @@ -3475,13 +3475,13 @@ INSERT INTO t2 VALUES EXPLAIN SELECT a, c, d, f FROM t1,t2 WHERE a=c AND b BETWEEN 4 AND 6; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY,b b 5 NULL 3 Using index condition -1 SIMPLE t2 ref c c 5 test.t1.a 2 +1 SIMPLE t2 ALL c NULL NULL NULL 18 Using where +1 SIMPLE t1 eq_ref|filter PRIMARY,b PRIMARY|b 4|5 test.t2.c 1 (30%) Using where; Using rowid filter EXPLAIN SELECT a, c, d, f FROM t1,t2 WHERE a=c AND b BETWEEN 4 AND 6 AND a > 0; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY,b b 5 NULL 3 Using index condition; Using where -1 SIMPLE t2 ref c c 5 test.t1.a 2 +1 SIMPLE t2 ALL c NULL NULL NULL 18 Using where +1 SIMPLE t1 eq_ref|filter PRIMARY,b PRIMARY|b 4|5 test.t2.c 1 (30%) Using where; Using rowid filter DROP TABLE t1, t2; create table t1 ( a int unsigned not null auto_increment primary key, |