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 /summarize_time.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 'summarize_time.cgi')
| -rwxr-xr-x | summarize_time.cgi | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/summarize_time.cgi b/summarize_time.cgi index 8992918cc..ab8a6bf50 100755 --- a/summarize_time.cgi +++ b/summarize_time.cgi @@ -236,8 +236,9 @@ sub query_work_by_buglist { WHERE longdescs.bug_id IN ($buglist) AND longdescs.who = profiles.userid AND bugs.bug_id = longdescs.bug_id - $date_bits - GROUP BY longdescs.bug_id, profiles.login_name + $date_bits } . + $dbh->sql_group_by('longdescs.bug_id, profiles.login_name', + 'bugs.short_desc, bugs.bug_status') . qq{ ORDER BY longdescs.bug_when}; my $sth = $dbh->prepare($q); $sth->execute(@{$date_values}); @@ -314,8 +315,9 @@ sub get_inactive_bugs { FROM longdescs, bugs WHERE longdescs.bug_id IN ($buglist) AND bugs.bug_id = longdescs.bug_id - $date_bits - GROUP BY longdescs.bug_id + $date_bits } . + $dbh->sql_group_by('longdescs.bug_id', + 'bugs.short_desc, bugs.bug_status') . qq{ ORDER BY longdescs.bug_when}; $sth = $dbh->prepare($q); $sth->execute(@{$date_values}); |