----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/56562/ -----------------------------------------------------------
Review request for sentry, Alexander Kolbasov, Hao Hao, Vamsee Yarlagadda, and Vadim Spector. Repository: sentry Description ------- SENTRY-1614 Removed code having PATHS column as primary key. Primary key of this long is not accepted by all databases Code changes include following 1. Removing PATHS column from primary key as Primary key of this long is not accepted by all databases. 2. Remove the index on MAUTHZPATHSMAPPING_PATHS. As there would be implicit index created with AUTHZ_OBJ_ID_OID. Diffs ----- sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql 1883626262bf4f4936f156a7ac74365b9b5873df sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql 1829e2fa1f02a4339e7af4bf45a169013e9ec65f sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql 7de9751892a8ff84067f67d542ac58d33e9148d8 sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql adf5f1f39596309183f8c80d2c8ad1f1a7730236 sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-1.8.0.sql 0606116a1d31c400fb6dadcd80a2284007117ab2 sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-1.8.0.sql be9a33e6b0904b7c8ec522906d967081631108d6 sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql 1c8848c30d0432ebdbd18b73a1d27c61d2b7bcae sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql fc7b53f41e97fad5e5baeb254b686a0e8cc5b003 sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.8.0.sql ce807a5aee9d04e119dde32784cbe958bf933feb sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-1.8.0.sql 36573771d84ff9c0d7683f20d7df75ae6be656b7 Diff: https://reviews.apache.org/r/56562/diff/ Testing ------- ran the sql scripts with all the databases we support(db2, postgress, oracle and mysql) Ran TestSentrySchemaTool tests. Thanks, kalyan kumar kalvagadda
