----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/72702/ -----------------------------------------------------------
(Updated Aug. 6, 2020, 6:01 a.m.) Review request for ranger, Ankita Sinha, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep Agrawal, Ramesh Mani, Sailaja Polavarapu, and Velmurugan Periasamy. Bugs: RANGER-2923 https://issues.apache.org/jira/browse/RANGER-2923 Repository: ranger Description ------- Insert values for the column "sync_source_info" under table "x_ugsync_audit_info" can go beyond the maximum length of column. (currently limit is VARCHAR 4000). Now changing data type to different db flavours as follows : mysql : VARCHAR => MEDIUMTEXT oracle : VARCHAR => CLOB postgres : VARCHAR => TEXT sqlanywhere : VARCHAR => TEXT sqlserver : VARCHAR => nvarchar(max) Diffs (updated) ----- security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 832d650cf security-admin/db/mysql/patches/048-alter-sync-source-info-in-x-ugsync-audit-info.sql PRE-CREATION security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql 4576e9677 security-admin/db/oracle/patches/048-alter-sync-source-info-in-x-ugsync-audit-info.sql PRE-CREATION security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql 6a0941ff6 security-admin/db/postgres/patches/048-alter-sync-source-info-in-x-ugsync-audit-info.sql PRE-CREATION security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql b663f3b02 security-admin/db/sqlanywhere/patches/048-alter-sync-source-info-in-x-ugsync-audit-info.sql PRE-CREATION security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql ab370ffb1 security-admin/db/sqlserver/patches/048-alter-sync-source-info-in-x-ugsync-audit-info.sql PRE-CREATION Diff: https://reviews.apache.org/r/72702/diff/3/ Changes: https://reviews.apache.org/r/72702/diff/2-3/ Testing ------- Inserted large values of more than 4000 characters in column "sync_source_info" under table "x_ugsync_audit_info". Insert query succeeds. Thanks, Mahesh Bandal