summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authorFrédéric Buclin <LpSolit@gmail.com>2012-12-07 14:04:38 +0100
committerFrédéric Buclin <LpSolit@gmail.com>2012-12-07 14:04:38 +0100
commitb80c2dd4385fec54b1541bd340a98a936d3a9a9e (patch)
tree13c5558b8eb69d442852098039df2e27838eeb59 /Bugzilla
parent3966e91e3d5b82148718b37719d887dbe1687f23 (diff)
downloadbugzilla-b80c2dd4385fec54b1541bd340a98a936d3a9a9e.tar.gz
bugzilla-b80c2dd4385fec54b1541bd340a98a936d3a9a9e.tar.xz
Bug 818007: Searching by commenter is slow
r=dkl a=LpSolit
Diffstat (limited to 'Bugzilla')
-rw-r--r--Bugzilla/Search.pm2
1 files changed, 1 insertions, 1 deletions
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};