[teiid-issues] [JBoss JIRA] (TEIID-3792) Add support for searching in array types

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3792:
---------------------------------------

Updated the parser and other logic to allow quantified comparison with arrays -

expression operator ALL|SOME (array_expression)

for now this just reused the SubqueryCompareCriteria.  This is full support rather than a rewrite to an intermediate form using array_iterate as it will be easier to determine pushdown in this form.  However pushdown support was not yet added, but is supported for example by postgresql.

> Add support for searching in array types
> ----------------------------------------
>
>                 Key: TEIID-3792
>                 URL: https://issues.jboss.org/browse/TEIID-3792
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0
>
>
> We should support a simple syntax for searching within an array, such as the quantified comparison and/or a function to get the index of a value in an array.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)