[teiid-issues] [JBoss JIRA] Commented: (TEIID-203) Make connector capabilites more granular.

[Steven Hawkins (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12465657#action_12465657 ] 

Steven Hawkins commented on TEIID-203:
--------------------------------------

After some initial work here's a possible set of capabilities changes (which include simplifications that could fall under TEIID-529):

replace supportsAggregates with supportsGroupBy and supportsHaving.  Individual aggregate support would still be conveyed by supportsAggregateXXX
remove supportsCompareCriteria - it's redundant with the individual compares
remove supportsCompareCriteriaNotEquals - it's implied by supportsNotCriteria and supportsCompareCriteriaEquals
replace all supportsCompareGreater/Less... with a single supportsCompareCriteriaOrdered
replace supportsJoins with supportsInnerJoins
remove supportsQuantifiedCompareCriteria - it's redundant with the individual quantified supports
remove supportsScalarFunctions - it's redundant with the supported funcitons list
replace supportsSelectLiteral with supportsSelectExpression - which covers the ability to project anything other than an element
remove supportsAndCriteria - not used and little chance of it being used
add getSupportedJoinCriteria that returns an enum SupportedJoinCriteria that can be one of {ANY, THETA, EQUI, KEY}

> Make connector capabilites more granular.
> -----------------------------------------
>
>                 Key: TEIID-203
>                 URL: https://jira.jboss.org/jira/browse/TEIID-203
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Connector API, Query Engine
>    Affects Versions: 6.0.0
>            Reporter: John Doyle
>            Assignee: Steven Hawkins
>             Fix For: 6.1.0
>
>
> Some connector capabilites are only available in combination with others.  For example, if you wish to support the SupportsAggregatesCount capability, you have to also support the SupportsAggregates capability(GROUP BY and HAVING).  This requirement creates additional requirements for a connector where the source syustem cabilities do not correspond with the relationships we have defined between capabilites.
> For instance, the SQL supported by salesforce can include the count(*) function, but it does not support GROUP BY or HAVING.  Because we require c connector to support SupportsAggregates befrore it can support count(*), the connector is required to implement those functions if it wishes to pus down count(*).

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