From c6fa8c4b4e364da79e2b07a140400caa0c560cb1 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 20 Jun 2019 16:27:21 -0400 Subject: [PATCH] JBAS-1832 more 3.2 sql upgrade insert wrappers Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-additions.sql | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) diff --git a/KCLS/sql/schema/deploy/3.2-additions.sql b/KCLS/sql/schema/deploy/3.2-additions.sql index f4a8cb61a6..5140d9d9fb 100644 --- a/KCLS/sql/schema/deploy/3.2-additions.sql +++ b/KCLS/sql/schema/deploy/3.2-additions.sql @@ -271,10 +271,16 @@ BEGIN; -- in here fails. Then run main reingest sans transaction. -- add the flag ingest.disable_authority_full_rec if it does not exist -INSERT INTO config.internal_flag (name, enabled) -SELECT 'ingest.disable_authority_full_rec', FALSE -WHERE NOT EXISTS (SELECT 1 FROM config.internal_flag -WHERE name = 'ingest.disable_authority_full_rec'); +DO $INSERT$ +BEGIN + IF evergreen.insert_on_deploy() THEN + INSERT INTO config.internal_flag (name, enabled) + SELECT 'ingest.disable_authority_full_rec', FALSE + WHERE NOT EXISTS (SELECT 1 FROM config.internal_flag + WHERE name = 'ingest.disable_authority_full_rec'); + END IF; -- insert_on_deploy +END $INSERT$; + CREATE TEMPORARY TABLE internal_flag_state AS SELECT name, enabled -- 2.11.0