[RANGER-1490] Increase size of sort_order column of x_policy_resource_map

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5.0, 0.6.0, 0.7.0
• Fix Version/s: 1.0.0, 0.7.1
• Component/s: Ranger
• Assignee: Pradeep Agrawal
• Reporter: Pradeep Agrawal
• Created: 03/Apr/17 06:37
• Updated: 25/Apr/17 22:29
• Resolved: 25/Apr/17 22:29

Description

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)

Issue Links

• links to: Apache review request link