[jira] [Updated] (SENTRY-2259) SQL CONSTRAINT name is too long for Oracle 11.2

2018-06-06 Thread Na Li (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SENTRY-2259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Na Li updated SENTRY-2259:
--
Status: Patch Available  (was: Open)

> SQL CONSTRAINT 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
>Priority: Major
> Attachments: SENTRY-2259.001.patch
>
>
> 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)

[jira] [Updated] (SENTRY-2259) SQL CONSTRAINT name is too long for Oracle 11.2

2018-06-06 Thread Na Li (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SENTRY-2259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Na Li updated SENTRY-2259:
--
Attachment: SENTRY-2259.001.patch

> SQL CONSTRAINT 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
>Priority: Major
> Attachments: SENTRY-2259.001.patch
>
>
> 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)

[jira] [Updated] (SENTRY-2259) SQL CONSTRAINT name is too long for Oracle 11.2

2018-06-06 Thread Na Li (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SENTRY-2259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Na Li updated SENTRY-2259:
--
Summary: SQL CONSTRAINT name is too long for Oracle 11.2  (was: SQL 
Constrain name is too long for Oracle 11.2)

> SQL CONSTRAINT 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
>Priority: Major
>
> 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)