Hi to everyone,
and thanks for all your comments.
It looks like I have 2 possibilities:
#1: I modify the source-code of MySQL. It seems like sql_yacc.cc is a
godd place because here HA_KEY_ALG_HASH and others are used.
#2: I do not modify the source-code but use a given word instead.
This means: instead of
in my CREATE-stmt I use
so MySQL checks against a list of given keywords, accepts this statement
and sends it to the storage-engine. Then the storage-engine has to
handle this correctly. In my case it sends it to the create()-function:
create(const char *name, TABLE *form, HA_CREATE_INFO *info)
where I can find it in:
which contains an entry of the enum of type ha_key_alg (defined in
my_base.h). In my given example it contains HA_KEY_ALG_HASH.
OK, it is a bit dirty to use the HASH-keyword but I can live with this
This behaviour of MySQL explains this hint from the description of the
>>If you specify an index type that is not valid for a given storage
engine, but there is another index type available that the engine can
use without affecting query results, the engine uses the available
To me this looks like: when I use MyISAM as the type of a table and in
my CREATE INDEX-stmt I specify HASH as the index-type then the storage
engine will create an index of type BTREE without any notice.
Thanks for your help
PS: I've checked it: I created an index of type HASH on a MyISAM-table.
SHOW INDEX shows this BTREE.
Am Mittwoch, den 24.04.2013, 07:37 -0700 schrieb Sergei Golubchik:
> Hi, AugustQ!
> On Apr 24, AugustQ wrote:
> > Hi,
> > and thanks for your hints.
> > Here is what I did: I created a tiny storage engine which inherits its
> > functionality from MyIsam. I can load this code and so I created a table
> > with this type of storage engine.
> > Next I wanted to see what my storage engine can do if I add an index to
> > this table.
> > If I create an index without specifying an index-type everything works.
> > In the ::create(()-function I see the columns that describe the index.
> > When I create an index using an index-engine-type by giving the keyword
> > engine or type or using in the CREATE-stmt, it works when I use one of
> > the keywords given in the description like BTREE or HASH. But when I
> > create an index using my own keyword then I got immediately the syntax
> > error.
> > In my example I used the word AQTREE for the description of the
> > index-engine. I wanted to see at the storage-engine-level, what
> > information was given to my code but this storage engine (my code) was
> > never called.
> > What I expected: MySQL offers the choice of adding another storage
> > engine without modifying the source code of MySQL itself. So I assumed
> > that this would include the creating and handling of an index.
> > Is this possible?
> No, it is not possible. Index types are hard-coded in the parser and
> only BTREE, RTEEE, and HASH are allowed.