diff options
| author | Monty <monty@mariadb.org> | 2020-03-13 15:28:42 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2020-03-17 02:16:48 +0200 |
| commit | 1242eb3d32f2863f847aa96a10e2ab983a1a643b (patch) | |
| tree | b7e28488f2f6fa75a6a83e3b18c95ef8b53b4e8c /mysql-test/main/innodb_icp.result | |
| parent | 96b472c0ae798da43ca9f4735dfafe35b2f38fda (diff) | |
| download | mariadb-git-1242eb3d32f2863f847aa96a10e2ab983a1a643b.tar.gz | |
Removed double records_in_range calls from multi_range_read_info_const
This was to remove a performance regression between 10.3 and 10.4
In 10.5 we will have a better implementation of records_in_range
that will enable us to get more statistics.
This change was not done in 10.4 because the 10.5 will be part of
a larger change that is not suitable for the GA 10.4 version
Other things:
- Changed default handler block_size to 8192 to fix things statistics
for engines that doesn't set the block size.
- Fixed a bug in spider when using multiple part const ranges
(Patch from Kentoku)
Diffstat (limited to 'mysql-test/main/innodb_icp.result')
| -rw-r--r-- | mysql-test/main/innodb_icp.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/innodb_icp.result b/mysql-test/main/innodb_icp.result index d65acd5a48d..949bc9a00d8 100644 --- a/mysql-test/main/innodb_icp.result +++ b/mysql-test/main/innodb_icp.result @@ -658,7 +658,7 @@ SELECT * FROM t1 WHERE NOT(b = 'Texas') AND b BETWEEN 'wy' AND 'y' OR b = 'Pennsylvania' ORDER BY a; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 13 NULL 2 Using where; Rowid-ordered scan; Using filesort +1 SIMPLE t1 ALL b NULL NULL NULL # Using where; Using filesort SELECT * FROM t1 WHERE NOT(b = 'Texas') AND b BETWEEN 'wy' AND 'y' OR b = 'Pennsylvania' ORDER BY a; @@ -670,7 +670,7 @@ SELECT * FROM t1 WHERE NOT(b = 'Texas') AND b BETWEEN 'wy' AND 'y' OR b = 'Pennsylvania' ORDER BY a; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 13 NULL 2 Using index condition; Rowid-ordered scan; Using filesort +1 SIMPLE t1 ALL b NULL NULL NULL # Using where; Using filesort SELECT * FROM t1 WHERE NOT(b = 'Texas') AND b BETWEEN 'wy' AND 'y' OR b = 'Pennsylvania' ORDER BY a; |