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

            Assignee:
            summer.zhang Summer Zhang
            Reporter:
            balazs.safrany-kovalik Balázs Sáfrány-Kovalik
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              2 years, 11 weeks 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