[
https://jira.nuxeo.com/browse/NXP-8723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-8723:
-----------------------------------
Status: Open (was: Triage)
> Querying for complex list types and ordering is failing, for instance on the
> files schema
> -----------------------------------------------------------------------------------------
>
> Key: NXP-8723
> URL: https://jira.nuxeo.com/browse/NXP-8723
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.5, 5.5.0-HF01
> Environment: PostgreSQL / h2
> Reporter: Antoine Taillefer
> Assignee: Florent Guillaume
> Priority: Major
> Attachments: complex_list_query_fail.log
>
>
> Making the following query fails:
> {code}
> Select * from Document where files/*/filename = 'myFile.txt' order by dc:title
> {code}
> Stack trace summary:
> {code}
> 2012-01-24 19:22:58,125 WARN
> [org.nuxeo.ecm.platform.query.nxql.CoreQueryDocumentPageProvider] Failed to
> execute query: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear
> in select list
> Position : 1737
> org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR: for
> SELECT DISTINCT, ORDER BY expressions must appear in select list
> Position : 1737
> at
> org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1571)
> at
> org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1481)
> ...
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.nuxeo.ecm.core.query.QueryException. message: Invalid query: Select *
> from Document where files/*/filename = 'myFile.txt' order by dc:title
> at
> org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:594)
> at
> org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1518)
> ... 169 more
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.nuxeo.ecm.core.storage.StorageException. message: Invalid query: Select *
> from Document where files/*/filename = 'myFile.txt' order by dc:title
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:769)
> at
> org.nuxeo.ecm.core.storage.sql.CachingMapper.query(CachingMapper.java:85)
> at
> org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1145)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:335)
> at
> org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:589)
> ... 170 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
> Position : 1737
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> {code}
> Attached full stack trace.
--
This message is automatically generated by JIRA.
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
