[jira] [Commented] (RANGER-1490) Increase size of sort_order column of x_policy_resource_map

["Pradeep Agrawal (JIRA)" <ji...@apache.org>]

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

Pradeep Agrawal commented on RANGER-1490:
-----------------------------------------

Committed to ranger 0.7 branch: https://github.com/apache/ranger/commit/c6f5f101b75f8ae0386a94ffa36e8b3653649c7a
Committed to the ranger master branch: https://github.com/apache/ranger/commit/37667d7faf87ec0000e5d236a19891046d66f1c1

> Increase size of sort_order column of x_policy_resource_map
> -----------------------------------------------------------
>
>                 Key: RANGER-1490
>                 URL: https://issues.apache.org/jira/browse/RANGER-1490
>             Project: Ranger
>          Issue Type: Bug
>          Components: Ranger
>    Affects Versions: 0.5.0, 0.6.0, 0.7.0
>            Reporter: Pradeep Agrawal
>            Assignee: Pradeep Agrawal
>             Fix For: 1.0.0, 0.7.1
>
>         Attachments: RANGER-1490-master-branch.patch
>
>
> Problem Statement : Currently data type of sort_order column is tinyint which can accept maximum 128 unsigned number; if any policy is having more than 128 resource entries then data truncation error might be generated at DB end and application will not be able to insert entry of any more resources for specific policy.
> Proposed Solution : Change data type of sort_order column of 'x_policy_resource_map' from tinyint to integer(4 byte)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)