aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-03-16 08:27:14 +0000
committermkanat%kerio.com <>2005-03-16 08:27:14 +0000
commitb99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb (patch)
treeb2769bdde9c44eefd7834dcbc18e67e66d6d1aa9 /describekeywords.cgi
parentBug 284811 : Remove %FORM from enter_bug.cgi classification code (diff)
downloadbugzilla-b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb.tar.gz
bugzilla-b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb.tar.bz2
bugzilla-b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb.zip
Bug 174295: ANSI SQL requires all columns in SELECT to be in GROUP BY, unless they are in "aggregate" functions
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=joel, a=myk
Diffstat (limited to 'describekeywords.cgi')
-rwxr-xr-xdescribekeywords.cgi7
1 files changed, 5 insertions, 2 deletions
diff --git a/describekeywords.cgi b/describekeywords.cgi
index dd25c40d6..e7b3b759b 100755
--- a/describekeywords.cgi
+++ b/describekeywords.cgi
@@ -35,11 +35,14 @@ use vars qw($vars $template);
Bugzilla->login();
my $cgi = Bugzilla->cgi;
+my $dbh = Bugzilla->dbh;
SendSQL("SELECT keyworddefs.name, keyworddefs.description,
COUNT(keywords.bug_id)
- FROM keyworddefs LEFT JOIN keywords ON keyworddefs.id=keywords.keywordid
- GROUP BY keyworddefs.id
+ FROM keyworddefs LEFT JOIN keywords
+ ON keyworddefs.id = keywords.keywordid " .
+ $dbh->sql_group_by('keyworddefs.id',
+ 'keyworddefs.name, keyworddefs.description') . "
ORDER BY keyworddefs.name");
my @keywords;