From e175ca1d5b112bb8a66053220b8eced03cc207cb Mon Sep 17 00:00:00 2001 From: Mark Tompsett 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 Signed-off-by: Sonia Bouis --- 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.7.4