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

Upgrade from 7.0 GA1 and below: SQLServer and Sybase databases present an incorrect size for STRING fields

    Details

    • Fix Priority:
      4

      Description

      The issue https://issues.liferay.com/browse/LPS-67342 increased the size for STRING fields from 1000 to 4000 and from 2000 to 4000 in Sybase and SQLServer respectively:
      https://github.com/liferay/liferay-portal-ee/commit/2b22e43cc72fafd17c42ca6e6c853c2e4e054cf8

      However we didn't create an upgrade process for this case and that means that we still keep the previous size for those installatations which started in 7.0 GA1 and below and will perform an upgrade to future versions.

      Steps to reproduce it:

      1. Start a 7.0GA1 (no fix packs) or 6.2 using SQLServer
      2. Upgrade to master/7.1

      Actual results:
      Check the size for AssetEntry.title, it will be 2000

      Expected results:
      Check the size for AssetEntry.title, it should be 4000

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                support-lep@liferay.com SE Support
                Reporter:
                alberto.chaparro Alberto Chaparro
                Participants of an Issue:
                Recent user:
                Alberto Chaparro
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  7.0.3 CE GA4