From unknown Tue Jun 17 20:19:17 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#9325 <9325@debbugs.gnu.org> To: bug#9325 <9325@debbugs.gnu.org> Subject: Status: document that "all bets are off if the file contains non-unique join fields" Reply-To: bug#9325 <9325@debbugs.gnu.org> Date: Wed, 18 Jun 2025 03:19:17 +0000 retitle 9325 document that "all bets are off if the file contains non-uniqu= e join fields" reassign 9325 coreutils submitter 9325 jidanni@jidanni.org severity 9325 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Thu Aug 18 17:28:52 2011 Received: (at submit) by debbugs.gnu.org; 18 Aug 2011 21:28:52 +0000 Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuA8y-0002S7-Fc for submit@debbugs.gnu.org; Thu, 18 Aug 2011 17:28:52 -0400 Received: from eggs.gnu.org ([140.186.70.92]) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuA8w-0002S0-7Q for submit@debbugs.gnu.org; Thu, 18 Aug 2011 17:28:51 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QuA6y-0002KS-Es for submit@debbugs.gnu.org; Thu, 18 Aug 2011 17:26:49 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00, RCVD_IN_DNSWL_NONE, T_DKIM_INVALID autolearn=unavailable version=3.3.1 Received: from lists.gnu.org ([140.186.70.17]:59640) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QuA6y-0002KO-DI for submit@debbugs.gnu.org; Thu, 18 Aug 2011 17:26:48 -0400 Received: from eggs.gnu.org ([140.186.70.92]:55343) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QuA6x-00072J-IQ for bug-coreutils@gnu.org; Thu, 18 Aug 2011 17:26:48 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QuA6w-0002K6-Nt for bug-coreutils@gnu.org; Thu, 18 Aug 2011 17:26:47 -0400 Received: from caiajhbdcbbj.dreamhost.com ([208.97.132.119]:46214 helo=homiemail-a2.g.dreamhost.com) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QuA6w-0002Jr-HA for bug-coreutils@gnu.org; Thu, 18 Aug 2011 17:26:46 -0400 Received: from homiemail-a2.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a2.g.dreamhost.com (Postfix) with ESMTP id A6D8B280070 for ; Thu, 18 Aug 2011 14:26:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=jidanni.org; h=from:to:subject :date:message-id:mime-version:content-type; q=dns; s=jidanni.org ; b=HHIVkW/STVxS/xQ3eXUNMCtSZvm88CppQU88Ixfh5OawyJW99kRbWNNfb1yD iumIouGyJXcHJ1urDGI3RxxVs7GgKKcsUpUHbxCB+BVxNGDQJ06JBdSVykoXl639 AztiHNhSHSW6p1MGxajOrDVpmanMpLkR9xX57jEHSz/lTuQ= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=jidanni.org; h=from:to :subject:date:message-id:mime-version:content-type; s= jidanni.org; bh=ktL4EeIycTGv1u+VFC7jf0+2w9o=; b=AmlMUMskeqMYxJf4 WLrLEk5EqDs2kTkR0p3piLBSUNHlKhXXMJjcpXEzMvfPCq1Gvjhw7VnpDc7uFQM9 C68i9vK8TDp/8adWeCLUGd1mtkvsqf+Wq+Lj1uldJGHYFpDecG30x1kL6PxTNcyX r2b9fQ4KfTYK9fOZXxCf7TT2h7U= Received: from jidanni.org (218-163-0-21.dynamic.hinet.net [218.163.0.21]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: jidanni@jidanni.org) by homiemail-a2.g.dreamhost.com (Postfix) with ESMTPSA id D819428006D for ; Thu, 18 Aug 2011 14:26:43 -0700 (PDT) From: jidanni@jidanni.org To: bug-coreutils@gnu.org Subject: document that "all bets are off if the file contains non-unique join fields" Date: Fri, 19 Aug 2011 04:29:32 +0800 Message-ID: <87d3g2zcnn.fsf@jidanni.org> MIME-Version: 1.0 Content-Type: text/plain X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-Received-From: 140.186.70.17 X-Spam-Score: -5.4 (-----) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.11 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -5.4 (-----) Mention in the join(1) documents that "all bets are off if the file contains non-unique join fields", e.g., a b b c Also mention if you get this email. From debbugs-submit-bounces@debbugs.gnu.org Fri Aug 19 05:25:54 2011 Received: (at 9325) by debbugs.gnu.org; 19 Aug 2011 09:25:54 +0000 Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuLKs-0002Ys-JE for submit@debbugs.gnu.org; Fri, 19 Aug 2011 05:25:54 -0400 Received: from mx1.redhat.com ([209.132.183.28]) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuLKp-0002Yk-MC for 9325@debbugs.gnu.org; Fri, 19 Aug 2011 05:25:53 -0400 Received: from int-mx01.intmail.prod.int.phx2.redhat.com (int-mx01.intmail.prod.int.phx2.redhat.com [10.5.11.11]) by mx1.redhat.com (8.14.4/8.14.4) with ESMTP id p7J9NlXt030899 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 19 Aug 2011 05:23:47 -0400 Received: from mx.meyering.net (ovpn01.gateway.prod.ext.phx2.redhat.com [10.5.9.1]) by int-mx01.intmail.prod.int.phx2.redhat.com (8.13.8/8.13.8) with ESMTP id p7J9Nk6E007136; Fri, 19 Aug 2011 05:23:46 -0400 Received: from rho.meyering.net (localhost.localdomain [127.0.0.1]) by rho.meyering.net (Acme Bit-Twister) with ESMTP id D5FE2600A2; Fri, 19 Aug 2011 11:23:45 +0200 (CEST) From: Jim Meyering To: jidanni@jidanni.org Subject: Re: bug#9325: document that "all bets are off if the file contains non-unique join fields" In-Reply-To: <87d3g2zcnn.fsf@jidanni.org> (jidanni@jidanni.org's message of "Fri, 19 Aug 2011 04:29:32 +0800") References: <87d3g2zcnn.fsf@jidanni.org> Date: Fri, 19 Aug 2011 11:23:45 +0200 Message-ID: <87hb5ddaam.fsf@rho.meyering.net> Lines: 12 MIME-Version: 1.0 Content-Type: text/plain X-Scanned-By: MIMEDefang 2.67 on 10.5.11.11 X-Spam-Score: -10.6 (----------) X-Debbugs-Envelope-To: 9325 Cc: 9325@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.11 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -10.6 (----------) jidanni@jidanni.org wrote: > Mention in the join(1) documents that "all bets are off if the file > contains non-unique join fields", e.g., > a > b > b > c > Also mention if you get this email. Thanks for the suggestion. Would you please suggest wording and where to put it? (gasp! a patch ;-) From debbugs-submit-bounces@debbugs.gnu.org Fri Aug 19 06:18:22 2011 Received: (at 9325-done) by debbugs.gnu.org; 19 Aug 2011 10:18:22 +0000 Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuM9d-0003kT-ON for submit@debbugs.gnu.org; Fri, 19 Aug 2011 06:18:22 -0400 Received: from mail2.vodafone.ie ([213.233.128.44]) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuM9b-0003kJ-6p for 9325-done@debbugs.gnu.org; Fri, 19 Aug 2011 06:18:20 -0400 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Ak0CAIE3Tk5tTjRH/2dsb2JhbAAMNZhrkUcBAQUyAUYQCw0LCRYPCQMCAQIBRRMBBQIBAcE8hkgEmD2LTA Received: from unknown (HELO [192.168.1.79]) ([109.78.52.71]) by mail2.vodafone.ie with ESMTP; 19 Aug 2011 11:16:13 +0100 Message-ID: <4E4E37ED.9050908@draigBrady.com> Date: Fri, 19 Aug 2011 11:16:13 +0100 From: =?ISO-8859-1?Q?P=E1draig_Brady?= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:5.0) Gecko/20110707 Thunderbird/5.0 MIME-Version: 1.0 To: jidanni@jidanni.org Subject: Re: bug#9325: document that "all bets are off if the file contains non-unique join fields" References: <87d3g2zcnn.fsf@jidanni.org> In-Reply-To: <87d3g2zcnn.fsf@jidanni.org> X-Enigmail-Version: 1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Spam-Score: -2.6 (--) X-Debbugs-Envelope-To: 9325-done Cc: 9325-done@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.11 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -2.6 (--) On 08/18/2011 09:29 PM, jidanni@jidanni.org wrote: > Mention in the join(1) documents that "all bets are off if the file > contains non-unique join fields", e.g., > a > b > b > c > Also mention if you get this email. non unique fields are supported $ join <(printf "%s\n" 'a 1' 'b 2' 'b 3' 'c 4') <(printf "%s\n" a b c) a 1 b 2 b 3 c 4 cheers, Pádraig. From debbugs-submit-bounces@debbugs.gnu.org Fri Aug 19 07:48:41 2011 Received: (at 9325) by debbugs.gnu.org; 19 Aug 2011 11:48:41 +0000 Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuNZ2-0006cH-Cv for submit@debbugs.gnu.org; Fri, 19 Aug 2011 07:48:40 -0400 Received: from caiajhbdcbbj.dreamhost.com ([208.97.132.119] helo=homiemail-a61.g.dreamhost.com) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1QuNYz-0006c8-9y for 9325@debbugs.gnu.org; Fri, 19 Aug 2011 07:48:38 -0400 Received: from homiemail-a61.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a61.g.dreamhost.com (Postfix) with ESMTP id E22E857806C for <9325@debbugs.gnu.org>; Fri, 19 Aug 2011 04:46:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=jidanni.org; h=from:to:subject :references:date:message-id:mime-version:content-type; q=dns; s= jidanni.org; b=lKDa6h2al1u1iXINCRbvOSz2WS3/l98q0d8FVW3p6N+r9DNsG w2Miaw1Y+ddEKc7fECaeScQ2blGXZOG3IpGIgpk1BabNBn84by4xeIbRWovGfmt5 4clWj1r3BaYOVXKt3AkUkug9Jbw6yk+kLgacf6P31uhpmxQB8ZoXSRk/jU= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=jidanni.org; h=from:to :subject:references:date:message-id:mime-version:content-type; s=jidanni.org; bh=+S+ZX8WdntYVq0N42s8ECYVsyhs=; b=TBC8BBdpr7RWf RpxNG+VzEva3lLNIThSFMifVPeVi73lU3WmGdDWOYO+PMtfZC4I5A8RJFN7z2fI0 H0GRO54tbEmbeaXv2b1HuwO/x9a3R3vnUdRXT5DnWFWJaO0dP08mv++tvVKifFVw 46OYDWMuAirvQlvJ4qXjof79CkwEIw= Received: from jidanni.org (218-163-4-197.dynamic.hinet.net [218.163.4.197]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: jidanni@jidanni.org) by homiemail-a61.g.dreamhost.com (Postfix) with ESMTPSA id 8CAF0578059 for <9325@debbugs.gnu.org>; Fri, 19 Aug 2011 04:46:31 -0700 (PDT) From: jidanni@jidanni.org To: 9325@debbugs.gnu.org Subject: Re: bug#9325: closed (Re: bug#9325: document that "all bets are off if the file contains non-unique join fields") References: Date: Fri, 19 Aug 2011 19:46:29 +0800 Message-ID: <8762ltd3oq.fsf@jidanni.org> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Score: -3.4 (---) X-Debbugs-Envelope-To: 9325 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.11 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -3.4 (---) OK, glad to know they are supported. Indeed, $ join <(printf "%s\n" 'a 1' 'b 2' 'b 3' 'c 4') <(printf "%s\n" a b 'b 5' c c) a 1 b 2 b 2 5 b 3 b 3 5 c 4 c 4 So be sure to mention it wherever you mention files must be in sorted order. I mean probably if you don't mention it, nobody will be sure what the behavior will be. From unknown Tue Jun 17 20:19:17 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Sat, 17 Sep 2011 11:24:03 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator