MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Sergei Golubchik Date:December 3 2008 5:12pm
Subject:Re: bzr commit into mysql-5.1 branch (kgeorge:2703) Bug#37742
View as plain text  
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
Thread
bzr commit into mysql-5.1 branch (kgeorge:2703) Bug#37742Georgi Kodinov29 Nov
  • Re: bzr commit into mysql-5.1 branch (kgeorge:2703) Bug#37742Sergei Golubchik3 Dec