From dd7cd13b7cecaa92caebd3c4930154b2de35ff29 Mon Sep 17 00:00:00 2001 From: Byron Jones Date: Tue, 11 Aug 2015 15:56:43 +0800 Subject: Bug 1191888 - fix duplicate IDs --- scripts/security_remove.pl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'scripts') diff --git a/scripts/security_remove.pl b/scripts/security_remove.pl index 90099e387..85f415218 100755 --- a/scripts/security_remove.pl +++ b/scripts/security_remove.pl @@ -59,7 +59,7 @@ my $timestamp = $dbh->selectrow_array('SELECT LOCALTIMESTAMP(0)'); # Gather bug ids my $reporter_bugs = $dbh->selectcol_arrayref( - q{SELECT bugs.bug_id + q{SELECT DISTINCT bugs.bug_id FROM bugs, bug_group_map WHERE bugs.bug_id = bug_group_map.bug_id AND bugs.reporter_accessible = 1 @@ -67,21 +67,21 @@ my $reporter_bugs = $dbh->selectcol_arrayref( undef, $target_user->id) || []; my $assignee_bugs = $dbh->selectcol_arrayref( - q{SELECT bugs.bug_id + q{SELECT DISTINCT bugs.bug_id FROM bugs, bug_group_map WHERE bugs.bug_id = bug_group_map.bug_id AND bugs.assigned_to = ?}, undef, $target_user->id) || []; my $qa_bugs = $dbh->selectcol_arrayref( - q{SELECT bugs.bug_id + q{SELECT DISTINCT bugs.bug_id FROM bugs, bug_group_map WHERE bugs.bug_id = bug_group_map.bug_id AND bugs.qa_contact = ?}, undef, $target_user->id) || []; my $cc_bugs = $dbh->selectcol_arrayref( - q{SELECT cc.bug_id + q{SELECT DISTINCT cc.bug_id FROM cc, bug_group_map WHERE cc.bug_id = bug_group_map.bug_id AND cc.who = ?}, -- cgit v1.2.3-24-g4f1b