incorrect output from JOIN

[Barry Gould]

Hi,

I'm using GNU join on RedHat Linux 7.3 and on Windows XP.

Oddly, on Linux, it is not working correctly; it misses some lines when 
comparing files of IP's.

Linux:
# join --version
join (textutils) 2.0.21
Written by Mike Haertel.
# rpm -q --whatprovides  /usr/bin/join
textutils-2.0.21-1

Windows:
>join --version
join (GNU textutils) 2.0
Written by Mike Haertel.

Windows join d/l'd from http://unxutils.sourceforge.net/


With the data below, Linux join is missing the "192.168.11.254" lines from 
it's output. (executed "join file1 file2")

Both files are plain text, separated by spaces and newlines.

Files on Windows are in DOS format, on Linux are in UNIX format.

I also tried Solaris' join (SunOS 5.8), and it works correctly with the 
same input.

Note the data below is just one example. With larger data, the problem is 
exaggerated, so it's not just one line gets lost.

Thank you,
Barry Gould

data file1:
192.168.0.1 3
192.168.0.105 2
192.168.0.2 4
192.168.0.20 2
192.168.0.254 2
192.168.1.1 53
192.168.1.10 11
192.168.1.100 2
192.168.1.124 2
192.168.1.20 11
192.168.1.29 3
192.168.10.1 8
192.168.11.254 1714
192.168.123.163 4
192.168.168.155 1


data file2:
192.168.0.0 10
192.168.0.1 15
192.168.0.101 42
192.168.0.104 1
192.168.0.106 2
192.168.0.12 1
192.168.0.140 1
192.168.0.150 1
192.168.0.197 4
192.168.0.2 28
192.168.0.210 16
192.168.1.0 2
192.168.1.1 20
192.168.1.10 33
192.168.1.100 63
192.168.1.101 14
192.168.1.102 29
192.168.1.104 16
192.168.1.106 2
192.168.1.107 1
192.168.1.111 1
192.168.1.112 1
192.168.1.113 1
192.168.1.115 1
192.168.1.116 1
192.168.1.118 1
192.168.1.12 4
192.168.1.129 15
192.168.1.13 10
192.168.1.135 1
192.168.1.14 14
192.168.1.15 3
192.168.1.170 2
192.168.1.2 19
192.168.1.20 5
192.168.1.200 1
192.168.1.201 1
192.168.1.211 2
192.168.1.217 1
192.168.1.234 4
192.168.1.235 12
192.168.1.236 2
192.168.100.1 13
192.168.100.200 4
192.168.11.13 44
192.168.11.150 19
192.168.11.2 104
192.168.11.254 113
192.168.113.146 1
192.168.116.104 4
192.168.119.13 6
192.168.119.14 4
192.168.119.15 12
192.168.120.14 4
192.168.120.15 12
192.168.123.122 4
192.168.123.192 3
192.168.123.201 1
192.168.13.10 4
192.168.155.13 1
192.168.164.112 8
192.168.18.2 2
192.168.2.10 13
192.168.2.105 1
192.168.2.142 1
192.168.2.18 5
192.168.2.2 1
192.168.200.20 6
192.168.204.18 2
192.168.21.188 1
192.168.220.1 1
192.168.222.113 6
192.168.23.20 159
192.168.240.173 6
192.168.240.253 3
192.168.241.129 6
192.168.254.205 63
192.168.254.206 4
192.168.255.255 2

Output on Linux:
192.168.0.1 15 3
192.168.0.2 28 4
192.168.1.1 20 53
192.168.1.10 33 11
192.168.1.100 63 2
192.168.1.20 5 11

Solaris/Win32 output:
192.168.0.1 15 3
192.168.0.2 28 4
192.168.1.1 20 53
192.168.1.10 33 11
192.168.1.100 63 2
192.168.1.20 5 11
192.168.11.254 113 1714


Barry Gould
Site Administrator, Harte-Hanks Shoppers
714-577-4313 or 877-244-4421
http://www.pennysaverusa.com
http://www.theflyer.com