Hi, Georgi!
On Nov 29, Georgi Kodinov wrote:
> #At file:///home/kgeorge/mysql/work/B37742-5.1-bugteam/ based on
> revid:kgeorge@stripped
>
> 2703 Georgi Kodinov 2008-11-29
> 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 not adding a primary key part to the list of columns that can be used
> for index read of the secondary keys when the primary key part is a partial key
> part.
Ok to push
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
