Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-2923

Changing data type of sync_source_info column to accommodate more characters

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.1.0
    • 2.1.0
    • Ranger
    • None

    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)

      Attachments

        Activity

          People

            maheshbandal Mahesh Bandal
            maheshbandal Mahesh Bandal
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: