Uploaded image for project: 'PUBLIC - Liferay Commerce'
  1. PUBLIC - Liferay Commerce
  2. COMMERCE-3349

Upgrade process error with PostgreSQL: 'operator does not exist: boolean = integer'

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.6, 2.0.7
    • Fix Version/s: 2.1.0
    • Component/s: Upgrades
    • Labels:
      None

      Description

      Summary:

      During the upgrading process from commerce 1.1.6 to commerce 2.0.7 using PostgreSQL as database, an exception is shown:

      2020-03-19 11:57:16.940 ERROR [main][LogService:93] Failed upgrade process for module com.liferay.commerce.service com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: el operador no existe: boolean = integer_ Hint: Ningún operador coincide con el nombre y el tipo de los argumentos. Puede ser necesario agregar conversiones explícitas de tipos._ Position: 130 [Sanitized] 

      Full exception log attached.

      Other test:

      The upgrade process works fine with MySQL 5.7 as database: no exceptions are shown.

      Testing environment: DXP 7.1 FP16, commerce 2.0.7.hotfix-213-7110, PostgreSQL 10, jdk1.8.0_241

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              danny.situ Danny Situ
              Reporter:
              daniel.mijarra Daniel Mijarra García
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  2.1.0