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/Series.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/Series.pm')
| -rw-r--r-- | Bugzilla/Series.pm | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/Bugzilla/Series.pm b/Bugzilla/Series.pm index 3d4f301b9..e1d37423b 100644 --- a/Bugzilla/Series.pm +++ b/Bugzilla/Series.pm @@ -106,7 +106,9 @@ sub initFromDatabase { "WHERE series.series_id = $series_id AND " . "(public = 1 OR creator = " . Bugzilla->user->id . " OR " . "(ugm.group_id IS NOT NULL)) " . - "GROUP BY series_id"); + $dbh->sql_group_by('series.series_id', 'cc1.name, cc2.name, ' . + 'series.name, series.creator, series.frequency, ' . + 'series.query, series.public')); if (@series) { $self->initFromParameters(@series); |