From a47eba439a545a7f4542be3410fd1752d9c19c30 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Mon, 16 Jan 2006 18:29:18 +0000 Subject: =?UTF-8?q?Bug=20323575:=20[PostgreSQL]=20sanitycheck.cgi=3Fcreate?= =?UTF-8?q?missinggroupcontrolmapentries=3D1=20produces=20a=20SQL=20error?= =?UTF-8?q?=20-=20Patch=20by=20Fr=C3=A9d=C3=A9ric=20Buclin=20=20r/a=3Djustdave?= 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(-) 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.1