diff options
| author | lpsolit%gmail.com <> | 2006-01-16 19:29:18 +0100 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2006-01-16 19:29:18 +0100 |
| commit | a47eba439a545a7f4542be3410fd1752d9c19c30 (patch) | |
| tree | d663c33ad48ebca6beee7d44b571cef5dc3763f0 | |
| parent | 6930e2afb8af2a784f2c9ff6af3a8be6ee9a8920 (diff) | |
| download | bugzilla-a47eba439a545a7f4542be3410fd1752d9c19c30.tar.gz bugzilla-a47eba439a545a7f4542be3410fd1752d9c19c30.tar.xz | |
Bug 323575: [PostgreSQL] sanitycheck.cgi?createmissinggroupcontrolmapentries=1 produces a SQL error - Patch by Frédéric Buclin <LpSolit@gmail.com> r/a=justdave
| -rwxr-xr-x | sanitycheck.cgi | 3 |
1 files changed, 2 insertions, 1 deletions
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, |