Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-68410

Upgrade process needed to increase the length of STRING columns in Sybase and SQL Server

    Details

    • Branch Version/s:
      7.0.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      4
    • Databases:
      SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Sybase ASE 15.7, Sybase ASE 16
    • Sprint:
      Quinzite 11/8-11/22

      Description

      The issue LPS-67342 modified the type STRING for Sybase from varchar(1000) to varchar(4000) and for SQLServer from varchar(2000) to varchar(4000).

      We need to add an upgrade process to modify the field lengths for users coming from old Liferay versions.

      Steps to reproduce it 1

      1. Start Liferay 6.2 using SQL Server
      2. Upgrade to master (it's possible that you even can't upgrade for this reason)
      3. Check length for LayoutPrototype.description field.

      Result: Length is 2000
      Expected result: Length is 4000

      Steps to reproduce it 2

      1. Start Liferay 6.2 using Sybase
      2. Upgrade to master (it's possible that you even can't upgrade for this reason)
      3. Check length for LayoutPrototype.description field.

      Result: Length is 1000
      Expected result: Length is 4000

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 27 weeks ago