summaryrefslogtreecommitdiff
path: root/README
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2022-12-21 00:30:02 +0200
committerMonty <monty@mariadb.org>2022-12-21 00:30:02 +0200
commit8742b0fe1bf9ef217b48ebd56a174a11e7b09959 (patch)
tree34ab33d08aeefb42ab39d2c813f2131320f401f1 /README
parent184735d8e481eb75c1b8ad22ec023beb5f53f399 (diff)
downloadmariadb-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