Attachment 74526 Details for Bug 12310 – Bug 12310: Follow up to prevent updatedatabase noise

[patch] Bug 12310: Follow up to prevent updatedatabase noise

Bug-12310-Follow-up-to-prevent-updatedatabase-nois.patch (text/plain), 1.31 KB, created by Séverine Queune on 2018-04-19 09:31:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Séverine Queune

Created: 2018-04-19 09:31:36 UTC

Size: 1.31 KB

patch

obsolete

>From 15a923b1a4e3523e861be1649b1e2e16717fba49 Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Mon, 9 Apr 2018 17:21:54 +0000
>Subject: [PATCH] Bug 12310: Follow up to prevent updatedatabase noise
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>Added IGNORE into the SQL statement.
>TEST PLAN
>---------
>run the atomic update multiple times.
>-- noise
>apply patch
>run the atomic update multiple times.
>-- no noise
>
>Signed-off-by: SÃ©verine QUEUNE <severine.queune@bulac.fr>
>---
> installer/data/mysql/atomicupdate/bug12310_add_DecimalSeparators.sql | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug12310_add_DecimalSeparators.sql b/installer/data/mysql/atomicupdate/bug12310_add_DecimalSeparators.sql
>index e25582d..6572ce0 100644
>--- a/installer/data/mysql/atomicupdate/bug12310_add_DecimalSeparators.sql
>+++ b/installer/data/mysql/atomicupdate/bug12310_add_DecimalSeparators.sql
>@@ -1,2 +1,2 @@
>-INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
>+INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
> ('DecimalSeparators',  ',.', NULL ,  'The allowed separators between entire and decimal parts of numbers',  'Free');
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 12310: 28455 | 60530 | 60563 | 61357 | 61603 | 61604 | 62655 | 64671 | 64672 | 64673 | 64674 | 64675 | 64678 | 64679 | 64696 | 72104 | 72213 | 72983 | 73055 | 73215 | 73546 | 73657 | 73784 | 73785 | 73873 | 73874 | 73880 | 74524 | 74525 | 74526 | 74527 | 74528 | 74529 | 75123 | 75127 | 75128 | 75129 | 75130 | 75947 | 75948 | 75949 | 75950 | 75951 | 75952 | 75954 | 75955 | 75956 | 75957 | 75958 | 75959 | 76896 | 76933 | 77971 | 77972 | 77973 | 77995 | 78017 | 78631 | 78632 | 78633 | 78634 | 78635 | 78636 | 78637 | 78638