incorrect output from JOIN
Barry Gould <[email protected]> Wed, 04 Dec 2002 13:14:54 -0800
| Newsgroups | gmane.comp.gnu.textutils.bugs |
|---|---|
| Message-ID | <[email protected]> |
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