From 26a31ce18b191a402d8284ea76b3d56fe73a6210 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Thu, 25 Aug 2005 02:24:06 +0000
Subject: [PATCH] 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

---
 Bugzilla/Search.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 6255ede5d7..f30fe733b0 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 {
-- 
2.47.3