On 18 Mar 98 at 15:18, Thomas G. Lockhart wrote:
> > > What does it mean when MySQL says "Ignored" in the CREATE INDEX
> > > entry?
> >
> > mysql isn't supporting create index like the ansi sql way. You must
> > create an index in the create of the table with mysql. It's accepting
> > create index statements but it isn't doing anything with it so that's
> > why it's ignored.
>
> You are holding MySQL and Postgres to different standards when
> developing your comparison table. Frankly, it seems that we should meet
> somewhere in the middle on this if you are hoping for further
> collaboration on developing a test suite :(
>
Yep that's true but because it's open for everyone you can't expect
from us that we will write all those changes. Hopefully someone of
the postgres developers will say .... let's take a look at it and
let's add some things for postgres in crash-me. And maybe it's
interesting for the postgres people to add an sub select benchmark in
the benchmark. We aren't going to write it till mysql is supporting
it.
Greetz...
Luuk
|-----------------------------------------------------------------------|
| Luuk de Boer -> <luuk@pi.net> |
| When you want to go fast ..... |
| Drive a cobra on the road and take a T3 line for internet ...... :-) |
| http://www.luuk.com/ -> The AC Cobra site |
|-----------------------------------------------------------------------|