From 04eec747666f354fc710afd9e7d48d4c1e17b5b2 Mon Sep 17 00:00:00 2001 From: "bugreport%peshkin.net" <> Date: Fri, 25 Feb 2005 11:40:03 +0000 Subject: Bug 264192: Fix search where BugsThisDependsOn or OtherBugsDependingOnThis is empty Patch by Joel Peshkin r=mkanat, a=myk --- Bugzilla/Search.pm | 12 ++++++++---- 1 file 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 { -- cgit v1.2.3-24-g4f1b