diff options
| author | Byron Jones <glob@mozilla.com> | 2015-08-11 09:56:43 +0200 |
|---|---|---|
| committer | Byron Jones <glob@mozilla.com> | 2015-08-11 09:56:43 +0200 |
| commit | dd7cd13b7cecaa92caebd3c4930154b2de35ff29 (patch) | |
| tree | b3563f6bfdc94e2f56416f25945bbf93c641a621 | |
| parent | 986c0871fe82fbefbddac10411833ef4b96fa4a4 (diff) | |
| download | bugzilla-dd7cd13b7cecaa92caebd3c4930154b2de35ff29.tar.gz bugzilla-dd7cd13b7cecaa92caebd3c4930154b2de35ff29.tar.xz | |
Bug 1191888 - fix duplicate IDs
| -rwxr-xr-x | scripts/security_remove.pl | 8 |
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 = ?}, |