summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorSylvain Beucler <beuc@beuc.net>2021-04-29 16:19:23 +0200
committerEmilio Pozuelo Monfort <pochu@debian.org>2021-04-30 14:31:02 +0200
commitb0c641ac53b60527df6f300de27f28c5acde1659 (patch)
tree0faacd69907209a2ac2c9f51fe2a3644afea75b8 /bin
parent9bd5c83c7a7e002cb1705eb64dcf56b5a52c0c83 (diff)
Sort CVEs as versions
Diffstat (limited to 'bin')
-rwxr-xr-xbin/tracker_service.py8
1 files changed, 4 insertions, 4 deletions
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:

© 2014-2024 Faster IT GmbH | imprint | privacy policy