[ 
https://issues.apache.org/jira/browse/SENTRY-468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14147237#comment-14147237
 ] 

Dapeng Sun commented on SENTRY-468:
-----------------------------------

Hi [~prasadm] 
It seems the Test {{TestSentrySchemaTool#testUpgrade}} still fail, I fired a 
jira SENTRY-465 before. derby may don't need {{'}}
{noformat}
ALTER TABLE SENTRY_DB_PRIVILEGE DROP GRANTOR_PRINCIPAL;
ALTER TABLE SENTRY_ROLE DROP GRANTOR_PRINCIPAL;
ALTER TABLE SENTRY_GROUP DROP GRANTOR_PRINCIPAL;
ALTER TABLE SENTRY_ROLE_DB_PRIVILEGE_MAP ADD GRANTOR_PRINCIPAL VARCHAR(128);
ALTER TABLE SENTRY_ROLE_GROUP_MAP ADD GRANTOR_PRINCIPAL VARCHAR(128);
{noformat}

> Rename the oracle and postgre upgrade scripts to <jira-id>.<db-vendoer>.sql 
> format
> ----------------------------------------------------------------------------------
>
>                 Key: SENTRY-468
>                 URL: https://issues.apache.org/jira/browse/SENTRY-468
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.5.0
>            Reporter: Prasad Mujumdar
>            Assignee: Prasad Mujumdar
>             Fix For: 1.5.0
>
>         Attachments: SENTRY-468.1.patch, SENTRY-468.2.patch, 
> SENTRY-468.3.patch
>
>
> Some of the derby and mysql scripts files are created with a name with a  
> different format than what's assumed in the top level upgrade script for 1.5.
> Those should be rename as per <jira-id>.<db-vendoer>.sql format.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to