[OASIS Issue Tracker] (CMIS-771) Clarify the query support for secondary types

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

    [ https://issues.oasis-open.org/browse/CMIS-771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=55942#comment-55942 ] 

Andy Hind commented on CMIS-771:
--------------------------------

I suggest the following changes:

Section 2.1.14.1.1
==================

A query can only return objects of one base type: cmis:document, cmis:folder, cmis:relationship, cmis:policy or cmis:item.
One of these types, or a descendant, must be specified in the FROM clause of a query.
Secondary types must not appear in the FROM clause as they may have been applied to objects of more than one base type.
Secondary types may be used in a JOIN clause. 

BNF
===


Add

<primary table reference>    ::=  <table name> [ [ AS ] <correlation name> ] 
<secondary table reference>  ::=  <secondary type table name> [ [ AS ] <correlation name> ] 
<from table reference>       ::= <primary table reference> | <joined table>


Change

<from clause> ::= FROM <from table reference>
<table reference>       ::= <primary table reference> | <secondary type table name> | <joined table>
<joined table> ::= "(" <joined table> ")"
| <from table reference> [ <join type> ] JOIN <table reference> <join specification>

> Clarify the query support for secondary types
> ---------------------------------------------
>
>                 Key: CMIS-771
>                 URL: https://issues.oasis-open.org/browse/CMIS-771
>             Project: OASIS Content Management Interoperability Services (CMIS) TC
>          Issue Type: Bug
>          Components: Domain Model
>    Affects Versions: V1.1 Errata
>            Reporter: Andy Hind
>            Priority: Critical
>
> The query support for secondary types is not clear.
> CMIS-742 defined the query behaviour for secondary types in CMIS 1.1.
> CMIS-742 and section  2.1.14.2 of the 1.1 specification imply that secondary types can be used alone.
> For example
> SELECT * from cmis:rm_hold
> There are two issues with this.
> 1) It implies that heterogeneous objects may be returned from a query, as the same secondary type could be applied to both documents and folders.  Heterogeneous object can not be returned for all repositories.
> 2) Section 2.1.14.2.1, BNF Grammar, allows only <table name> in both the <from clause> and <joined table>. <table name> is defined to identify a primary type. There is a <secondary type table name> defined but only used in <column reference>. It looks like this was overlooked in the changes made for CMIS-742. The current BNF implies that only primary types may appear in FROM and JOIN clauses.



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)