[CMIS-1012] OpenCMIS query parser does not allow selecting secondary properties in simple queries

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: OpenCMIS 1.0.0
• Fix Version/s: OpenCMIS 1.1.0
• Component/s: opencmis-server
• Assignee: Unassigned
• Reporter: Jens Hübel
• Created: 14/Feb/17 13:42
• Updated: 31/Mar/17 14:47
• Resolved: 24/Mar/17 14:17

Description

The query parser in OpenCMIS allows only to select properties which are part of a type that is mentioned in a FROM or JOIN statement. It is not possible to retrieve properties from secondary types when doing a simple query on a primary type (unless you use SELECT *).

Example:
SELECT cmis:name, cmis:objectId, mySecondaryProperty FROM cmis:document WHERE cmis:createdBy = 'joe'

fails to parse with
mySecondaryProperty is not a property query name in any of the types in from