summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorXimin Luo <infinity0@debian.org>2016-06-07 15:02:09 +0200
committerHolger Levsen <holger@layer-acht.org>2016-06-07 15:15:45 +0200
commitcc67484d4e61b2787fdf6d25849df69b84cb24e2 (patch)
tree28f6f1adef6160e7e84231266bc1f313f8625c44
parent35df7893c19e451de920ac3274aad812b00064ff (diff)
downloadjenkins.debian.net-cc67484d4e61b2787fdf6d25849df69b84cb24e2.tar.xz
Fix get_bugs - don't join on the same table twice, also remove redundant join against "sources"
Signed-off-by: Holger Levsen <holger@layer-acht.org>
-rwxr-xr-xbin/reproducible_common.py4
1 files changed, 1 insertions, 3 deletions
diff --git a/bin/reproducible_common.py b/bin/reproducible_common.py
index 2eb7389b..368aed5e 100755
--- a/bin/reproducible_common.py
+++ b/bin/reproducible_common.py
@@ -568,9 +568,7 @@ def get_bugs():
"""
query = """
SELECT bugs.id, bugs.source, bugs.done, ARRAY_AGG(tags.tag)
- FROM bugs JOIN bugs_tags ON bugs.id = bugs_tags.id
- JOIN bugs_usertags ON bugs_tags.id = bugs_usertags.id
- JOIN sources ON bugs.source=sources.source
+ FROM bugs JOIN bugs_usertags ON bugs.id = bugs_usertags.id
LEFT JOIN (
SELECT id, tag FROM bugs_tags
WHERE tag='patch' OR tag='pending'