diff options
| author | bugreport%peshkin.net <> | 2005-02-25 12:40:03 +0100 |
|---|---|---|
| committer | bugreport%peshkin.net <> | 2005-02-25 12:40:03 +0100 |
| commit | 04eec747666f354fc710afd9e7d48d4c1e17b5b2 (patch) | |
| tree | e31a0a069b54d365d3785b79d768dd8947f01f63 | |
| parent | 6bec18a2672025895230ee976ea6e9e59b978846 (diff) | |
| download | bugzilla-04eec747666f354fc710afd9e7d48d4c1e17b5b2.tar.gz bugzilla-04eec747666f354fc710afd9e7d48d4c1e17b5b2.tar.xz | |
Bug 264192: Fix search where BugsThisDependsOn or OtherBugsDependingOnThis is empty
Patch by Joel Peshkin <bugreport@peshkin.net> r=mkanat, a=myk
| -rw-r--r-- | Bugzilla/Search.pm | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index aedb2b2b4..ff9befa28 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -881,20 +881,24 @@ sub init { "^dependson,(?!changed)" => sub { my $table = "dependson_" . $chartid; - push(@supptables, "dependencies $table"); $ff = "$table.$f"; my $ref = $funcsbykey{",$t"}; &$ref; - push(@wherepart, "$table.blocked = bugs.bug_id"); + push(@supptables, "LEFT JOIN dependencies $table " . + "ON $table.blocked = bugs.bug_id " . + "AND ($term)"); + $term = "$ff IS NOT NULL"; }, "^blocked,(?!changed)" => sub { my $table = "blocked_" . $chartid; - push(@supptables, "dependencies $table"); $ff = "$table.$f"; my $ref = $funcsbykey{",$t"}; &$ref; - push(@wherepart, "$table.dependson = bugs.bug_id"); + push(@supptables, "LEFT JOIN dependencies $table " . + "ON $table.dependson = bugs.bug_id " . + "AND ($term)"); + $term = "$ff IS NOT NULL"; }, "^alias,(?!changed)" => sub { |