From 4c2187f5d58c42536873957516b4fc8b2dc25330 Mon Sep 17 00:00:00 2001 From: "myk%mozilla.org" <> Date: Sat, 27 Apr 2002 01:17:04 +0000 Subject: Fix for bug 139759: gets email searches for "cc: list or assignee" working again. Patch by David Ward 2xr=myk --- buglist.cgi | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'buglist.cgi') diff --git a/buglist.cgi b/buglist.cgi index 31f15b02e..a29184200 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -503,11 +503,9 @@ sub GenerateSQL { }, "^cc," => sub { - push(@supptables, "cc cc_$chartid"); - push(@wherepart, "bugs.bug_id = cc_$chartid.bug_id"); + push(@supptables, "LEFT JOIN cc cc_$chartid ON bugs.bug_id = cc_$chartid.bug_id"); - push(@supptables, "profiles map_cc_$chartid"); - push(@wherepart, "cc_$chartid.who = map_cc_$chartid.userid"); + push(@supptables, "LEFT JOIN profiles map_cc_$chartid ON cc_$chartid.who = map_cc_$chartid.userid"); $f = "map_cc_$chartid.login_name"; }, -- cgit v1.2.3-24-g4f1b