diff options
| author | Frédéric Buclin <LpSolit@gmail.com> | 2012-12-07 14:04:38 +0100 |
|---|---|---|
| committer | Frédéric Buclin <LpSolit@gmail.com> | 2012-12-07 14:04:38 +0100 |
| commit | b80c2dd4385fec54b1541bd340a98a936d3a9a9e (patch) | |
| tree | 13c5558b8eb69d442852098039df2e27838eeb59 | |
| parent | 3966e91e3d5b82148718b37719d887dbe1687f23 (diff) | |
| download | bugzilla-b80c2dd4385fec54b1541bd340a98a936d3a9a9e.tar.gz bugzilla-b80c2dd4385fec54b1541bd340a98a936d3a9a9e.tar.xz | |
Bug 818007: Searching by commenter is slow
r=dkl a=LpSolit
| -rw-r--r-- | Bugzilla/Search.pm | 2 |
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}; |