[OASIS Issue Tracker] Commented: (CMIS-716) Query for v1.1

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/CMIS-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=25260#action_25260 ] 

Jane Doong commented on CMIS-716:
---------------------------------

Both the JOIN section and the BNF grammar do not support implicit joins:

"Only explicit joins using the "JOIN" keyword is supported. Queries MUST NOT include implicit joins as 
2447 part of the WHERE clause of a CMIS query."

Your sample query, "SELECT * FROM heath insurance, pension insurance" could be ambiguous 
in that it can be used as an implicit JOIN, or a UNION in your example.  The fact that
JOIN is an optional capability, I would like a clearer distinction here.

So I am also interested in seeing an extension to add UNION.

SELECT * FROM health insurance
UNION
SELECT * FROM pension insurance 

This could be another optional capability attribute for the repository, e.g. capabilityUnion.

> Query for v1.1
> --------------
>
>                 Key: CMIS-716
>                 URL: http://tools.oasis-open.org/issues/browse/CMIS-716
>             Project: OASIS Content Management Interoperability Services (CMIS) TC
>          Issue Type: Improvement
>          Components: Domain Model
>    Affects Versions: V1.1
>            Reporter: David Choy
>
> Per discussion at the 21 March 2011 TC meeting, this item is created as a forum to collect input on any aspect of the query capability that may need change/extension for v1.1. Depending on the input, the TC will determine the next step.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira