From: Zardosht Kasheff
Date: June 28 2009 3:00pm
Subject: Re: feedback/review requested for fix to MySQL bug #45458
List-Archive: http://lists.mysql.com/internals/37025
Message-Id: <2f9663ba0906280800n2bd47c21hd0c23fc0bf09cb88@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

What is this patch? Can you please give an example of how this patch would =
work?

Is this similar to the comment field in create index in 6.0?

Thanks
-Zardosht

On Sun, Jun 28, 2009 at 10:31 AM, Michael Widenius<monty@stripped> wrot=
e:
>
> hi!
>
>>>>>> "Zardosht" =3D=3D Zardosht Kasheff <zardosht@stripped> writes:
>
> Zardosht> Hello,
> Zardosht> This is a feature request that adds grammar for "clustering" in=
dexes.
> Zardosht> Users can define an index to be clustering (include all of the =
columns
> Zardosht> in the index), and as a result, a flag is passed into the handl=
er via
> Zardosht> a flag. It is up to the storage engine to properly implement it=
.
> Zardosht> Storage engines that choose to not implement it can simply igno=
re the
> Zardosht> flag.
>
> Zardosht> I am interested to hear feedback on this feature and patch. Her=
e is the link:
>
> Zardosht> http://bugs.mysql.com/bug.php?id=3D45458
>
> In MariaDB we have a patch that allows one to use a list of keywords
> for indexes and for the whole table. =A0These keywords will be passed to
> the engine so that it can take care of these that it knows about.
>
> MariaDB is maintaining these extra keywords and will ensure that they
> are kept around even if you do an ALTER TABLE back and from another
> engine that doesn't support the same keywords.
>
> This is a much better approach than having to add new code to support
> any possible keyword/option that an engine may want to support.
>
> Regards,
> Monty
>
> For information of MariaDB, the community developed server based on
> source code from MySQL, check out www.askmonty.org
>
> PS: I just checked and the patch is not yet pushed. I will talk with
> =A0 =A0Sanja tomorrow and ask what the status is and when he can push
> =A0 =A0this one.
>