Na Li created SENTRY-2259:
-----------------------------
Summary: SQL Constrain name is too long for Oracle 11.2
Key: SENTRY-2259
URL: https://issues.apache.org/jira/browse/SENTRY-2259
Project: Sentry
Issue Type: Bug
Components: Sentry
Affects Versions: 2.1.0
Reporter: Na Li
Assignee: Na Li
Prior to Oracle version 12.2, identifiers are not allowed to exceed 30
characters in length
Names must be from 1 to 30 bytes long with these exceptions:
Names of databases are limited to 8 bytes.
Names of database links can be as long as 128 bytes.
The following index name is 32 bytes, and cause exception "ORA-00972:
identifier is too long" on oracle DB 11.2.
SENTRY_USER_DB_PRIVILEGE_MAP_PK
SEN_USR_DB_PRV_MAP_SN_DB_PRV_FK
{code}
ALTER TABLE SENTRY_USER_DB_PRIVILEGE_MAP
ADD CONSTRAINT SENTRY_USER_DB_PRIVILEGE_MAP_PK PRIMARY KEY
(USER_ID,DB_PRIVILEGE_ID);
ALTER TABLE SENTRY_USER_DB_PRIVILEGE_MAP
ADD CONSTRAINT SEN_USR_DB_PRV_MAP_SN_DB_PRV_FK
FOREIGN KEY (DB_PRIVILEGE_ID) REFERENCES
SENTRY_DB_PRIVILEGE(DB_PRIVILEGE_ID);
{code}
Need to change the constrain name to be smaller than 30 characters
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
