[Qa-jenkins-scm] [jenkins.debian.net] 01/04: reproducible: fixup SQL for b6e72c199
Holger Levsen
holger at moszumanska.debian.org
Wed Jul 29 14:32:26 UTC 2015
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
More information about the Qa-jenkins-scm
mailing list