summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-07-29 13:51:30 +0200
committerHolger Levsen <holger@layer-acht.org>2015-07-29 13:51:30 +0200
commitf2ba7c1f5e3889700279e52d9b348033305dffed (patch)
treec565ede3feb60a89c851169f2324f4e59c595fe8
parent2c0f7d2fed7d75213e6cf1f75a89b2e98a9739f5 (diff)
downloadjenkins.debian.net-f2ba7c1f5e3889700279e52d9b348033305dffed.tar.xz
reproducible: fixup SQL for b6e72c199
-rwxr-xr-xbin/reproducible_scheduler.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/reproducible_scheduler.py b/bin/reproducible_scheduler.py
index 3ac03d23..5393272b 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