Fix versions upgrade with PostgreSQL and implicit casts
-------------------------------------------------------
Key: NXP-6397
URL: https://jira.nuxeo.com/browse/NXP-6397
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Affects Versions: 5.4
Reporter: Florent Guillaume
Assignee: Florent Guillaume
Fix For: 5.4.1
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()
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
