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

Colin Ma commented on SENTRY-407:
---------------------------------

Hi, I update the sentry DB with this patch. My DB is mysql and I got the 
following error about length when executed the script sentry-mysql-1.5.0.sql:

mysql> ALTER TABLE `SENTRY_DB_PRIVILEGE`
       ->   ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`);
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes


> Add schema upgrade script to handle schema changes in 1.5
> ---------------------------------------------------------
>
>                 Key: SENTRY-407
>                 URL: https://issues.apache.org/jira/browse/SENTRY-407
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.5.0
>            Reporter: Prasad Mujumdar
>            Assignee: Prasad Mujumdar
>         Attachments: SENTRY-407.1.patch, SENTRY-407.1.patch, 
> SENTRY-407.1.patch, SENTRY-407.2.patch
>
>
> In Sentry 1.5, we have new features that has changed DB store schema. We need 
> to include the schema upgrade scripts and add some test cases to make sure 
> the that upgrade via schema tool works correctly.



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

Reply via email to