[
http://jira.nuxeo.org/browse/NXP-3595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benjamin Jalon resolved NXP-3595.
---------------------------------
Resolution: Fixed
Fix Version/s: 5.2.1
Change Set : 11c57005b829
> Exception for Translation to SQL of a NXQL query order by
> ecm:currentLifeCycleState or ecm:versionLabel
> -------------------------------------------------------------------------------------------------------
>
> Key: NXP-3595
> URL: http://jira.nuxeo.org/browse/NXP-3595
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Reporter: Benjamin Jalon
> Assignee: Benjamin Jalon
> Fix For: 5.2.1
>
>
> this query "SELECT * FROM Document ORDER BY ecm:currentLifeCycleState"
> causes an exception :
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
> SELECT * FROM Document WHERE ecm:parentId =
> 'dbf2dbe5-1bc8-41b3-a558-330d9f3026da' AND ecm:isCheckedInVersion = 0 AND
> ecm:mixinType != 'HiddenInNavigation' AND ecm:currentLifeCycleState !=
> 'deleted' ORDER BY ecm:currentLifeCycleState
> at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:549)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:246)
>
> at
> org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:380)
>
> ... 164 more
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.postgresql.util.PSQLException. message: ERROR: for SELECT DISTINCT, ORDER
> BY expressions must appear in select list
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
