diff options
| author | mkanat%kerio.com <> | 2005-03-12 04:45:01 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-03-12 04:45:01 +0100 |
| commit | 4910b3f9485a928091d98e5da83b16cebae33eed (patch) | |
| tree | 86285755c4d1fdcd4b7fef7a4d2e0caacf11bc20 /contrib | |
| parent | af17bfb29507e2fd93aca4e6f602c527b0e05bd2 (diff) | |
| download | bugzilla-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')
| -rw-r--r-- | contrib/sendunsentbugmail.pl | 6 |
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()) { |