From b0c641ac53b60527df6f300de27f28c5acde1659 Mon Sep 17 00:00:00 2001 From: Sylvain Beucler Date: Thu, 29 Apr 2021 16:19:23 +0200 Subject: Sort CVEs as versions --- bin/tracker_service.py | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'bin') diff --git a/bin/tracker_service.py b/bin/tracker_service.py index 2686bc4c24..3065715a04 100755 --- a/bin/tracker_service.py +++ b/bin/tracker_service.py @@ -831,7 +831,7 @@ to improve our documentation and procedures, so feedback is welcome.""")])]) FROM source_package_status AS st, source_packages AS sp WHERE st.vulnerable AND sp.rowid = st.package AND sp.release = ? AND sp.subrelease = '' - ORDER BY sp.name, st.bug_name""", (rel,)): + ORDER BY sp.name, st.bug_name COLLATE version""", (rel,)): if bf.urgencyFiltered(urgency, vulnerable): continue if bf.remoteFiltered(remote): @@ -992,7 +992,7 @@ checker to find out why they have not entered testing yet."""), WHERE st.vulnerable == 2 AND sp.rowid = st.package AND sp.release IN (""" + ",".join("?" * len(releases)) + """) AND sp.subrelease = '' AND st.bug_name == bugs.name - ORDER BY sp.name, st.bug_name""", releases): + ORDER BY sp.name, st.bug_name COLLATE version""", releases): if old_bug == '': old_bug = bug_name @@ -1037,7 +1037,7 @@ checker to find out why they have not entered testing yet."""), AND sp.release IN (""" + ",".join("?" * len(releases)) + """) AND st.urgency == 'unimportant' AND sp.subrelease = '' AND st.bug_name == bugs.name - ORDER BY sp.name, st.bug_name""", releases): + ORDER BY sp.name, st.bug_name COLLATE version""", releases): if old_bug == '': old_bug = bug_name @@ -1118,7 +1118,7 @@ package which is no longer in the archive."""), AND n.bug_origin = '' AND sp.name = n.package AND sp.version LIKE '%:%' - ORDER BY bug_name, package"""): + ORDER BY bug_name COLLATE version, package"""): if bug == old_bug: bug = '' else: -- cgit v1.2.3