diff options
| author |   mkanat%kerio.com <> | 2005-03-16 08:27:14 +0000 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-03-16 08:27:14 +0000 |
| commit | b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb (patch) | |
| tree | b2769bdde9c44eefd7834dcbc18e67e66d6d1aa9 /describekeywords.cgi | |
| parent | Bug 284811 : Remove %FORM from enter_bug.cgi classification code (diff) | |
| download | bugzilla-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-x | describekeywords.cgi | 7 |
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; |