From 7e6beebd825e6fa2a7ea622c43db9886ba073a2d Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Tue, 4 Dec 2012 16:30:28 -0500 Subject: Bugzilla/Search.pm: Patch requested by LpSolit@gmail.com --- Bugzilla/Search.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla/Search.pm') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 8ba9cdc6b..3c574274d 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -2288,7 +2288,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