----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/73437/#review223217 -----------------------------------------------------------
Ship it! Ship It! - Mehul Parikh On June 30, 2021, 8:27 a.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/73437/ > ----------------------------------------------------------- > > (Updated June 30, 2021, 8:27 a.m.) > > > Review request for ranger, Dhaval Shah, Abhay Kulkarni, Madhan Neethiraj, > Mehul Parikh, Ramesh Mani, Sailaja Polavarapu, Vishal Suvagia, and Velmurugan > Periasamy. > > > Bugs: RANGER-3324 > https://issues.apache.org/jira/browse/RANGER-3324 > > > Repository: ranger > > > Description > ------- > > **Problem Statement:** Currently Ranger core db schema is not idempotent for > all db flavors. Ranger core DB schema for MySQL and MS-SQL flavor may fail to > execute if we execute them again. > > Few identifier names have more than 30 characters which is not allowed in > oracle 11G, so we have to trim the name of index/identifier. > > **Proposed solution:** Changed the statements of schema script as per their > dependencies on other table. > have to trim the name of index/identifier for oracle db flavor. > > > Diffs > ----- > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > c16a189dd > security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql > e92f5cc48 > > security-admin/db/oracle/patches/052-add-unique-constraint-on-change-logs.sql > 8c0672074 > security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql > 91751a27d > > security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql > 4a1d5f44c > security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql > 4535b68b7 > > > Diff: https://reviews.apache.org/r/73437/diff/1/ > > > Testing > ------- > > Tested fresh installation of ranger with all DB flavors(except sql-anywhere) > > > Thanks, > > Pradeep Agrawal > >
