Attachment 95100 Details for Bug 21249 – Bug 21249: Made the SQL INSERT statement idempotent

[patch] Bug 21249: Made the SQL INSERT statement idempotent

Bug-21249-Made-the-SQL-INSERT-statement-idempotent.patch (text/plain), 1.67 KB, created by Jonathan Druart on 2019-11-06 11:21:21 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2019-11-06 11:21:21 UTC

Size: 1.67 KB

patch

obsolete

>From e946b130b9b4dd684d9165bf52690ab49c04116d Mon Sep 17 00:00:00 2001
>From: Alex Buckley <alexbuckley@catalyst.net.nz>
>Date: Thu, 27 Dec 2018 01:44:22 +0000
>Subject: [PATCH] Bug 21249: Made the SQL INSERT statement idempotent
>
>Sponsored-BY: Brimbank Library, Australia
>
>Signed-off-by: Amandine Zocca <azocca@ville-montauban.fr>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> .../atomicupdate/bug_21249-Branch_to_limit_advanced_search_results.sql  | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21249-Branch_to_limit_advanced_search_results.sql b/installer/data/mysql/atomicupdate/bug_21249-Branch_to_limit_advanced_search_results.sql
>index 08e6e38e01..6d6aa04808 100644
>--- a/installer/data/mysql/atomicupdate/bug_21249-Branch_to_limit_advanced_search_results.sql
>+++ b/installer/data/mysql/atomicupdate/bug_21249-Branch_to_limit_advanced_search_results.sql
>@@ -1 +1 @@
>-INSERT INTO systempreferences (variable, value, options, explanation, type) VALUES ('AdvancedSearchBranchFieldToUse', 'homebranch and holdingbranch', 'homebranch|holdingbranch|homebranch and holdingbranch', 'When a library or group of libraries is selected from the advanced search compare the selected branch value against this branch field(s) selected', 'choice');
>+INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('AdvancedSearchBranchFieldToUse', 'homebranch and holdingbranch', 'homebranch|holdingbranch|homebranch and holdingbranch', 'When a library or group of libraries is selected from the advanced search compare the selected branch value against this branch field(s) selected', 'choice');
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21249: 78013 | 78014 | 78921 | 82138 | 83518 | 93345 | 93346 | 95099 | 95100 | 95101 | 103618 | 103619 | 103620 | 103621 | 103622 | 117220 | 117221 | 117222 | 117223 | 117224 | 120481 | 120567 | 120568 | 120569 | 120570 | 120571 | 120572 | 120575 | 120576 | 120577 | 120578 | 120579 | 120580