Hi!
On Jun 06, Sanja Byelkin wrote:
> It is about "MySQL plugin interface: syntax extensions for CREATE
> TABLE" and for them who writes thier own engines.
>
> If you have some ideas or you see something wrong please say ASAP.
>
> Syntax will looks like this:
> CREATE TABLE table(
> id INT ENGINE_OPTIONS(OPT1=123, OPT2='someval',OPT3=aflag),
> INDEX USING BTREE (id)
> ) ENGINE = MEMORY
> ENGINE_OPTIONS(loc1='/mnt/d1/bigdat/mine',loc2=/mnt/d2/bigdata/mine') ;
Uh, wasn't Monty saying that there should be no visible difference for
the end user between built-in and engine options ? Just for the change,
I agree with this completely. I expected the syntax to be
CREATE TABLE table(
id INT OPT1=123 OPT2='someval' OPT3=aflag OPT4,
INDEX USING BTREE (id)
) ENGINE=MEMORY loc1='/mnt/d1/bigdat/mine' loc2=/mnt/d2/bigdata/mine';
Regards / Mit vielen Grüssen,
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
