summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjocuri%softhome.net <>2004-06-22 17:00:58 +0200
committerjocuri%softhome.net <>2004-06-22 17:00:58 +0200
commitec22b11474b927e80c0917692d57fbf95cfedb81 (patch)
treebb08569d6fdd29e580282ec4d50f30dae78f9a08
parent8381f5770745d5a23b9f3e8ecee1c42323ef9765 (diff)
downloadbugzilla-ec22b11474b927e80c0917692d57fbf95cfedb81.tar.gz
bugzilla-ec22b11474b927e80c0917692d57fbf95cfedb81.tar.xz
Patch for bug 247772: Improve SQL capitalization in collectstats; r=joel; a=justdave.
-rwxr-xr-xcollectstats.pl8
1 files changed, 4 insertions, 4 deletions
diff --git a/collectstats.pl b/collectstats.pl
index ec6b4cf70..3bf95ce37 100755
--- a/collectstats.pl
+++ b/collectstats.pl
@@ -139,9 +139,9 @@ sub collect_stats {
foreach my $status ('NEW', 'ASSIGNED', 'REOPENED', 'UNCONFIRMED', 'RESOLVED', 'VERIFIED', 'CLOSED') {
if( $product eq "-All-" ) {
- SendSQL("select count(bug_status) from bugs where bug_status='$status'");
+ SendSQL("SELECT COUNT(bug_status) FROM bugs WHERE bug_status='$status'");
} else {
- SendSQL("select count(bug_status) from bugs where bug_status='$status' and product_id=$product_id");
+ SendSQL("SELECT COUNT(bug_status) FROM bugs WHERE bug_status='$status' AND product_id=$product_id");
}
push @row, FetchOneColumn();
@@ -149,9 +149,9 @@ sub collect_stats {
foreach my $resolution ('FIXED', 'INVALID', 'WONTFIX', 'LATER', 'REMIND', 'DUPLICATE', 'WORKSFORME', 'MOVED') {
if( $product eq "-All-" ) {
- SendSQL("select count(resolution) from bugs where resolution='$resolution'");
+ SendSQL("SELECT COUNT(resolution) FROM bugs WHERE resolution='$resolution'");
} else {
- SendSQL("select count(resolution) from bugs where resolution='$resolution' and product_id=$product_id");
+ SendSQL("SELECT COUNT(resolution) FROM bugs WHERE resolution='$resolution' AND product_id=$product_id");
}
push @row, FetchOneColumn();