From f29a9d2bc6aae971102cfba9060d09090c2998ab 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 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 --- 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