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 <mkanat@kerio.com> r=glob, a=myk

---
 contrib/sendunsentbugmail.pl | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'contrib')

diff --git a/contrib/sendunsentbugmail.pl b/contrib/sendunsentbugmail.pl
index 35b6a4941..9184e0be2 100644
--- a/contrib/sendunsentbugmail.pl
+++ b/contrib/sendunsentbugmail.pl
@@ -30,8 +30,10 @@ use Bugzilla::Constants;
 use Bugzilla::BugMail;
 
 my $dbh = Bugzilla->dbh;
-SendSQL("SELECT bug_id FROM bugs WHERE lastdiffed < delta_ts AND 
-         delta_ts < NOW() - " . $dbh->sql_interval('30 minute') .
+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;
 while (MoreSQLData()) {
-- 
cgit v1.2.3-24-g4f1b