>>>>> "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