From 4910b3f9485a928091d98e5da83b16cebae33eed Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Sat, 12 Mar 2005 03:45:01 +0000 Subject: Bug 285692: lastdiffed should use NULL instead of the "beginning of time" Patch By Max Kanat-Alexander r=glob, a=myk --- sanitycheck.cgi | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sanitycheck.cgi') diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 30a07be5b..2a51a3169 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -178,7 +178,8 @@ if (defined $cgi->param('rescanallBugMail')) { require Bugzilla::BugMail; Status("OK, now attempting to send unsent mail"); - SendSQL("SELECT bug_id FROM bugs WHERE lastdiffed < delta_ts AND + SendSQL("SELECT bug_id FROM bugs + WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts) AND delta_ts < now() - " . $dbh->sql_interval('30 minute') . " ORDER BY bug_id"); my @list; @@ -737,7 +738,7 @@ Status("Checking for unsent mail"); @badbugs = (); SendSQL("SELECT bug_id " . - "FROM bugs WHERE lastdiffed < delta_ts AND ". + "FROM bugs WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts) AND " . "delta_ts < now() - " . $dbh->sql_interval('30 minute') . " ORDER BY bug_id"); -- cgit v1.2.3-24-g4f1b