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

Journal Upgrade not using SQLTransformer

Details

    Description

      Steps to reproduce:
      1) Set up Liferay bundle 6.1 GA3 with database Oracle 12.1 
      2) Start the portal 
      3) Create 1 structure of JournalArticle, add an article with this structure (check the db for classTypeId of the asset)

      select entryid, classPK, classTypeId  from assetentry;

      4) Performed the upgrade to Liferay DXP fix-pack-de-50-7010

      5) Check the classTypeId of the Asset again.

       

      expected result: the classTypeId should be changed
      actual result: the classTypeId is still the same

       

      Root cause: SQL queries that have "<column> != ''   " comparisons should use the SQLTransformer, as on Oracle DBs the result of the comparison is "unknown" (https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm"

      Attachments

        Activity

          People

            summer.zhang Summer Zhang
            balazs.safrany-kovalik Balázs Sáfrány-Kovalik
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              4 years, 10 weeks, 4 days ago

              Packages

                Version Package
                7.0.0 DXP FP60
                7.0.0 DXP SP9
                7.0.X
                7.1.10 DXP FP3
                7.1.1 CE GA2
                7.1.10.1 SP1
                7.1.X
                Master