diff options
| author | Emilio Pozuelo Monfort <pochu@debian.org> | 2020-03-18 12:26:45 +0100 |
|---|---|---|
| committer | Emilio Pozuelo Monfort <pochu@debian.org> | 2020-03-18 12:26:45 +0100 |
| commit | 5e29d4fbf61a7871c158e73d44bc4ad26fdf7eb6 (patch) | |
| tree | 794918607873624b698e448284f9176e53a24fe5 /lib | |
| parent | bc8c7e271d522d62d15c6c767445f8f8858f8aa4 (diff) | |
security_db: don't return duplicated advisories
This is used to build the advisory table in package views, and it makes
no sense to list some advisories (e.g. DSAs that fixed both stable and
oldstable) twice.
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/python/security_db.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/python/security_db.py b/lib/python/security_db.py index fd90ab8b21..2c5a3ba58a 100644 --- a/lib/python/security_db.py +++ b/lib/python/security_db.py @@ -1872,7 +1872,7 @@ class DB: def getDSAsForSourcePackage(self, cursor, package): bugs_like = self.genDBAdvisoryString("bugs.name", dtsa=False) for row in cursor.execute( - """SELECT bugs.name, bugs.description + """SELECT DISTINCT bugs.name, bugs.description FROM bugs, package_notes as p WHERE p.bug_name = bugs.name AND ( """ + bugs_like + """ ) |