[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (CMIS-716) Query for v1.1
[ http://tools.oasis-open.org/issues/browse/CMIS-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=25271#action_25271 ]
Florent Guillaume commented on CMIS-716:
----------------------------------------
As noted by Jane, SELECT * FROM heath insurance, pension insurance is ambiguous and in the SQL world would mean an implicit cross join. So I'm -1 on this syntax.
Adding UNION is possible but this gets quickly complicated on the implementation side though, for a benefit to most clients that is small as the UNION can often be done in two queries (unless ordering is used).
Back to the initial use case, is there something that is not covered by a simple query like:
SELECT * FROM insurance WHERE cmis:objectTypeId IN ('heath insurance', 'pension insurance') AND ...
> 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]