You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ranger.apache.org by me...@apache.org on 2021/04/15 07:57:47 UTC
[ranger] 02/02: RANGER-3234 : Ranger db patch no 045 is failing for
oracle db
This is an automated email from the ASF dual-hosted git repository.
mehul pushed a commit to branch ranger-2.2
in repository https://gitbox.apache.org/repos/asf/ranger.git
commit 9b6fad5787a37829dbd4f25c29040663127ee452
Author: mateenmansoori <ma...@gmail.com>
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 <me...@apache.org>
---
...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;/