Moved all the long descriptions out of the bugs table, and into a new

table.  There is now a separate entry for each new long description,
rather than appending them all together in one big field.

1 files changed, 15 insertions, 7 deletions

diff --git a/buglist.cgi b/buglist.cgi
index 27e67e390..2309b3205 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -480,15 +480,23 @@ foreach my $f ("short_desc", "long_desc", "bug_file_loc",
     if (defined $::FORM{$f}) {
         my $s = trim($::FORM{$f});
         if ($s ne "") {
+            my $n = $f;
             $s = SqlQuote($s);
-            if ($::FORM{$f . "_type"} eq "regexp") {
-                $query .= "and $f regexp $s\n";
-            } elsif ($::FORM{$f . "_type"} eq "notregexp") {
-                $query .= "and $f not regexp $s\n";
-            } elsif ($::FORM{$f . "_type"} eq "casesubstring") {
-                $query .= "and instr($f, $s)\n";
+            my $type = $::FORM{$f . "_type"};
+            if ($f eq "long_desc") {
+                # Patch in the longdescs table.
+                $query =~ s/where/, longdescs where/;
+                $query .= "and longdescs.bug_id = bugs.bug_id\n";
+                $n = "longdescs.thetext";
+            }
+            if ($type eq "regexp") {
+                $query .= "and $n regexp $s\n";
+            } elsif ($type eq "notregexp") {
+                $query .= "and $n not regexp $s\n";
+            } elsif ($type eq "casesubstring") {
+                $query .= "and instr($n, $s)\n";
             } else {
-                $query .= "and instr(lower($f), lower($s))\n";
+                $query .= "and instr(lower($n), lower($s))\n";
             }
         }
     }