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

[John Doyle (JIRA)]

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

John Doyle commented on TEIID-203:
----------------------------------

Both the reference type and the multi-select picklist are Strings.  The multi-select is a semicolon separated string of values.  The reference is a primary key to another object.

Salesforce will throw a "malformed query" if we use "Order By" on a text  area or a multi-select picklist.  

IN is not allowed for the multi-select, only = and != as well as the two functions we provide to implement the includes and excludes functions.

> 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