Subject: Re: bug#16468: join

From: Eric Blake <[email-masked]>
Date: Thu, 16 Jan 2014 10:15:04 -0700

On 01/16/2014 08:29 AM, barry kesner wrote:
> join is failing on large numbers somehow
> 

> 
> Join fails to join properly only giving 99980081
> if I prefix the 9's with a 0 join does not fail

Sounds to me like you didn't heed this advice in the --help text:

Important: FILE1 and FILE2 must be sorted on the join fields.
E.g., use "sort -k 1b,1" if 'join' has no options,
or use "join -t ''" if 'sort' has no options.
Note, comparisons honor the rules specified by 'LC_COLLATE'.
If the input is not sorted and some lines cannot be joined, a
warning message will be given.

Does running 'LC_ALL=C join' change the behavior for you, in which case
it was an issue of your choice of LC_COLLATE?

-- 
Eric Blake   eblake redhat com    +1-919-301-3266
Libvirt virtualization library http://libvirt.org