List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 9 1999 9:57pm
Subject:Re: Strange sorting on negative numbers of type decimal
View as plain text  
>>>>> "Blake" == Blake Binkley <blake@stripped> writes:

Blake> Michael, it looks like it is suffering from string-compare-itis :)
Blake> the same effect happens in perl sorts.

ISAM actually tries to deal with numbers as strings (as you can see,
10 is not after 1 ), but there is apparently something wrong with negative
numbers...

Blake> Michael Widenius wrote:

>> >>>>> "eric" == eric  <eric@stripped> writes:
>> 
>> >> Description:
eric> Sorting on a decimal field with negative numbers cause a strange sequence
eric> should be -14,-13,-12,-12,-10,-5,-4,-3,-2,-1,0,1,2,3,4,5,10,11,12,13,14
eric> but is    -10,-11,-12,-13,-14,-1,-2,-3,-4,-5,0,1,2,3,4,5,10,11,12,13,14

<cut>

Regards,
Monty
Thread
Strange sorting on negative numbers of type decimaleric9 Jun
  • Re: Strange sorting on negative numbers of type decimalJim Faucette9 Jun
    • Re: Strange sorting on negative numbers of type decimalEric Thelin9 Jun
  • Strange sorting on negative numbers of type decimalMichael Widenius9 Jun
  • Re: Strange sorting on negative numbers of type decimalBlake Binkley10 Jun
    • Re: Strange sorting on negative numbers of type decimalMichael Widenius10 Jun