Minor The following CMIS query fails when executed in CMISQL -> SQL mode:
SELECT f.* FROM File f WHERE CONTAINS(f, 'title1')
org.nuxeo.ecm.core.api.NuxeoException: Invalid query: CMISQL: SELECT f.* FROM File f WHERE CONTAINS(f, 'title1') at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.queryAndFetch(JDBCMapper.java:862) at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.queryAndFetch(SoftRefCachingMapper.java:93) at org.nuxeo.ecm.core.storage.sql.SessionImpl.queryAndFetch(SessionImpl.java:1188) at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.queryAndFetch(ConnectionImpl.java:330) at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.queryAndFetch(SQLSession.java:455) at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1185) at org.nuxeo.ecm.core.opencmis.impl.server.NuxeoCmisService.queryAndFetch(NuxeoCmisService.java:1500) at org.nuxeo.ecm.core.opencmis.impl.server.NuxeoCmisService.query(NuxeoCmisService.java:1429) at org.apache.chemistry.opencmis.server.support.wrapper.ConformanceCmisServiceWrapper.query(ConformanceCmisServiceWrapper.java:1142) at org.nuxeo.ecm.core.opencmis.impl.TestCmisBinding.query(TestCmisBinding.java:240) at org.nuxeo.ecm.core.opencmis.impl.TestCmisBinding.testQueryContainsQualifier(TestCmisBinding.java:2158) Caused by: org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "_f_hierarchy" Position: 1352 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) at org.nuxeo.ecm.core.storage.sql.jdbc.ResultSetQueryResult.<init>(ResultSetQueryResult.java:69) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.queryAndFetch(JDBCMapper.java:859) ... 48 more
Note that the query without qualifier works:
SELECT * FROM File WHERE CONTAINS('title1')
