From cc548fe98c5683a4fdc4e5508420a6e4fcb874e1 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Mon, 9 Apr 2018 17:21:54 +0000 Subject: [PATCH] Bug 12310: (QA follow-up) 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 --- .../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 e25582d6fa..6572ce0db0 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.18.0