280499 - Replace "TO_DAYS()" with Bugzilla::DB function call

Status: RESOLVED FIXED

(Bugzilla :: Bugzilla-General, enhancement)

Description

[Tomas Kopal]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050110 Firefox/1.0 (Debian package 1.0+dfsg.1-2)
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050110 Firefox/1.0 (Debian package 1.0+dfsg.1-2)

"TO_DAYS" is MySQL specific and should be replaced with DB
agnostic call to function in the DB compatibility layer.

Reproducible: Always

Steps to Reproduce:

Comment 1

[Tomas Kopal]

Attachment: V1

Patch to convert TO_DAYS SQL to DB method call. Requires patch from 281360.

Comment 2

[Tomas Kopal]

To Max: sorry, but I don't have the permissions to reassign the bug to myself or
mark is assigned...

Comment 3

[Max Kanat-Alexander]

OK, I'll talk to justdave and see if we can get you editbugs.

Comment 4

[Max Kanat-Alexander]

Comment on attachment 174669 [details] [diff] [review]
V1

OK, this looks good by inspection and the test suite passes.

Comment 5

[Max Kanat-Alexander]

Checking in checksetup.pl;
/cvsroot/mozilla/webtools/bugzilla/checksetup.pl,v  <--  checksetup.pl
new revision: 1.349; previous revision: 1.348
done
Checking in collectstats.pl;
/cvsroot/mozilla/webtools/bugzilla/collectstats.pl,v  <--  collectstats.pl
new revision: 1.42; previous revision: 1.41
done
Checking in whineatnews.pl;
/cvsroot/mozilla/webtools/bugzilla/whineatnews.pl,v  <--  whineatnews.pl
new revision: 1.16; previous revision: 1.15
done
Checking in Bugzilla/Chart.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Chart.pm,v  <--  Chart.pm
new revision: 1.5; previous revision: 1.4
done
Checking in Bugzilla/Search.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Search.pm,v  <--  Search.pm
new revision: 1.80; previous revision: 1.79
done
Checking in Bugzilla/Token.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Token.pm,v  <--  Token.pm
new revision: 1.27; previous revision: 1.26
done
Checking in Bugzilla/Auth/Login/WWW/CGI.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Auth/Login/WWW/CGI.pm,v  <-- 
CGI.pmnew revision: 1.7; previous revision: 1.6
done