From 3f105dc6e38331d76c775724367ed4705c5eb283 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 14 Mar 2018 11:04:25 -0400 Subject: [PATCH] JBAS-1802 2.12 SQL upgrade commits Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql b/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql index 0d188606f9..8da5629936 100644 --- a/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.10-to-2.12-upgrade.sql @@ -5489,11 +5489,13 @@ CREATE INDEX actor_usr_second_given_name_unaccent_idx ON actor.usr (evergreen.un CREATE INDEX actor_usr_family_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(family_name)); CREATE INDEX actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname)); --- SELECT 'Commiting... ', CLOCK_TIMESTAMP(); --- COMMIT; +SELECT 'Commiting... ', CLOCK_TIMESTAMP(); +COMMIT; +/* SELECT 'Rolling Back... ', CLOCK_TIMESTAMP(); ROLLBACK; -- TESTING +*/ SELECT 'Upgrade complete: ', CLOCK_TIMESTAMP(); -- 2.11.0