diff options
author | Florian Weimer <fw@deneb.enyo.de> | 2015-05-28 20:29:44 +0000 |
---|---|---|
committer | Florian Weimer <fw@deneb.enyo.de> | 2015-05-28 20:29:44 +0000 |
commit | 74401fd2619991e73e74dca6f30fef96a7144b68 (patch) | |
tree | 93c88dbaa6c65bdb0590c13caca76751252c0e7f /lib | |
parent | 7bab8d0626c08658ba02c98b23d366332006067a (diff) |
/data/json: Work around performance issue due to SQLite planner change
git-svn-id: svn+ssh://svn.debian.org/svn/secure-testing@34565 e39458fd-73e7-0310-bf30-c45bca0a0e42
Diffstat (limited to 'lib')
-rw-r--r-- | lib/python/security_db.py | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/lib/python/security_db.py b/lib/python/security_db.py index c203125f3e..e018fff055 100644 --- a/lib/python/security_db.py +++ b/lib/python/security_db.py @@ -518,11 +518,10 @@ class DB: cursor.execute( """CREATE TEMPORARY VIEW debian_cve AS - SELECT DISTINCT debian_bugs.bug, st.bug_name + SELECT debian_bugs.bug, st.bug_name FROM package_notes, debian_bugs, source_package_status AS st WHERE package_notes.bug_name = st.bug_name - AND debian_bugs.note = package_notes.id - ORDER BY debian_bugs.bug""") + AND debian_bugs.note = package_notes.id""") def _initFunctions(self): """Registers user-defined SQLite functions.""" |