From f2ba7c1f5e3889700279e52d9b348033305dffed Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Wed, 29 Jul 2015 13:51:30 +0200 Subject: 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 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 -- cgit v1.2.3-70-g09d2