diff options
| author |   lpsolit%gmail.com <> | 2008-10-28 03:51:27 +0000 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2008-10-28 03:51:27 +0000 |
| commit | 7caa3a5c4707b0941fe722891ba0989ca1f379d0 (patch) | |
| tree | 00408cdca718379bcf099c8fe2e2db06de5fb399 /collectstats.pl | |
| parent | Bug 460995: Need to use terms.abug in description for makeproductgroups - Pat... (diff) | |
| download | bugzilla-7caa3a5c4707b0941fe722891ba0989ca1f379d0.tar.gz bugzilla-7caa3a5c4707b0941fe722891ba0989ca1f379d0.tar.bz2 bugzilla-7caa3a5c4707b0941fe722891ba0989ca1f379d0.zip | |
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
Diffstat (limited to 'collectstats.pl')
| -rwxr-xr-x | collectstats.pl | 6 |
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) { |