From unknown Sun Jun 15 08:15:23 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#70599 <70599@debbugs.gnu.org> To: bug#70599 <70599@debbugs.gnu.org> Subject: Status: join vs. numeric order Reply-To: bug#70599 <70599@debbugs.gnu.org> Date: Sun, 15 Jun 2025 15:15:23 +0000 retitle 70599 join vs. numeric order reassign 70599 coreutils submitter 70599 Dan Jacobson severity 70599 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Sat Apr 27 01:02:12 2024 Received: (at submit) by debbugs.gnu.org; 27 Apr 2024 05:02:13 +0000 Received: from localhost ([127.0.0.1]:38753 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1s0aCJ-00026v-Fp for submit@debbugs.gnu.org; Sat, 27 Apr 2024 01:02:11 -0400 Received: from lists.gnu.org ([2001:470:142::17]:36294) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1s0aC6-00023W-O7 for submit@debbugs.gnu.org; Sat, 27 Apr 2024 01:01:56 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1s0aBi-0002Id-8h for bug-coreutils@gnu.org; Sat, 27 Apr 2024 01:01:26 -0400 Received: from beige.elm.relay.mailchannels.net ([23.83.212.16]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1s0aBg-0006Vh-Jt for bug-coreutils@gnu.org; Sat, 27 Apr 2024 01:01:25 -0400 X-Sender-Id: dreamhost|x-authsender|jidanni@jidanni.org Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id EE50B6C2BC9 for ; Sat, 27 Apr 2024 05:01:21 +0000 (UTC) Received: from pdx1-sub0-mail-a226.dreamhost.com (unknown [127.0.0.6]) (Authenticated sender: dreamhost) by relay.mailchannels.net (Postfix) with ESMTPA id 978A56C2BB6 for ; Sat, 27 Apr 2024 05:01:21 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1714194081; a=rsa-sha256; cv=none; b=acTyG2CH/5lObXiiYv4kypS/xdy17F191zmW/kC1xHD4bPS9K4w5A2lad8j4XqQZRSSwtR PU3m8TwSpKjjm509DmWcA/CUHdIGOPx9L+BpIiddIeZYxGKAg2HjEdYYdkVA3Jb5CU40ox c/lXrZlq8XGJFZWa3XDz0vlmbNcysqfoClegzXWxFGw6gE4RGy9W/IRWq5LaZGxLYMv3p0 hIvQN8LYPUKgPdVbTPdB5mboa1z/OkenLI6xOguB5mQoGrqbRjBn/N1xiKPugyzYU+FXez defKt+Bh9nlOIccXEiTwTvmm4pokAog8K6w1OkxCwH79RGjeECEG0v/XdqDYDg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1714194081; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: dkim-signature; bh=G+skE2xR8opqCu4I64HitvkacBxYWO90n0patcf2H2w=; b=bfHDmrOmwDjQydVNw6QXBqYNVxlNq1HmT7QQovGo+2dYZ3TlMxct6iL3P+xPBNOcsPkayx RPJeM/Br96jfALJshyf69saXY5j9Y6f3798C0GhHlxLenEQ3o9f9VHUbfO97iONH6exM05 h+wVuXH46n95hlQtPQ14CojxIgKAkEZAeuF87KsQNxiZYYFFqPqlMpCNPP+a7O/jYn7fST W2vjWJ23/Vv74Qrs6s/3IbA6ovQBIQv1VaBbitNm/CPQ94ffELoB+8Wjt4+wWnZdsU+8ez z8s8uxmDQ+fjWG0vdhh5IsCCrm6PszcdPSo2ndolp6w+uzuCSbdgKGYei6cMDw== ARC-Authentication-Results: i=1; rspamd-67db6f49c6-5shd8; auth=pass smtp.auth=dreamhost smtp.mailfrom=jidanni@jidanni.org X-Sender-Id: dreamhost|x-authsender|jidanni@jidanni.org X-MC-Relay: Neutral X-MailChannels-SenderId: dreamhost|x-authsender|jidanni@jidanni.org X-MailChannels-Auth-Id: dreamhost X-Hysterical-Spicy: 1664b4b5204df3ca_1714194081852_3258771074 X-MC-Loop-Signature: 1714194081852:1510064443 X-MC-Ingress-Time: 1714194081852 Received: from pdx1-sub0-mail-a226.dreamhost.com (pop.dreamhost.com [64.90.62.162]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.119.153.252 (trex/6.9.2); Sat, 27 Apr 2024 05:01:21 +0000 Received: from jidanni.org (1-165-173-195.dynamic-ip.hinet.net [1.165.173.195]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: jidanni@jidanni.org) by pdx1-sub0-mail-a226.dreamhost.com (Postfix) with ESMTPSA id 4VRHVn3ZszzDh for ; Fri, 26 Apr 2024 22:01:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jidanni.org; s=dreamhost; t=1714194081; bh=G+skE2xR8opqCu4I64HitvkacBxYWO90n0patcf2H2w=; h=From:To:Subject:Date:Content-Type; b=HIpVPT/CWWrC7d1B7AoKxeJoz6GJJzRDrmRSMqDilr8R3k6tzr52URFhbZhZNBu+o aK0gyoyVw5OB2ga2oY/x1FoBYWGjodYhfLZxkz10njIkI3kkqtgcnr97cb6Mjq/Tm7 YXpuK8ZPmlE+wG7iz0L5OSVK0jHygLVDr712RduSTtLi9k+Muw7LcM+ON8MUqduJGc wyipVxr518IJ5uZExl1shwSs5K126At0ezew2PUETjn5Uzwn1F/oipaODFrixIsvqR csSALKbTaZ55BB0rYdZkiBpPIWy3imj9uVvzMUMJGef9G868Cb9XRdOMCJRic/vQen KWSAeiuVKld+Q== From: Dan Jacobson To: bug-coreutils@gnu.org Subject: join vs. numeric order Date: Sat, 27 Apr 2024 06:55:08 +0800 Message-ID: <871q6r68fn.n.fsf@jidanni.org> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=23.83.212.16; envelope-from=jidanni@jidanni.org; helo=beige.elm.relay.mailchannels.net X-Spam_score_int: -5 X-Spam_score: -0.6 X-Spam_bar: / X-Spam_report: (-0.6 / 5.0 requ) BAYES_00=-1.9, DATE_IN_PAST_06_12=1.543, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-Spam-Score: 2.0 (++) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: (info "(coreutils) Sorting files for join") needs to talk about numeric order. $ seq 111|join --check-order - /dev/null join: -:10: is not sorted: 10 So the info manual needs to mention 'Even though your files might be in perfect "sort --numeric-sort" order, you need to make them into plain "sort" order first. Sorry. At least you'll get the same nu [...] Content analysis details: (2.0 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 1.1 DATE_IN_PAST_06_12 Date: is 6 to 12 hours before Received: date 0.9 SPF_FAIL SPF: sender does not match SPF record (fail) [SPF failed: Please see http://www.openspf.org/Why?s=mfrom; id=jidanni%40jidanni.org; ip=2001%3A470%3A142%3A%3A17; r=debbugs.gnu.org] -0.0 SPF_HELO_PASS SPF: HELO matches SPF record X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 1.0 (+) (info "(coreutils) Sorting files for join") needs to talk about numeric order. $ seq 111|join --check-order - /dev/null join: -:10: is not sorted: 10 So the info manual needs to mention 'Even though your files might be in perfect "sort --numeric-sort" order, you need to make them into plain "sort" order first. Sorry. At least you'll get the same number of joins.' Or, add a new join -n option. The join man page could now say: '-n: use numeric comparisons. Note sort order also needs to be "sort -n" order.' And / or mention how the user might tinker with LC_NUMERIC and / or LC_COLLATE to somehow achieve numeric sorting...