-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/70500/
-----------------------------------------------------------
Review request for ranger, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj,
Mehul Parikh, Nikhil P, Ramesh Mani, and Velmurugan Periasamy.
Bugs: RANGER-2402
https://issues.apache.org/jira/browse/RANGER-2402
Repository: ranger
Description
-------
Problem Statement: Currently Ranger core db schema is not idempotent for all db
flavors. Ranger core DB schema for Oracle and SQL anywhere flavor may fail to
execute if we execute them again for the same DB flavor.
Proposed Solution: I have added if statements before the insert statements.
Diffs
-----
security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 2cdd8fbb6
security-admin/db/mysql/patches/037-create-security-zone-schema.sql b2b69f0dc
security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
88fa98a99
security-admin/db/oracle/patches/037-create-security-zone-schema.sql
9b6931451
security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
0ae714753
security-admin/db/postgres/patches/037-create-security-zone-schema.sql
812133077
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
ea0ff2b9c
security-admin/db/sqlanywhere/patches/037-create-security-zone-schema.sql
e4bfb78e4
security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql
13be7daa9
security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql
68d3a05bf
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
d45170957
security-admin/db/sqlserver/patches/037-create-security-zone-schema.sql
be0287cf4
Diff: https://reviews.apache.org/r/70500/diff/1/
Testing
-------
Tested the upgrade case for all the db flavor after RANGER-2400 commit.
Thanks,
Pradeep Agrawal
