List:Internals« Previous MessageNext Message »
From:Sergei Golubchik Date:May 20 2009 8:22pm
Subject:Re: character fields in records_in_range
View as plain text  
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
Thread
character fields in records_in_rangeTimothy P Clark15 May
  • Re: character fields in records_in_rangeSergei Golubchik18 May
    • Re: character fields in records_in_rangeTimothy P Clark18 May
      • Re: character fields in records_in_rangeSergei Golubchik19 May
        • Re: character fields in records_in_rangeTimothy P Clark20 May
          • Re: character fields in records_in_rangeSergei Golubchik20 May
            • Re: character fields in records_in_rangeTimothy P Clark21 May
  • re: character fields in records_in_rangeMichael Widenius19 May
    • re: character fields in records_in_rangeTimothy P Clark20 May
      • Re: re: character fields in records_in_rangeSergei Golubchik20 May
        • Re: re: character fields in records_in_rangeTimothy P Clark20 May
          • Re: re: character fields in records_in_rangeSergei Golubchik21 May
            • Re: re: character fields in records_in_rangeTimothy P Clark21 May