Hi, Timothy!
On May 20, Timothy P Clark wrote:
> >
> > You should have problems with ORDER BY and GROUP BY, unless you
> > pretend that your indexes are not ordered. You'll be able to do no
> > ranges at all. Even equalities aren't guaranteed to work, I'm
> > afraid.
> >
> > Do ORDER BY and, say, BETWEEN ranges work ? If yes - LIKE should
> > work automatically. If they are not, I think that fixing LIKE is
> > wrong, it's just patching up the sympthoms.
> Yes, these do work, but that is because the actual I/O operations (i.e.
> index_read) run through a much different set of interfaces than
> records_in_range.
You should be able to trigger records_in_range() also without LIKE -
with BETWEEN or inequalities.
Regards / Mit vielen Grüßen,
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, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring
