summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorByron Jones <glob@mozilla.com>2015-08-11 09:56:43 +0200
committerByron Jones <glob@mozilla.com>2015-08-11 09:56:43 +0200
commitdd7cd13b7cecaa92caebd3c4930154b2de35ff29 (patch)
treeb3563f6bfdc94e2f56416f25945bbf93c641a621
parent986c0871fe82fbefbddac10411833ef4b96fa4a4 (diff)
downloadbugzilla-dd7cd13b7cecaa92caebd3c4930154b2de35ff29.tar.gz
bugzilla-dd7cd13b7cecaa92caebd3c4930154b2de35ff29.tar.xz
Bug 1191888 - fix duplicate IDs
-rwxr-xr-xscripts/security_remove.pl8
1 files changed, 4 insertions, 4 deletions
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 = ?},