Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-6397

Fix versions upgrade with PostgreSQL and implicit casts

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.4.2-RC1, 5.4.2
    • Component/s: None

      Description

      Version upgrades sometimes fails:

      org.nuxeo.ecm.core.storage.StorageException: org.postgresql.util.PSQLException: ERROR: operator is not unique: integer || unknown
      Hint: Could not choose a best candidate operator. You might need to add explicit type casts.
      Context: PL/pgSQL function "nx_upgrade_versions" line 21 at SQL statement

      ERROR: operator is not unique: integer || unknown at character 34
      HINT: Could not choose a best candidate operator. You might need to add explicit type casts.
      QUERY: UPDATE versions SET label = $1 || '.' || $2 , islatest = $3 , islatestmajor = $4 AND $5 WHERE id = $6
      CONTEXT: PL/pgSQL function "nx_upgrade_versions" line 21 at SQL statement
      STATEMENT: SELECT nx_upgrade_versions()

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: