List:Falcon Storage Engine« Previous MessageNext Message »
From:Ann W. Harrison Date:December 8 2008 8:15pm
Subject:Re: Please review fox for bug#34479
View as plain text  
Vladislav Vaintroub wrote:
> 
> I believe there is nothing with Falcon internals. Prior solution seems to be
> a kludge, some workaround, possibly insufficient understanding of what one
> could do with strings library. IMO Falcon relies on MySQL collation for
> comparison and fail to see why on earth should we removing nowhere
> documented minChar.

The design of Falcon index keys calls for a representation of the key
value that produces the correct ordering from a byte-by-byte comparison.
For numeric keys with fewer than 19 digits of precision we use a
transformed double precision representation.  For string keys, we get
a byte-wise comparable transformation from the server that preserves
the semantics of the collation.  For strings we truncate trailing
spaces.  For numeric keys we truncate trailing zeros.

In the case of compound keys, there is additional processing that
allows us to truncate non-significant trailing characters (or bytes
when numeric) on leading segments of the key.

At least that's the way it was designed to work.

Cheers,

Ann
Thread
Please review fox for bug#34479Lars-Erik Bjørk2 Dec
  • RE: Please review fox for bug#34479Vladislav Vaintroub2 Dec
    • RE: Please review fox for bug#34479Lars-Erik Bjørk2 Dec
      • RE: Please review fox for bug#34479Lars-Erik Bjørk2 Dec
        • Re: Please review fox for bug#34479Alexander Barkov3 Dec
          • Re: Please review fox for bug#34479Lars-Erik Bjørk3 Dec
            • Re: Please review fox for bug#34479Kevin Lewis3 Dec
              • Re: Please review fox for bug#34479Ann W. Harrison3 Dec
    • Re: Please review fox for bug#34479Ann W. Harrison2 Dec
      • RE: Please review fox for bug#34479Vladislav Vaintroub2 Dec
Re: Please review fox for bug#34479Kevin Lewis3 Dec
  • Re: Please review fox for bug#34479Alexander Barkov3 Dec
    • Re: Please review fox for bug#34479Ann W. Harrison3 Dec
      • Re: Please review fox for bug#34479Lars-Erik Bjørk4 Dec
        • RE: Please review fox for bug#34479Vladislav Vaintroub4 Dec
        • Re: Please review fox for bug#34479Lars-Erik Bjørk4 Dec
          • RE: Please review fox for bug#34479Vladislav Vaintroub4 Dec
          • Re: Please review fox for bug#34479Ann W. Harrison4 Dec
        • Re: Please review fox for bug#34479Ann W. Harrison4 Dec
          • Re: Please review fox for bug#34479Lars-Erik Bjørk5 Dec
            • Re: Please review fox for bug#34479Lars-Erik Bjørk5 Dec
        • Re: Please review fox for bug#34479Alexander Barkov8 Dec
          • RE: Please review fox for bug#34479Vladislav Vaintroub8 Dec
            • Re: Please review fox for bug#34479Alexander Barkov8 Dec
            • Re: Please review fox for bug#34479Ann W. Harrison8 Dec
Re: Please review fox for bug#34479Ann W. Harrison4 Dec