This is an automated email from the ASF dual-hosted git repository.
mehul pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ranger.git
The following commit(s) were added to refs/heads/master by this push:
new c6734e5 RANGER-3234 : Ranger db patch no 045 is failing for oracle db
c6734e5 is described below
commit c6734e57362691fbf3456baf7ec130b9876f945a
Author: mateenmansoori <[email protected]>
AuthorDate: Wed Apr 7 14:45:15 2021 +0530
RANGER-3234 : Ranger db patch no 045 is failing for oracle db
Signed-off-by: Mehul Parikh <[email protected]>
---
...45-add-displayName-col-in-x_service_def_and_x_service.sql | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
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 @@ BEGIN
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 @@ BEGIN
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;/
