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

1 files changed, 3 insertions, 2 deletions

diff --git a/editmilestones.cgi b/editmilestones.cgi
index e62dcc4cb..0edbd1897 100755
--- a/editmilestones.cgi
+++ b/editmilestones.cgi
@@ -310,8 +310,9 @@ if ($action eq 'del') {
     my $dbh = Bugzilla->dbh;
 
     my $sth = $dbh->prepare('SELECT count(bug_id), product_id, target_milestone
-                             FROM bugs
-                             GROUP BY product_id, target_milestone
+                             FROM bugs ' .
+                            $dbh->sql_group_by('product_id,
+                                                target_milestone') . '
                              HAVING product_id = ?
                                 AND target_milestone = ?');