From a46c91543e36ebf4644e022453b47d381220df2e Mon Sep 17 00:00:00 2001
From: "dkl%redhat.com" <>
Date: Thu, 8 Jul 2004 09:19:42 +0000
Subject: Patch for bug 190432; saving a named query uses REPLACE INTO (not
 ANSI); patch by David Lawrence <dkl@redhat.com>; r=vladd; a=justdave

---
 checksetup.pl | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

(limited to 'checksetup.pl')

diff --git a/checksetup.pl b/checksetup.pl
index 3c4793407..c9ced42ec 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -2094,12 +2094,14 @@ sub AddFDef ($$$) {
     my ($fieldid) = ($sth->fetchrow_array());
     if (!$fieldid) {
         $fieldid = 'NULL';
-    }
-
-    $dbh->do("REPLACE INTO fielddefs " .
+        $dbh->do("INSERT INTO fielddefs " .
              "(fieldid, name, description, mailhead, sortkey) VALUES " .
              "($fieldid, $name, $description, $mailhead, $headernum)");
-    $headernum++;
+        $headernum++;
+    } else {
+        $dbh->do("UPDATE fielddefs SET name = $name, description = $description, " .
+                 "mailhead = $mailhead WHERE fieldid = $fieldid");
+    }
 }
 
 
-- 
cgit v1.2.3-24-g4f1b