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/range.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/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 a0e04fc29e2..bcb43d1e905 100644 --- a/mysql-test/main/range.result +++ b/mysql-test/main/range.result @@ -280,7 +280,7 @@ INSERT INTO t1 VALUES (33,5),(33,5),(33,5),(33,5),(34,5),(35,5); EXPLAIN SELECT * FROM t1 WHERE a IN(1,2) AND b=5; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a,b a 5 NULL 2 Using index condition; Using where +1 SIMPLE t1 ref|filter a,b b|a 5|5 const 15 (5%) Using where; Using rowid filter SELECT * FROM t1 WHERE a IN(1,2) AND b=5; a b DROP TABLE t1; |