From 83cdee1c166ef315357e05dbf06b596e956e1d3e Mon Sep 17 00:00:00 2001
From: "bbaetz%acm.org" <>
Date: Sun, 23 Nov 2003 17:31:44 +0000
Subject: Bug 226284 - slow queries for creation_ts r,a=justdave

---
 Bugzilla/Search.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 3a211e078..73774e82b 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -255,7 +255,6 @@ sub init {
             push(@wherepart, "bugs.delta_ts >= $sql_chfrom") if ($sql_chfrom);
             push(@wherepart, "bugs.delta_ts <= $sql_chto") if ($sql_chto);
         } else {
-            push(@supptables, "bugs_activity actcheck");
             my $sql_bugschanged = '';
             my @list;
             foreach my $f (@chfield) {
@@ -269,6 +268,7 @@ sub init {
                 }
             }
             if(@list) {
+                push(@supptables, "bugs_activity actcheck");
                 $sql_bugschanged .= ' OR ' if($sql_bugschanged ne '');
                 $sql_bugschanged .= "(actcheck.bug_id = bugs.bug_id AND " .
                                        "(" . join(' OR ', @list) . ")";
-- 
cgit v1.2.3-24-g4f1b