Re: mysql is a pain in the ass

[Michael Widenius]

>>>>> "Mike" == Mike Schwartz <mykes@stripped> writes:

<cut>

Mike> I don't know the history of Oracle development.  I suspect this is a very cheap
Mike> optimization, and I also suspect it would not be so hard to add to MySQL.  I
Mike> don't claim to be an expert on RDBMS internals, but I can see from the
Mike> documentation that they do use indexes for LIKE 'foo%' clauses.  That code must
Mike> find the first 'foo%' and then walk forward through the index until it finds no
Mike> match.  Why would it take so much extra coding to go to the first key and walk
Mike> forward through the index until the end of the index?

Hi!

What has this to do with the query 'LIKE "%foo"' ?

Regards,
Monty