From f48a6c40eac4c82b026c29a810fcc890c0f8b507 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Thu, 10 Dec 2015 00:01:19 +0000 Subject: reproducible: build/maintenance: another cases of ='' => IS NULL --- bin/reproducible_maintenance.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bin/reproducible_maintenance.sh') diff --git a/bin/reproducible_maintenance.sh b/bin/reproducible_maintenance.sh index 19da9311..755987d7 100755 --- a/bin/reproducible_maintenance.sh +++ b/bin/reproducible_maintenance.sh @@ -192,7 +192,7 @@ if [ "$HOSTNAME" = "$MAINNODE" ] ; then SELECT s.id, s.name, p.date_scheduled, p.date_build_started FROM schedule AS p JOIN sources AS s ON p.package_id=s.id WHERE p.date_scheduled != '' - AND p.date_build_started != '' + AND p.date_build_started IS NOT NULL AND p.date_build_started < datetime('now', '-36 hours') ORDER BY p.date_scheduled " -- cgit v1.2.3-70-g09d2