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.0-HF01, 5.5
Environment: PostgreSQL / h2
Reporter: Antoine Taillefer
Assignee: Florent Guillaume
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
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
