From b80c2dd4385fec54b1541bd340a98a936d3a9a9e Mon Sep 17 00:00:00 2001
From: Frédéric Buclin <LpSolit@gmail.com>
Date: Fri, 7 Dec 2012 14:04:38 +0100
Subject: Bug 818007: Searching by commenter is slow r=dkl a=LpSolit

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

(limited to 'Bugzilla')

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 22e837d46..b9c37b4ed 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -2282,7 +2282,7 @@ sub _user_nonchanged {
             my $table = $first_join->{table};
             my $columns = "bug_id";
             $columns .= ",isprivate" if @{ $first_join->{extra} };
-            my $new_table = "SELECT $columns FROM $table AS $as $join_sql";
+            my $new_table = "SELECT DISTINCT $columns FROM $table AS $as $join_sql";
             $first_join->{table} = "($new_table)";
             # We always want to LEFT JOIN the generated table.
             delete $first_join->{join};
-- 
cgit v1.2.3-24-g4f1b