[RANGER-1063] Increase size of sort_order column of x_policy_item_user_perm and x_policy_item_group_perm table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5.0, 0.6.0
• Fix Version/s: 0.6.0
• Component/s: Ranger
• Assignee: Pradeep Agrawal
• Reporter: Pradeep Agrawal
• Created: 25/Jun/16 12:28
• Updated: 21/Apr/17 08:59
• Resolved: 04/Jul/16 06:51

Description

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)

Issue Links

• links to: Apache review request link