Hi, Georgi!
On Nov 11, Georgi Kodinov wrote:
> #At file:///home/kgeorge/mysql/bzr/B37742-5.1-bugteam/
>
> 2703 Georgi Kodinov 2008-11-11
> Bug #37742: HA_EXTRA_KEYREAD flag is set when key contains only prefix of
> requested
> column
>
> When the storage engine uses secondary keys clustered with the primary key
> MySQL was
> adding the primary key parts to each secondary key.
> In doing so it was not checking whether the index was on full columns and this
> resulted in the secondary keys being added to the list of covering keys even if
>
> they have partial columns.
> Fixed by cleaning up the list of covering keys if the primary key has a
> partial
> column as a key part.
Could you explain please where was a bug, in the code ? What functions
and lines were making wrong assumptions and switching keyread mode for
partial keys ?
Regards / Mit vielen Grüßen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect
/_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028
<___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring
