Bug 285692: lastdiffed should use NULL instead of the "beginning of time"

Patch By Max Kanat-Alexander <mkanat@kerio.com> r=glob, a=myk

1 files changed, 3 insertions, 2 deletions

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");