commit c6734e57362691fbf3456baf7ec130b9876f945a
author mateenmansoori <ma3naushad@gmail.com> Wed Apr 07 14:45:15 2021 +0530
committer Mehul Parikh <mehul@apache.org> Wed Apr 14 21:21:26 2021 +0530
tree bb44969061f0c6ce7fc8ce42272c0612e1fc31a3
parent 7f5b82bff2df72f20f5c41ba095406d354f8acf0

RANGER-3234 : Ranger db patch no 045 is failing for oracle db

Signed-off-by: Mehul Parikh <mehul@apache.org>

security-admin/db/oracle/patches/045-add-displayName-col-in-x_service_def_and_x_service.sql

diff --git a/security-admin/db/oracle/patches/045-add-displayName-col-in-x_service_def_and_x_service.sql b/security-admin/db/oracle/patches/045-add-displayName-col-in-x_service_def_and_x_service.sql
index 54c5944..3fc4b97 100644
--- a/security-admin/db/oracle/patches/045-add-displayName-col-in-x_service_def_and_x_service.sql
+++ b/security-admin/db/oracle/patches/045-add-displayName-col-in-x_service_def_and_x_service.sql
@@ -16,7 +16,7 @@
 DECLARE
         v_count number:=0;
 BEGIN
-        select count(*) into v_count from user_tab_cols where table_name='x_service_def' and column_name='display_name';
+        select count(*) into v_count from user_tab_cols where table_name='X_SERVICE_DEF' and column_name='DISPLAY_NAME';
         if (v_count = 0) then
                 execute immediate 'ALTER TABLE x_service_def ADD display_name VARCHAR(1024) DEFAULT NULL NULL';
                 execute immediate 'UPDATE x_service_def SET display_name=name';
@@ -24,7 +24,7 @@
         end if;
 
         v_count:=0;
-        select count(*) into v_count from user_tab_cols where table_name='x_service' and column_name='display_name';
+        select count(*) into v_count from user_tab_cols where table_name='X_SERVICE' and column_name='DISPLAY_NAME';
         if (v_count = 0) then
                 execute immediate 'ALTER TABLE x_service ADD display_name VARCHAR(255) DEFAULT NULL NULL';
                 execute immediate 'UPDATE x_service SET display_name=name';
@@ -32,21 +32,21 @@
         commit;
 
         v_count:=0;
-        select count(*) into v_count from user_tab_cols where table_name='x_portal_user' and column_name='other_attributes';
+        select count(*) into v_count from user_tab_cols where table_name='X_PORTAL_USER' and column_name='OTHER_ATTRIBUTES';
         if (v_count = 0) then
                 execute immediate 'ALTER TABLE x_portal_user ADD other_attributes VARCHAR(4000) DEFAULT NULL NULL';
         end if;
 
         v_count:=0;
-        select count(*) into v_count from user_tab_cols where table_name='x_user' and column_name='other_attributes';
+        select count(*) into v_count from user_tab_cols where table_name='X_USER' and column_name='OTHER_ATTRIBUTES';
         if (v_count = 0) then
                 execute immediate 'ALTER TABLE x_user ADD other_attributes VARCHAR(4000) DEFAULT NULL NULL';
         end if;
 
         v_count:=0;
-        select count(*) into v_count from user_tab_cols where table_name='X_GROUP' and column_name='other_attributes';
+        select count(*) into v_count from user_tab_cols where table_name='X_GROUP' and column_name='OTHER_ATTRIBUTES';
         if (v_count = 0) then
                 execute immediate 'ALTER TABLE X_GROUP ADD other_attributes VARCHAR(4000) DEFAULT NULL NULL';
         end if;
         commit;
-END;/
\ No newline at end of file
+END;/