From 7b043a40aa3b90ce29855a5a23bebc49cb8cf5c9 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Tue, 21 Jun 2005 03:22:36 +0000
Subject: Bug 298196: process_bug.cgi updates delta_ts even when no
 modifications are made - Patch by Frédéric Buclin <LpSolit@gmail.com>
 r=mkanat a=myk
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 process_bug.cgi | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

(limited to 'process_bug.cgi')

diff --git a/process_bug.cgi b/process_bug.cgi
index d97474863..c90ed42d9 100755
--- a/process_bug.cgi
+++ b/process_bug.cgi
@@ -1444,9 +1444,8 @@ foreach my $id (@idlist) {
             while (MoreSQLData()) {
                 push(@list, FetchOneColumn());
             }
-            SendSQL("UPDATE bugs SET delta_ts = $sql_timestamp, keywords = " .
-                    SqlQuote(join(', ', @list)) .
-                    " WHERE bug_id = $id");
+            $dbh->do("UPDATE bugs SET keywords = ? WHERE bug_id = ?",
+                     undef, join(', ', @list), $id);
         }
     }
     my $query = "$basequery\nwhere bug_id = $id";
@@ -1735,7 +1734,7 @@ foreach my $id (@idlist) {
     $i = 0;
     foreach my $col (@::log_columns) {
         # Consider NULL db entries to be equivalent to the empty string
-        $newvalues[$i] ||= '';
+        $newvalues[$i] = defined($newvalues[$i]) ? $newvalues[$i] : '';
         # Convert the deadline to the YYYY-MM-DD format.
         if ($col eq 'deadline') {
             $newvalues[$i] = format_time($newvalues[$i], "%Y-%m-%d");
-- 
cgit v1.2.3-24-g4f1b