summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
Diffstat (limited to 'bin')
-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