From unknown Sat Jun 14 18:58:22 2025 X-Loop: help-debbugs@gnu.org Subject: bug#70599: join vs. numeric order Resent-From: Dan Jacobson Original-Sender: "Debbugs-submit" Resent-CC: bug-coreutils@gnu.org Resent-Date: Sat, 27 Apr 2024 05:03:11 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 70599 X-GNU-PR-Package: coreutils X-GNU-PR-Keywords: To: 70599@debbugs.gnu.org X-Debbugs-Original-To: bug-coreutils@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.17141941338214 (code B ref -1); Sat, 27 Apr 2024 05:03:11 +0000 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 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-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...