aboutsummaryrefslogtreecommitdiffstats
path: root/buglist.cgi
diff options
context:
space:
mode:
authorjake%acutex.net <>2001-06-19 09:05:08 +0000
committerjake%acutex.net <>2001-06-19 09:05:08 +0000
commitaa7b4750a7c84e2807cdaa66d304fa42615a6f6e (patch)
treef072a94d81c6d29c7aaad83f2011e11315f29c54 /buglist.cgi
parentaad3b8b5731596f6cc98c9c9bdda9e3bda463af3 (diff)
downloadbugs-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.tar
bugs-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.tar.gz
bugs-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.tar.bz2
bugs-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.tar.xz
bugs-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.zip
Running a query using the Added Comment option was very slow (bug 57350).
Patch by Myk Melez <myk@mozilla.org> and Dave Miller <justdave@syndicomm.com> r= jake@acutex.net
Diffstat (limited to 'buglist.cgi')
-rwxr-xr-xbuglist.cgi4
1 files changed, 2 insertions, 2 deletions
diff --git a/buglist.cgi b/buglist.cgi
index b99afefe9..206b968ca 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -241,7 +241,7 @@ sub GenerateSQL {
push(@wherepart, "$table.bug_id = bugs.bug_id");
my $ptable = "longdescnames_";
push(@supptables,
- "LEFT JOIN profiles $ptable ON $table.who = $ptable.userid");
+ "INNER JOIN profiles $ptable ON $table.who = $ptable.userid");
push(@clist, "$ptable.login_name", $type, $email);
}
if (@clist) {
@@ -745,7 +745,7 @@ sub GenerateSQL {
my $suppstring = "bugs";
foreach my $str (@supptables) {
if (!$suppseen{$str}) {
- if ($str !~ /^LEFT JOIN/i) {
+ if ($str !~ /^(LEFT|INNER) JOIN/i) {
$suppstring .= ",";
}
$suppstring .= " $str";