[
https://issues.apache.org/jira/browse/RANGER-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15360924#comment-15360924
]
Gautam Borad commented on RANGER-1063:
--------------------------------------
Committed to master :
https://github.com/apache/incubator-ranger/commit/1be6d93544448e86d3aa682243499418f2210206
> Increase size of sort_order column of x_policy_item_user_perm and
> x_policy_item_group_perm table
> ------------------------------------------------------------------------------------------------
>
> Key: RANGER-1063
> URL: https://issues.apache.org/jira/browse/RANGER-1063
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 0.5.0, 0.6.0
> Reporter: Pradeep Agrawal
> Assignee: Pradeep Agrawal
> Fix For: 0.6.0
>
> Attachments: RANGER-1063-1.patch
>
>
> Problem Statement : Currently data type of sort_order column is tinyint which
> can accept maximum 128 unsigned number; if any policy item is having more
> than 128 users then data truncation error might be generated at DB end and
> application will not be able to insert entry of any more user for specific
> policy item.
> Proposed Solution : Change data type of sort_order column of
> 'x_policy_item_user_perm' and 'x_policy_item_group_perm' table from tinyint
> to integer(4 byte)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
