[RANGER-2923] Changing data type of sync_source_info column to accommodate more characters

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.0
• Component/s: Ranger
• Assignee: Mahesh Hanumant Bandal
• Reporter: Mahesh Hanumant Bandal
• Created: 23/Jul/20 11:45
• Updated: 12/Aug/20 12:36
• Resolved: 12/Aug/20 12:36

Description

Insert values for the column "sync_source_info" under table "x_ugsync_audit_info" can go beyond the maximum length of column. (currently limit is VARCHAR 4000).

Now changing data type to different db flavours as follows :

mysql              : VARCHAR => MEDIUMTEXT

oracle             : VARCHAR => CLOB

postgres        : VARCHAR => TEXT

sqlanywhere : VARCHAR => TEXT

sqlserver        : VARCHAR => nvarchar(max)