summaryrefslogtreecommitdiffstats
path: root/contrib/sendunsentbugmail.pl
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-03-12 04:45:01 +0100
committermkanat%kerio.com <>2005-03-12 04:45:01 +0100
commit4910b3f9485a928091d98e5da83b16cebae33eed (patch)
tree86285755c4d1fdcd4b7fef7a4d2e0caacf11bc20 /contrib/sendunsentbugmail.pl
parentaf17bfb29507e2fd93aca4e6f602c527b0e05bd2 (diff)
downloadbugzilla-4910b3f9485a928091d98e5da83b16cebae33eed.tar.gz
bugzilla-4910b3f9485a928091d98e5da83b16cebae33eed.tar.xz
Bug 285692: lastdiffed should use NULL instead of the "beginning of time"
Patch By Max Kanat-Alexander <mkanat@kerio.com> r=glob, a=myk
Diffstat (limited to 'contrib/sendunsentbugmail.pl')
-rw-r--r--contrib/sendunsentbugmail.pl6
1 files changed, 4 insertions, 2 deletions
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()) {