diff options
author | Monty <monty@mariadb.org> | 2022-12-21 00:30:02 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2022-12-21 00:30:02 +0200 |
commit | 8742b0fe1bf9ef217b48ebd56a174a11e7b09959 (patch) | |
tree | 34ab33d08aeefb42ab39d2c813f2131320f401f1 /README | |
parent | 184735d8e481eb75c1b8ad22ec023beb5f53f399 (diff) | |
download | mariadb-git-8742b0fe1bf9ef217b48ebd56a174a11e7b09959.tar.gz |
Fixed wrong selectivity calculation in table_after_join_selectivity()
The old code counted selectivity double in case of queries like:
WHERE key_part1=1 and key_part2 < 100
if the optimizer would decide to use a REF access on key_part1.
The new code in best_access_path() that changes REF access to RANGE
if the RANGE key is longer makes this issue less likely to happen.
I was not able to create a test case for 11.0, however if one ports this
patch to a MariaDB version without the change of REF to RANGE, the
selectivity will be counted double.
Diffstat (limited to 'README')
0 files changed, 0 insertions, 0 deletions