----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/70500/#review214746 -----------------------------------------------------------
Ship it! Ship It! - Gautam Borad On April 18, 2019, 3:30 a.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/70500/ > ----------------------------------------------------------- > > (Updated April 18, 2019, 3:30 a.m.) > > > 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 > >
