From 34d40591d0e36ab67e64930e99e021893e031251 Mon Sep 17 00:00:00 2001 From: Lam Voong Date: Tue, 19 May 2020 09:54:15 -0700 Subject: [PATCH] DRYD-835: Update UOC migration script: Change OR to IN for userGroup UP --- .../resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql b/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql index 435f97838..44c5a80ec 100644 --- a/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql +++ b/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql @@ -440,7 +440,7 @@ BEGIN IF 2 = (SELECT count(*) c FROM information_schema.columns WHERE table_name = 'usergroup' - AND (column_name = 'usertype' OR column_name = 'userinstitutionrole')) + AND column_name IN ('usertype', 'userinstitutionrole')) THEN UPDATE usergroup SET userinstitutionrole = usertype -- 2.47.3