summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2008-10-28 04:51:27 +0100
committerlpsolit%gmail.com <>2008-10-28 04:51:27 +0100
commit7caa3a5c4707b0941fe722891ba0989ca1f379d0 (patch)
tree00408cdca718379bcf099c8fe2e2db06de5fb399
parentf0df682198786713f701e4fdf25195b897297670 (diff)
downloadbugzilla-7caa3a5c4707b0941fe722891ba0989ca1f379d0.tar.gz
bugzilla-7caa3a5c4707b0941fe722891ba0989ca1f379d0.tar.xz
Bug 461756: [Oracle] collectstats.pl --regenerate uses PL/SQL reserved word in query - Patch by Dave Taylor <d.v.taylor@leedsmet.ac.uk> r=LpSolit r=mkanat a=mkanat
-rwxr-xr-xcollectstats.pl6
1 files changed, 3 insertions, 3 deletions
diff --git a/collectstats.pl b/collectstats.pl
index 160b566c3..08f1c1131 100755
--- a/collectstats.pl
+++ b/collectstats.pl
@@ -376,13 +376,13 @@ sub regenerate_stats {
# database was created, and the end date from the current day.
# If there were no bugs in the search, return early.
my $query = q{SELECT } .
- $dbh->sql_to_days('creation_ts') . q{ AS start, } .
- $dbh->sql_to_days('current_date') . q{ AS end, } .
+ $dbh->sql_to_days('creation_ts') . q{ AS start_day, } .
+ $dbh->sql_to_days('current_date') . q{ AS end_day, } .
$dbh->sql_to_days("'1970-01-01'") .
qq{ FROM bugs $from_product
WHERE } . $dbh->sql_to_days('creation_ts') .
qq{ IS NOT NULL $and_product
- ORDER BY start } . $dbh->sql_limit(1);
+ ORDER BY start_day } . $dbh->sql_limit(1);
my ($start, $end, $base) = $dbh->selectrow_array($query, undef, @values);
if (!defined $start) {