You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ranger.apache.org by pr...@apache.org on 2021/08/27 13:39:49 UTC
[ranger] branch master updated: RANGER-3285: Addendum patch to fix
a syntax in oracle patch
This is an automated email from the ASF dual-hosted git repository.
pradeep 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 93a15b8 RANGER-3285: Addendum patch to fix a syntax in oracle patch
93a15b8 is described below
commit 93a15b81edf19f0c8d5233ee5213d0b889d5f39a
Author: pradeep <pr...@apache.org>
AuthorDate: Fri Aug 27 19:07:23 2021 +0530
RANGER-3285: Addendum patch to fix a syntax in oracle patch
---
.../055-add-syncSource-col-in-x_user-x_portal_user-x_group.sql | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/security-admin/db/oracle/patches/055-add-syncSource-col-in-x_user-x_portal_user-x_group.sql b/security-admin/db/oracle/patches/055-add-syncSource-col-in-x_user-x_portal_user-x_group.sql
index a1d4b36..ed8dbaf 100644
--- a/security-admin/db/oracle/patches/055-add-syncSource-col-in-x_user-x_portal_user-x_group.sql
+++ b/security-admin/db/oracle/patches/055-add-syncSource-col-in-x_user-x_portal_user-x_group.sql
@@ -21,16 +21,16 @@ BEGIN
execute immediate 'ALTER TABLE x_portal_user ADD sync_source VARCHAR(4000) DEFAULT NULL NULL';
end if;
- v_count number:=0;
+ v_count:=0;
select count(*) into v_count from user_tab_cols where table_name='x_user' and column_name='sync_source';
if (v_count = 0) then
execute immediate 'ALTER TABLE x_user ADD sync_source VARCHAR(4000) DEFAULT NULL NULL';
end if;
- v_count number:=0;
+ v_count:=0;
select count(*) into v_count from user_tab_cols where table_name='X_GROUP' and column_name='sync_source';
if (v_count = 0) then
execute immediate 'ALTER TABLE X_GROUP ADD sync_source VARCHAR(4000) DEFAULT NULL NULL';
end if;
commit;
-END;/
\ No newline at end of file
+END;/