[Qa-jenkins-scm] [jenkins.debian.net] 01/04: reproducible: fixup SQL for b6e72c199

[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 f2ba7c1f5e3889700279e52d9b348033305dffed
Author: Holger Levsen <holger at layer-acht.org>
Date:   Wed Jul 29 13:51:30 2015 +0200

    reproducible: fixup SQL for b6e72c199
---
 bin/reproducible_scheduler.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/bin/reproducible_scheduler.py b/bin/reproducible_scheduler.py
index 3ac03d2..5393272 100755
--- a/bin/reproducible_scheduler.py
+++ b/bin/reproducible_scheduler.py
@@ -215,10 +215,10 @@ def query_old_ftbfs_versions(suite, limit):
                'no new version available, sorted by last build date'
     query = """SELECT DISTINCT s.id, s.name
                 FROM sources AS s JOIN results AS r ON s.id = r.package_id
-		JOIN notes AS n ON n.package_id=s.id
+		OUTER JOIN notes AS n ON n.package_id=s.id
                 WHERE s.suite='{suite}'
                 AND r.status = 'FTBFS'
-		AND n.bugs = '[]'
+		AND ( n.bugs = '[]' OR n.bugs IS NULL )
                 AND r.build_date < datetime('now', '-10 day')
                 AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
                 ORDER BY r.build_date

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