[
https://jira.nuxeo.com/browse/NXP-6397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-6397:
-----------------------------------
Status: Open (was: Triage)
> 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
