[NXP-10303] Allow NXQL query with prefix on a complex property schema defined without prefix - Nuxeo Issue Tracker

XML

Word

Printable

With some fields, if we write a where clause using the schema prefix, for example with

SELECT * FROM Document WHERE file:content/length > 10

we end up with an exception:

Exception: org.nuxeo.ecm.core.storage.sql.jdbc.QueryMaker$QueryMakerException.
 message: No such property file:content/length

whereas this query will be correct

SELECT * FROM Document WHERE content/length > 10

This problem seems to happen at least with "file" and "files" schema.

is required by

NXP-15426 Support NXQL canonical name for complex properties without prefix

NXP-15098 Fix NXQL complex property name in Elasticsearch

Estimated:

Remaining:

Logged:

Not Specified