diff options
author | mkanat%kerio.com <> | 2005-03-16 09:27:14 +0100 |
---|---|---|
committer | mkanat%kerio.com <> | 2005-03-16 09:27:14 +0100 |
commit | b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb (patch) | |
tree | b2769bdde9c44eefd7834dcbc18e67e66d6d1aa9 /Bugzilla/Chart.pm | |
parent | 94dcd5edee079a1bb67a0011711d25a4be0f14c6 (diff) | |
download | bugzilla-b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb.tar.gz bugzilla-b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb.tar.xz |
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 'Bugzilla/Chart.pm')
-rw-r--r-- | Bugzilla/Chart.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/Bugzilla/Chart.pm b/Bugzilla/Chart.pm index 6dabea5a3..beb5a9b9d 100644 --- a/Bugzilla/Chart.pm +++ b/Bugzilla/Chart.pm @@ -320,7 +320,8 @@ sub getVisibleSeries { " AND cgm.group_id NOT IN($grouplist) " . "WHERE creator = " . Bugzilla->user->id . " OR " . " cgm.category_id IS NULL " . - "GROUP BY series_id"); + $dbh->sql_group_by('series_id', 'cc1.name, cc2.name, ' . + 'series.name')); foreach my $series (@$serieses) { my ($cat, $subcat, $name, $series_id) = @$series; $cats{$cat}{$subcat}{$name} = $series_id; |