[SENTRY-2219] Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH only when it does not exist for Oracle

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.2.0
• Component/s: Sentry
• Assignee: Na Li
• Reporter: Na Li
• Created: 04/May/18 21:53
• Updated: 02/Jan/20 17:07
• Resolved: 09/May/18 16:06

Description

Adding this index AUTHZ_PATH_FK_IDX in Oracle improves performance significantly, therefore some user may have added this index manually. To avoid exception when running upgrade sql script, we should add this index only when it does not exist.

Issue Links

• links to: Review Link for this case

Sub-Tasks

• Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH for Postgres only when it does not exist: Resolved