From e370d1f52f927045250295c9b0b327145112f0c7 Mon Sep 17 00:00:00 2001
From: "mkanat%bugzilla.org" <>
Date: Sat, 28 Jun 2008 22:51:38 +0000
Subject: Bug 442175: [Oracle] cron script collectstats.pl doesn't work (ORA
 error) Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat

---
 collectstats.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'collectstats.pl')

diff --git a/collectstats.pl b/collectstats.pl
index 4c66810a0..160b566c3 100755
--- a/collectstats.pl
+++ b/collectstats.pl
@@ -539,7 +539,7 @@ sub CollectSeriesData {
     my $serieses = $dbh->selectall_hashref("SELECT series_id, query, creator " .
                       "FROM series " .
                       "WHERE frequency != 0 AND " . 
-                      "($days_since_epoch + series_id) % frequency = 0",
+                      "MOD(($days_since_epoch + series_id), frequency) = 0",
                       "series_id");
 
     # We prepare the insertion into the data table, for efficiency.
-- 
cgit v1.2.3-24-g4f1b