GNU logs - #67690, boring messages

Message sent to bug-coreutils@HIDDEN:

Subject: bug#67690: Bug in command sort?
Resent-From: Oleg Moiseichuk <MetamAdeptus@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-coreutils@HIDDEN
Resent-Date: Thu, 07 Dec 2023 14:51:01 +0000
Resent-Message-ID: <handler.67690.B.170196061230708 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
To: 67690 <at> debbugs.gnu.org
From: Oleg Moiseichuk <MetamAdeptus@HIDDEN>
Message-ID: <f13aecda-67c6-4d05-5d4e-95ee2ac62c93@HIDDEN>
Date: Thu, 7 Dec 2023 17:36:39 +0300
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:45.0) Gecko/20100101
 Thunderbird/45.8.0
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="------------7DB0FF98F85685B371F87B48"
UI-OutboundReport: notjunk:1;M01:P0:R2/1OVFo9x8=;V6OivOF3d+R568Wf+GHMXQA+mWI
 NHJuuRS1Es5ZsvNDpj5n5dqo6uHE+wG8e82GBkCEAxsb4u12quM0UA+IfV6oAJEF7BVIYzBWv
 Kd0T3Wh05WQbE7Hs1nG5pDhXw07xKWI0XL5VOdCxs9dOT8sI8Lrv7KLW5/gN1FnIhGmKVoG6G
 ryeL3ednfIFlU/a78kaVzP/WoWfx12wxnEdsUCMt3nPkvAcO9GdhAiVbCoFNZxv0/RjNBDHVo
 o2xoV+pn7FpnkrPTFJkWaIVT7ypZvCmWqH21loEmJkJPn6Jq8XC0UibRTx0sa4FjL6FIS9UFd
 ZVQdiHC8s9o3UHcAGW6qQuj1FIpoShrQDjKziTci76no4Hgd5sqJUXZ146cKldOHKibZFvdGj
 vkRi460pPurRYEvP14TiH6MzyinZwVEov/hIGUfgEPG6lx2fJ471866KDSoOYQ/VLEAmhc0VF
 eLtU3doAouvKs1zVaUI0HJK8Ow5WOtCE2kXz33hUkeO7ebV0I7orkhMkQRrzAn6K6gRe5CwjK
 NMivI+GzGrk8wM3u7nqDdaNGKEfJKkQNj+vPhBLHkb1MbrEJgDh+wCz1o4/wU9aBis/lRyfqf
 ARFmPHIfmo0Z7oF9MD0o1/pvL0ZEr99GMwRZsCwPb+5A1kiNFrf91gOiEnkRKzw4FCeRkMmXw
 B4SraX1XUTCuA6KGsEL/KsP38eLIo3sUXoQC7iRVPat/4nRamc/X2bwpQQ+qd5+jCDgnrxa5H
 12sdsq5HmFXu68eZNF5xOZtJgX8q4DpvnuSvoLvzjO6Iiy9UEzb+ZMyo/MHyuLbAC2wg1S5BE
 LeFCshkq/TbfVzgUbOfHe+4Xi6YD/kmnMq+eEtld5EWbvxY04C3J1GkgEEPNaWqgaLgmDtPuA
 88cj6r1Vzog24hPgXYNVAepRpB23XjNIzSFT6r0oj9YQKDIzrRZ40Nf5S/U/IbA6oY1d7jBx2
 nBGo2A==
Received-SPF: pass client-ip=212.227.17.20; envelope-from=MetamAdeptus@HIDDEN;
 helo=mout.gmx.net
X-Spam_score_int: -27
X-Spam_score: -2.8
X-Spam_bar: --
X-Spam_report: (-2.8 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1,
 DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001,
 RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H4=0.001, RCVD_IN_MSPIKE_WL=0.001,
 SPF_HELO_NONE=0.001, SPF_PASS=-0.001,
 T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no
X-Spam_action: no action
X-Spam-Score: 1.0 (+)
X-Mailman-Approved-At: Thu, 07 Dec 2023 09:50:10 -0500
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -0.0 (/)

This is a multi-part message in MIME format.
--------------7DB0FF98F85685B371F87B48
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hello!

I've got a list of IP addresses, each of them is prepended by its frequenc=
y counter (please find attached in the file list-1.txt). I need to sort th=
em from most frequent to least. I tried using this command:
sort -t '.' -n -k 1.1,1.8r -k 1.9 -k 2,2 -k 3,3 -k 4,4 list-1.txt
But I've got some weird results.

Ok, I merged these counters with IP addresses using awk (file list-2.txt).=
 Now they use the same separator and I can simplify the command:
sort -t '.' -n -k 1,1r -k 2,2 -k 3,3 -k 4,4 -k 5,5 list-2.txt > sorted-a.t=
xt
It looks like as sorted properly but some entries with the counters 13 and=
 10 are misplaced.
Strangely enough, when I use direct order, they are sorted correctly:
sort -t '.' -n -k 1,1 -k 2,2 -k 3,3 -k 4,4 -k 5,5 list-2.txt > sorted-b.tx=
t

Is it a bug or I'm doing something wrong?
I checked this in Ubuntu 22.04, sort version is 8.32.

=2D-
Best regards,
Oleg Moiseichuk

--------------7DB0FF98F85685B371F87B48
Content-Type: text/plain; charset=UTF-8;
 name="list-1.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="list-1.txt"

ICAgICAgMiA4MC45NC4xNjAuMjA3CiAgICAgIDEgODAuOTQuMTY2LjE3NQogICAgICA1IDgw
Ljk0LjE2Ny44NwogICAgIDEwIDgwLjk0LjE3MS4xMjIKICAgICAgMyA4MC45NC4xNzQuNzYK
ICAgICAgNyA4MC45NC4xNzQuODIKICAgICAgMSA4MC45NC4xNzQuODYKICAgICAgMSA4MC45
NC4xNzQuOTAKICAgICAxMyA4MC45NC4xNzQuOTcKICAgICAgMiA5NS4xMzAuODcuNwo=
--------------7DB0FF98F85685B371F87B48
Content-Type: text/plain; charset=UTF-8;
 name="list-2.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="list-2.txt"

Mi44MC45NC4xNjAuMjA3CjEuODAuOTQuMTY2LjE3NQo1LjgwLjk0LjE2Ny44NwoxMC44MC45
NC4xNzEuMTIyCjMuODAuOTQuMTc0Ljc2CjcuODAuOTQuMTc0LjgyCjEuODAuOTQuMTc0Ljg2
CjEuODAuOTQuMTc0LjkwCjEzLjgwLjk0LjE3NC45NwoyLjk1LjEzMC44Ny43Cg==
--------------7DB0FF98F85685B371F87B48
Content-Type: text/plain; charset=UTF-8;
 name="sorted-a.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="sorted-a.txt"

Ny44MC45NC4xNzQuODIKNS44MC45NC4xNjcuODcKMy44MC45NC4xNzQuNzYKMi44MC45NC4x
NjAuMjA3CjIuOTUuMTMwLjg3LjcKMTMuODAuOTQuMTc0Ljk3CjEwLjgwLjk0LjE3MS4xMjIK
MS44MC45NC4xNjYuMTc1CjEuODAuOTQuMTc0Ljg2CjEuODAuOTQuMTc0LjkwCg==
--------------7DB0FF98F85685B371F87B48
Content-Type: text/plain; charset=UTF-8;
 name="sorted-b.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="sorted-b.txt"

MS44MC45NC4xNjYuMTc1CjEuODAuOTQuMTc0Ljg2CjEuODAuOTQuMTc0LjkwCjIuODAuOTQu
MTYwLjIwNwoyLjk1LjEzMC44Ny43CjMuODAuOTQuMTc0Ljc2CjUuODAuOTQuMTY3Ljg3Cjcu
ODAuOTQuMTc0LjgyCjEwLjgwLjk0LjE3MS4xMjIKMTMuODAuOTQuMTc0Ljk3Cg==
--------------7DB0FF98F85685B371F87B48--

Message sent:

Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Mailer: MIME-tools 5.505 (Entity 5.505)
Content-Type: text/plain; charset=utf-8
X-Loop: help-debbugs@HIDDEN
From: help-debbugs@HIDDEN (GNU bug Tracking System)
To: Oleg Moiseichuk <MetamAdeptus@HIDDEN>
Subject: bug#67690: Acknowledgement (Bug in command sort?)
Message-ID: <handler.67690.B.170196061230708.ack <at> debbugs.gnu.org>
References: <f13aecda-67c6-4d05-5d4e-95ee2ac62c93@HIDDEN>
X-Gnu-PR-Message: ack 67690
X-Gnu-PR-Package: coreutils
Reply-To: 67690 <at> debbugs.gnu.org
Date: Thu, 07 Dec 2023 14:51:02 +0000

Thank you for filing a new bug report with debbugs.gnu.org.

This is an automatically generated reply to let you know your message
has been received.

Your message is being forwarded to the package maintainers and other
interested parties for their attention; they will reply in due course.

Your message has been sent to the package maintainer(s):
 bug-coreutils@HIDDEN

If you wish to submit further information on this problem, please
send it to 67690 <at> debbugs.gnu.org.

Please do not send mail to help-debbugs@HIDDEN unless you wish
to report a problem with the Bug-tracking system.

--=20
67690: https://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D67690
GNU Bug Tracking System
Contact help-debbugs@HIDDEN with problems

Message sent to bug-coreutils@HIDDEN:

Subject: bug#67690: Bug in command sort?
Resent-From: =?UTF-8?Q?P=C3=A1draig?= Brady <P@HIDDEN>
Original-Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
Resent-CC: bug-coreutils@HIDDEN
Resent-Date: Thu, 07 Dec 2023 15:38:02 +0000
Resent-Message-ID: <handler.67690.B67690.17019634324403 <at> debbugs.gnu.org>
Resent-Sender: help-debbugs@HIDDEN
To: Oleg Moiseichuk <MetamAdeptus@HIDDEN>, 67690 <at> debbugs.gnu.org
Message-ID: <a6f456fa-9013-170f-3ae0-53779d934c4b@HIDDEN>
Date: Thu, 7 Dec 2023 15:36:46 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
References: <f13aecda-67c6-4d05-5d4e-95ee2ac62c93@HIDDEN>
From: =?UTF-8?Q?P=C3=A1draig?= Brady <P@HIDDEN>
In-Reply-To: <f13aecda-67c6-4d05-5d4e-95ee2ac62c93@HIDDEN>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: list
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>

tag 67690 notabug
close 67690
stop

On 07/12/2023 14:36, Oleg Moiseichuk via GNU coreutils Bug Reports wrote:
> Hello!
> 
> I've got a list of IP addresses, each of them is prepended by its frequency counter (please find attached in the file list-1.txt). I need to sort them from most frequent to least. I tried using this command:
> sort -t '.' -n -k 1.1,1.8r -k 1.9 -k 2,2 -k 3,3 -k 4,4 list-1.txt
> But I've got some weird results.

Right, once you have multiple delimiters you generally need to adjust the data

> Ok, I merged these counters with IP addresses using awk (file list-2.txt). Now they use the same separator and I can simplify the command:
> sort -t '.' -n -k 1,1r -k 2,2 -k 3,3 -k 4,4 -k 5,5 list-2.txt > sorted-a.txt
> It looks like as sorted properly but some entries with the counters 13 and 10 are misplaced.
> Strangely enough, when I use direct order, they are sorted correctly:
> sort -t '.' -n -k 1,1 -k 2,2 -k 3,3 -k 4,4 -k 5,5 list-2.txt > sorted-b.txt

You're using the correct approach here, but missed this from the docs:

"A position in a sort field specified with ‘-k’ may have any of the
option letters ‘MbdfghinRrV’ appended to it, in which case no global
ordering options are inherited by that particular field."

I.e. the 'r' is cancelling out the global 'n'.

So you need to specify both options from that field like:

sort -t '.' -n -k 1,1rn -k 2,2 -k 3,3 -k 4,4 -k 5,5 list-2.txt

cheers,
Pádraig

p.s. the --debug option can be useful with sort to
help identify what's being compared, and various edge cases.

Last modified: Thu, 7 Dec 2023 15:45:01 UTC

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997 nCipher Corporation Ltd, 1994-97 Ian Jackson.