[Qa-jenkins-scm] [jenkins.debian.net] 01/01: Fix get_bugs - don't join on the same table twice, also remove redundant join against "sources"

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit cc67484d4e61b2787fdf6d25849df69b84cb24e2
Author: Ximin Luo <infinity0 at debian.org>
Date:   Tue Jun 7 15:02:09 2016 +0200

    Fix get_bugs - don't join on the same table twice, also remove redundant join against "sources"
    
    Signed-off-by: Holger Levsen <holger at layer-acht.org>
---
 bin/reproducible_common.py | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/bin/reproducible_common.py b/bin/reproducible_common.py
index 2eb7389..368aed5 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'

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git