Attachment 93346 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.60 KB, created by Biblibre Sandboxes on 2019-10-01 08:38:48 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Biblibre Sandboxes

Created: 2019-10-01 08:38:48 UTC

Size: 1.60 KB

patch

obsolete

>From 0f59e258900eb65b25ae457121e8905b00e0b05c 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>
>---
> .../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 08e6e38..6d6aa04 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.7.4

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