summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-08-25 04:24:06 +0200
committermkanat%kerio.com <>2005-08-25 04:24:06 +0200
commit26a31ce18b191a402d8284ea76b3d56fe73a6210 (patch)
tree756473b92fee4a74cf5bd01620fceff8c2adb644
parent0f7677a45eede96ad06a7df728cc253dd26d670c (diff)
downloadbugzilla-26a31ce18b191a402d8284ea76b3d56fe73a6210.tar.gz
bugzilla-26a31ce18b191a402d8284ea76b3d56fe73a6210.tar.xz
Bug 298400: [PostgreSQL] SQL error using buglist.cgi and full text search. Column "relevance desc" not valid in GROUP BY
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=wurblzap, r=joel, a=justdave
-rw-r--r--Bugzilla/Search.pm3
1 files changed, 2 insertions, 1 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 6255ede5d..f30fe733b 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -1386,7 +1386,8 @@ sub init {
foreach my $field (@fields, @orderby) {
next if ($field =~ /(AVG|SUM|COUNT|MAX|MIN|VARIANCE)\s*\(/i ||
- $field =~ /^\d+$/ || $field eq "bugs.bug_id");
+ $field =~ /^\d+$/ || $field eq "bugs.bug_id" ||
+ $field =~ /^relevance/);
if ($field =~ /.*AS\s+(\w+)$/i) {
push(@groupby, $1) if !grep($_ eq $1, @groupby);
} else {