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

Upgrade/Verify process for existing DB2 databases due to fix from LPS-53451

    Details

      Description

      The fix from LPS-53451 changes the DB2DB.java file which upon an ant build (ant all) will modify the default portal-tables.sql file. All previously declared STRING types will have an increase in data storage from VARCHAR(750) to VARCHAR(4000) upon a new database environment while all existing DB2 databases will only have the VARCHAR(750) limit.

      This can potentially create bugs where improvements/tasks/new features take into account of the increased size limit.

      Steps:
      1. start up a DB2 database environment prior to LPS-53451 fix.
      2. check the database by running

      desc BlogsEntry;
      or
      describe BlogsEntry;
      

      to make sure the following are set to VARCHAR(750), following list is taken from Master portal-tables.sql which states which fields are defaulted to a "STRING"

      - subtitle STRING null
      - description STRING null
      - smallImageURL STRING null
      

      3. build/run Liferay after the fix for LPS-53451 has been implemented
      4. connect to the same DB2 database as Step #1
      5. check the database again

      Expected Behavior: The default data type should be VARCHAR(4000).
      Actual Behavior: The default data type is still VARCHAR(750).

      ----------

      UI Steps:
      1. follow steps 1, 3, and 4
      2. sign in as [email protected]
      3. put a Blogs Entry portlet to a page
      4. try and put a subtitle, description, or small image URL that is larger than 750 characters, should receive an error

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              michael.saechang Michael Saechang
              Reporter:
              jenny.chen Jenny Chen
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 43 weeks, 1 day ago

                  Packages

                  Version Package