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

AssetListEntrySegmentsEntryRel db column mismatch on upgraded database

Details

    Description

      Steps to Reproduce:

      1. Import attached 7.3.10 database to MySQL data-archive-portal-mysql.zip
      2. Upgrade this database to Master (with DXP profile)
        • tools/portal-tools-db-upgrade-client/db_upgrade.sh
      3. Connect Master to a different, empty database schema
      4. Start master against blank database schema
      5. Compare AssetListEntrySegmentsEntryRel tables between upgraded and fresh database

      Expected Result:
      Table indexes match between the 2 databases.

      Actual Result:
      "priority" column default value is different

      7.3 Upgraded database:

      `priority` int(11) NOT NULL DEFAULT '0'
      

      Fresh master database:

      `priority` int(11) DEFAULT NULL
      

      Attachments

        Activity

          People

            susan.chen Susan Chen
            victor.ware Victor Ware
            Kiyoshi Lee Kiyoshi Lee
            Cristina Gonzalez Cristina Gonzalez
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              22 weeks, 2 days ago

              Packages

                Version Package
                7.4.3.40 CE GA40
                7.4.3.41 CE GA41
                7.4.3.42 CE GA42
                Master