From a47eba439a545a7f4542be3410fd1752d9c19c30 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Mon, 16 Jan 2006 18:29:18 +0000
Subject: Bug 323575: [PostgreSQL]
 sanitycheck.cgi?createmissinggroupcontrolmapentries=1 produces a SQL error -
 Patch by Frédéric Buclin <LpSolit@gmail.com> r/a=justdave
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 sanitycheck.cgi | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'sanitycheck.cgi')

diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index eeb45902f..9a80efd24 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -162,7 +162,8 @@ if (defined $cgi->param('createmissinggroupcontrolmapentries')) {
                    ON bugs.product_id = gcm.product_id
                   AND    bgm.group_id = gcm.group_id
                 WHERE COALESCE(gcm.membercontrol, $na) = $na
-          } . $dbh->sql_group_by('bugs.product_id, bgm.group_id'));
+          } . $dbh->sql_group_by('bugs.product_id, bgm.group_id',
+                                 'gcm.membercontrol, groups.name, products.name'));
 
     foreach (@$invalid_combinations) {
         my ($product_id, $group_id, $currentmembercontrol,
-- 
cgit v1.2.3-24-g4f1b