Attachment 92099 Details for Bug 23416 – Bug 23416: (QA follow-up) Add IGNORE to updatedatabase SQL statement

[patch] Bug 23416: (QA follow-up) Add IGNORE to updatedatabase SQL statement

Bug-23416-QA-follow-up-Add-IGNORE-to-updatedatabas.patch (text/plain), 1.20 KB, created by Katrin Fischer on 2019-08-08 17:02:18 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2019-08-08 17:02:18 UTC

Size: 1.20 KB

patch

obsolete

>From 4d0e78085dec0ed7b48df86830d7cc25c9decd1f Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Thu, 8 Aug 2019 13:37:58 +0000
>Subject: [PATCH] Bug 23416: (QA follow-up) Add IGNORE to updatedatabase SQL
> statement
>
>---
> .../data/mysql/atomicupdate/Bug_23416_add_PreserveSerialNotes_pref.perl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/Bug_23416_add_PreserveSerialNotes_pref.perl b/installer/data/mysql/atomicupdate/Bug_23416_add_PreserveSerialNotes_pref.perl
>index 751739f74f..96e321eb59 100644
>--- a/installer/data/mysql/atomicupdate/Bug_23416_add_PreserveSerialNotes_pref.perl
>+++ b/installer/data/mysql/atomicupdate/Bug_23416_add_PreserveSerialNotes_pref.perl
>@@ -1,7 +1,7 @@
> $DBversion = 'XXX';
> if( CheckVersion( $DBversion ) ) {
>     $dbh->do(q|
>-        INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
>+        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
>         ('PreserveSerialNotes','1','','When a new "Expected" issue is generated, should it be prefilled with last created issue notes?','YesNo');
>     |);
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 23416: 91920 | 91929 | 91932 | 91934 | 92098 | 92099