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/join_cache.test | |
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/join_cache.test')
-rw-r--r-- | mysql-test/main/join_cache.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/main/join_cache.test b/mysql-test/main/join_cache.test index edee05cb6a5..ce84ccb56fc 100644 --- a/mysql-test/main/join_cache.test +++ b/mysql-test/main/join_cache.test @@ -1117,6 +1117,7 @@ CREATE INDEX t3_quality ON t3(quality); INSERT INTO t3 VALUES (6, 4, 8, 0, "010101_anastacia_spmidi.mid", "2004-03-16 13:40:00", 1, NULL, NULL, 255), (3343, 3, 8, 1, "010102_4VN4bsPwnxRQUJW5Zp1RhG2IL9vvl_8.mid", "2004-03-16 13:40:00", 1, NULL, NULL, 255); +insert into t3 (mediaid, formatid) values (1000,1),(1001,2),(1002,3),(1003,1),(1004,2),(1005,3); CREATE TABLE t4( formatid int NOT NULL , |